Oracle Database 12cR2 Administration - 1Z0-072 Exam Practice Test
Which three are true about Oracle Managed Files (OMF)? (Choose three.)
Correct Answer: A,B,D
Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the MMON background process? (Choose three.)
Correct Answer: B,D,E
A user complains about poor database performance. You suspect that the user's session is waiting for an event to complete.
You want to verify this.
Which two views may reveal for what the user's session is currently waiting? (Choose two.)
You want to verify this.
Which two views may reveal for what the user's session is currently waiting? (Choose two.)
Correct Answer: B,E
In the ORCL database, DEFERRED_SEGMENT_CREATION is FALSE.
Examine this command:
SQL> CREATE TABLE t1(c1 INT PRIMARY KEY, c2 CLOB);
Which table segments are created?
Examine this command:
SQL> CREATE TABLE t1(c1 INT PRIMARY KEY, c2 CLOB);
Which table segments are created?
Correct Answer: B
Your client application and Oracle database are located on different hosts.
Which statement is true about establishing a connection between them?
Which statement is true about establishing a connection between them?
Correct Answer: D
Your database is configured for shared server and the SGA_TARGET parameter is set to a non-zero value.
Which three actions could help in handling a large number of concurrent users?
Which three actions could help in handling a large number of concurrent users?
Correct Answer: A,C,E
Which two are true about the roles? (Choose two.)
Correct Answer: B,D
Which is true about unexpired undo?
Correct Answer: D
A database is configured to use automatic undo management with temporary undo enabled. An update is executed on a heap-organized table stored in the TBS1 tablespace. Where is the undo stored?
Correct Answer: B