Oracle Database 12cR2 Administration - 1Z0-072 Exam Practice Test
You want to use table compression suitable for OLTP that will:
1. Compress rows for all DML statements on that table
2. Minimize the overheads associated with compression.
Which compression option is best suited for this?
1. Compress rows for all DML statements on that table
2. Minimize the overheads associated with compression.
Which compression option is best suited for this?
Correct Answer: A
Vote an answer
Which two are true about Oracle database wait events that are described in V$EVENT_NAME? (Choose two.)
Correct Answer: B,D
Vote an answer
Which two tasks can you perform by using DBCA for a new database?
Correct Answer: A,E
Vote an answer
The ORCL database has DEFERRED_SEGMENT_CREATION set to TRUE.
UNDOTBS2 is the active undo tablespace.
Examine these commands:
USER1 executes DML, which generates more than 2 MB of UNDO.
What is the result and why?
UNDOTBS2 is the active undo tablespace.
Examine these commands:
USER1 executes DML, which generates more than 2 MB of UNDO.
What is the result and why?
Correct Answer: B
Vote an answer
Which two are true about instance recovery? (Choose two.)
Correct Answer: C,D
Vote an answer
Which two are true about users who are granted SYSDBA or SYSOPER privileges? (Choose two.)
Correct Answer: A,D
Vote an answer
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: A
Vote an answer
Examine this command and its partial output:
Why does the DB01.abc.com service show unknown status?
Why does the DB01.abc.com service show unknown status?
Correct Answer: E
Vote an answer