Free 1Z0-072 Questions for Oracle Database 12cR2 Administration 1Z0-072 Exam as PDF & Practice Test Engine

Exam Code/Number: 1Z0-072
Exam Name/Title: Oracle Database 12cR2 Administration
Certification Provider: Oracle
Corresponding Certification: Oracle Database 12c R2

Exam Questions: 88
Updated On: May 31, 2026

Question #1

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?

A. T1, an index segment for the primary key, and a LOB segment only

B. T1, an index segment for the primary key, a LOB segment, and lobindex segment

C. T1 and an index segment created for the primary key only

D. T1 only

Discussion 0

Correct Answer: A Vote an answer

Question #2

Which two are responsibilities of an Oracle DBA regarding database availability, backup, and recovery?

A. implementing FLASHBACK DATA ARCHIVE to decrease MTTR

B. decreasing Mean Time Between Failures (MTBF) by configuring FLASHBACK mode

C. decreasing Mean Time to Recover (MTTR) by configuring FLASHBACK mode

D. implementing FLASHBACK DATA ARCHIVE to decrease MTBF

E. ensuring that critical components are protected by implementing redundancy

Discussion 0

Correct Answer: C,E Vote an answer

Question #3

Which is true about revoking roles?

A. Only users who are granted the DBA role can revoke a role.

B. Only users who are granted SYSDBA can revoke a role.

C. Users can revoke a role that is granted to them through other roles.

D. Users who have the GRANT ANY ROLE privilege can revoke any role.

E. Users who are granted a role with ADMIN OPTION can revoke that role only from users to whom they have granted the role.

Discussion 0

Correct Answer: E Vote an answer

Question #4

In a database, the default temporary tablespace is TEMP and USER1's default tablespace is DATA.
Examine these parameters:

Which tablespace stores UNDO generated by USER1's DML on temporary tables?

A. DATA

B. TEMP

C. SYSAUX

D. UNDOTBS1

E. SYSTEM

Discussion 0

Correct Answer: B Vote an answer

Question #5

Which two are true about users who are granted SYSDBA or SYSOPER privileges? (Choose two.)

A. Only users granted SYSDBA can query or update tables in all user schemas.

B. Users granted either SYSDBA or SYSOPER can query data in all user schemas.

C. Users granted either SYSDBA or SYSOPER connect to an instance as SYS.

D. Only users granted SYSDBA can start up and shut down a database instance.

E. Users granted either SYSDBA or SYSOPER can mount or open a database.

F. Only users granted SYSDBA can take a complete backup of a database.

Discussion 0

Correct Answer: C,F Vote an answer

Question #6

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the MMON background process? (Choose three.)

A. ADDM can recommend extending the buffer cache.

B. By default, AWR snapshots are automatically purged after eight days.

C. ADDM performs its analysis only whenever a DBA requests it.

D. AWR snapshots must be deleted when no longer required by ADDM.

E. ADDM can recommend shrinking the buffer cache.

F. By default, MMON creates an AWR snapshot every 30 minutes.

Discussion 0

Correct Answer: B,C,E Vote an answer

Question #7

Which three are true about the Oracle Optimizer? (Choose three.)

A. It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary.

B. It updates stale object statistics in the Data Dictionary.

C. It determines the optimal table join order and method.

D. It can optimize only SELECT statements.

E. It can re-optimize execution plans after previous executions detect suboptimal plans.

F. It will only generate SQL Plan Directives specific to a given SQL statement.

Discussion 0

Correct Answer: A,C,D Vote an answer

Question #8

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?

A. It suspends the transaction, which can be resumed by increasing USER1's quota on UNDOTBS2.

B. It returns an error because UNDOTBS2 is fixed size.

C. It returns an error because UNDOTBS2 is fixed size and has RETENTION GUARANTEE.

D. It returns an error because UNDOTBS2 has RETENTION GUARANTEE.

E. It suspends the transaction, which can be resumed by setting UNDOTBS1 as the active undo tablespace.

F. It suspends the transaction, which can be resumed by increasing the size of UNDOTBS2.

Discussion 0

Correct Answer: B Vote an answer

Question #9

For which three purposes is UNDO used? (Choose three.)

A. flashback queries

B. ROLLBACK operations

C. the roll forward phase of instance recovery

D. RESTORE DATABASE operations

E. FLASHBACK TABLE <tablename> TO BEFORE DROP operations

F. read consistency

Discussion 0

Correct Answer: A,B,F Vote an answer

Free 1Z0-072 Questions for Oracle Database 12cR2 Administration 1Z0-072 Exam as PDF & Practice Test Engine

Download Free Oracle 1Z0-072 Demo