网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
多选题
Evaluate the following command and its output: SQL>SELECT * FROM dba_temp_free_space; TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output?()
A
FREE_SPACE indicates only the space that is currently unallocated.
B
ALLOCATED_SPACE indicates only the space currently allocated and in use.
C
FREE_SPACE indicates only the space that is currently allocated and available for reuse.
D
ALLOCATED_SPACE indicates both the space currently allocated and used,and the space that is available for reuse.
E
FREE_SPACE indicates both the space that is currently allocated and available for reuse,and the space that is currently unallocated.
参考答案
参考解析
解析:
暂无解析
更多 “多选题Evaluate the following command and its output: SQLSELECT * FROM dba_temp_free_space; TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output?()AFREE_SPACE indicates only the space that is currently unallocated.BALLOCATED_SPACE indicates only the space currently allocated and in use.CFREE_SPACE indicates only the space that is currently allocated and available for reuse.DALLOCATED_SPACE indicates both the space currently allocated and used,and the space that is available for reuse.EFREE_SPACE indicates both the space that is currently allocated and available for reuse,and the space that is currently unallocated.” 相关考题
考题
Evaluate the following command and its output:Which two statements correctly interpret the output?()
A. FREE_SPACE indicates only the space that is currently unallocated.B. ALLOCATED_SPACE indicates only the space currently allocated and in use.C. FREE_SPACE indicates only the space that is currently allocated and available for reuse.D. ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.E. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.
考题
Evaluate this SQL statement:In the statement, which capabilities of a SELECT statement are performed?()
A. Selection, projection, joinB. Difference, projection, joinC. Selection, intersection, joinD. Intersection, projection, joinE. Difference, projection, product
考题
Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the following command and its output:You execute the following command:RMAN BACKUP DATABASE PLUS ARCHIVELOG;Which data files will be backed up?()A. Data files that belong to only the root containerB. Data files that belong to the root container and all the pluggable databases (PDBs)C. Data files that belong to only the root container and PDB$SEEDD. Data files that belong to the root container and all the PDBs excluding PDB$SEED
考题
Given the following router output,which configuration file will the router use at its next reload?()
A.configB.clientqos.cnfC.startup-configD.running-configuration
考题
Click the Exhibit button to examine the data of the EMPLOYEES table. Evaluate this SQL statement:SELECT e.employee_id Emp_id, e.emp_name Employee, e.salary, m.employee_id Mgr_id, m.emp_name ManagerFROM employees e JOIN employees m ON (e.mgr_id = m.employee_id)AND e.salary 4000;What is its output?()A.AB.BC.CD.DE.E
考题
Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:SELECT *FROM ordersWHERE cust_id = (SELECT cust_idFROM customersWHERE cust_name = ‘Smith‘);What is the result when the query is executed?()A.AB.BC.CD.DE.E
考题
Router R1 exists in an Enterprise that uses EIGRP as its routing protocol. The show ip route command output on router R1 lists the following phrase: "Gateway of last resort is 1.1.1.1 to network 2.0.0.0". Whic h of the following is most likely to have caused this output to occur on R1?()A、R1 has been configured with an ip default- network 2.0.0.0 command.B、R1 has been configured with an ip route 0.0.0.0 0.0.0.0 1.1.1.1 command.C、R1 has been configured with an ip route 2.0.0.0 255.0.0.0 1.1.1.1 command.D、Another router has been configured with an ip default - network 2.0.0.0 command.E、Another router has been configured with an ip route 2.0.0.0 255.0.0.0 1.1.1.1 command.
考题
Running the s?command provides the following output. Running the ?s?command provides the following output.PID TTY STAT TIME PGIN SIZE RSS LIM TSIZ TRS %CPU %MEM COMMAND 22752 - A 0.08 2611 1960 3980 6276 4652 20 0.0 0.0 /usr/bin/find. 20700- A 0.07 2712 1868 2906 6379 950 28 0.0 0.0 /usr/dt/b. What is the amount of RAM, in kilobytes, used for the text and data segments for the 'find' command?()A、1960B、3980C、2611D、4652
考题
View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, you executed the following command: SQL SELECT reason,metric_value FROM dba_outstanding_alerts; REASON METRIC_VALUE ------------------------------------------------------------ ------------ Tablespace [TEST] is [28 percent]full 28.125 What could be the reason for the elimination of the other rows in the output()A、An Automatic Workload Repository snapshot has been taken recently.B、The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.C、The threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.D、The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.
考题
Evaluate the SQL statement: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?()A、0B、1C、0.00D、An error statement
考题
Examine the commands executed in the following sequence: 1:SQL CREATE ROLE mgrrole; 2:SQL GRANT create user,select any table,connect,resource TO mgrrole; 3:SQL GRANT select,update ON sh.sales TO mgrrole; 4:SQL CREATE ROLE ceo IDENTIFIED BY boss; 5:SQL GRANT mgrrole,drop any table,create any directory TO ceo; 6:SQL GRANT ceo TO mgrrole; Which statement is true about the above commands()A、The commands execute successfully.B、Command 6 produces an error because of circular role grant.C、Command 5 produces an error because a role cannot be granted to another role.D、Command 3 produces an error because the MGRROLE role already contains system privileges.E、The table created by HR remains and HR still has the CREATE TABLE system privilege.F、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
考题
Evaluate the following query: SQL SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?()A、16 B、100 C、160 D、200 E、150
考题
Examine the following commands executed in your database: SQL ALTER SESSION RECYCLEBIN=ON; Session altered SQL CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees; Table created. Further, you executed the following command to drop the table: SQL DROP TABLE emp;Table dropped. What happens in this scenario?()A、The table is moved to the SYSAUX tablespace.B、The table is moved to the SYSTEM tablespace.C、The table is removed from the database permanently.D、The table is renamed and remains in the TBSFD tablespace.
考题
Evaluate the following command and its output: SQLSELECT * FROM dba_temp_free_space; TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output?() A、 FREE_SPACE indicates only the space that is currently unallocated.B、 ALLOCATED_SPACE indicates only the space currently allocated and in use.C、 FREE_SPACE indicates only the space that is currently allocated and available for reuse.D、 ALLOCATED_SPACE indicates both the space currently allocated and used,and the space that is available for reuse.E、 FREE_SPACE indicates both the space that is currently allocated and available for reuse,and the space that is currently unallocated.
考题
Note the output of the following query; SQL SELECT flashback_archieve_name, status FROM dba_flashback_archieve; FLASHBACK_ARCHIEVE_NAME STATUS FLA1 You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table: ALTER TABLE exchange_rate FLASHBACK ARCHIEVE; What is the outcome of this command?() A、 The table uses the default Flashback Data Archive.B、 The Flashback Data Archive Is created In the SYSAUX tablespace.C、 The Flashback Data Archive is created in the same tablespace where the tables are stored.D、 The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.
考题
单选题You execute the following commands to audit database activities: SQL ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?()A
One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.B
One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.C
One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.D
One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.E
One audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.
考题
单选题The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?()A
Alice onlyB
Alice and ReenaC
Alice, Reena, and TimberD
Sue, Alice, Reena, and Timber
考题
单选题View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables. Evaluate the following SQL statement: SELECT oi.order_id, product_jd, order_date FROM order_items oi JOIN orders o USING (order_id); Which statement is true regarding the execution of this SQL statement?()A
The statement would not execute because table aliases are not allowed in the JOIN clause.B
The statement would not execute because the table alias prefix is not used in the USING clause.C
The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.D
The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.
考题
单选题A system administrator ran the iostat command because of system performance problems. The following iostat output is provided: Based on the output, which of the following is insufficient?()A
CPUB
MemoryC
Paging spaceD
Disk capacityX
考题
多选题Evaluate the following command and its output: Which two statements correctly interpret the output?()AFREE_SPACE indicates only the space that is currently unallocated.BALLOCATED_SPACE indicates only the space currently allocated and in use.CFREE_SPACE indicates only the space that is currently allocated and available for reuse.DALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.EFREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.
考题
单选题Evaluate the following query: SQL SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?()A
16 B
100 C
160 D
200 E
150
考题
单选题Evaluate the following command: SQL CREATE TABLE design_data (id NUMBER, doc CLOB) LOB(doc) STORE AS SECUREFILE(DEDUPLICATE); Which statement is true regarding the above command?()A
The LOB values are automatically compressed.B
The LOB values are cached by default in the buffer cache.C
The LOB values are automatically stored in encrypted mode.D
All LOB data that is identical in two or more rows in a LOB column share the same data blocks.
考题
单选题Note the output of the following query; SQL SELECT flashback_archieve_name, status FROM dba_flashback_archieve; FLASHBACK_ARCHIEVE_NAME STATUS FLA1 You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table: ALTER TABLE exchange_rate FLASHBACK ARCHIEVE; What is the outcome of this command?()A
The table uses the default Flashback Data Archive.B
The Flashback Data Archive Is created In the SYSAUX tablespace.C
The Flashback Data Archive is created in the same tablespace where the tables are stored.D
The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.
考题
单选题Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?()A
Data files that belong to only the root containerB
Data files that belong to the root container and all the pluggable databases (PDBs)C
Data files that belong to only the root container and PDB$SEEDD
Data files that belong to the root container and all the PDBs excluding PDB$SEED
考题
单选题Evaluate the SQL statement: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?()A
0B
1C
0.00D
An error statement
考题
单选题Examine the following commands executed in your database: SQL ALTER SESSION RECYCLEBIN=ON; Session altered SQL CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees; Table created. Further, you executed the following command to drop the table: SQL DROP TABLE emp;Table dropped. What happens in this scenario?()A
The table is moved to the SYSAUX tablespace.B
The table is moved to the SYSTEM tablespace.C
The table is removed from the database permanently.D
The table is renamed and remains in the TBSFD tablespace.
考题
单选题The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command: SQL GRANT SELECT,INSERT,UPDATE ON emp TO scott WITH GRANT OPTION; The user SCOTT executes this command to grant privileges to the user JIM: SQL GRANT SELECT,INSERT,UPDATE ON hr.emp TO jim; Now, the user HR decides to revoke privileges from JIM using this command: SQL REVOKE SELECT,INSERT,UPDATE ON emp FROM jim; Which statement is true after HR issues the REVOKE command()A
The command fails because SCOTT still has privileges.B
The command succeeds and privileges are revoked from JIM.C
The command fails because HR cannot revoke the privileges from JIM.D
The command succeeds and only HR has the privilege to perform the SELECT, INSERT, and UPDATEoperations on the EMP table.
热门标签
最新试卷