Oracle Database 12cR2 Administration - 1Z0-072 Exam Questions [2026]

QUESTION NO: 1
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?

A. ROW STORE COMPRESS BASIC B. COLUMN STORE COMPRESS FOR QUERY LOW C. ROW STORE COMPRESS ADVANCED D. COLUMN STORE COMPRESS FOR ARCHIVE LOW E. COLUMN STORE COMPRESS FOR ARCHIVE HIGH

Correct Answer: C

QUESTION NO: 2
Which two tasks can you perform by using DBCA for a new database?

A. Enable flashback. B. Register it with an available Enterprise Manager Management server. C. Create user tablespaces. D. Configure incremental backups. E. Configure a nonstandard block size.

Correct Answer: B,C

QUESTION NO: 3
Which two tasks does DBUA perform by default? (Choose two.)

A. adding more data files if there is insufficient disk space for the SYSTEM tablespace during the upgrade B. starting the source database instance if not started C. setting user tablespaces to "read only" before starting the upgrade D. enabling flashback in the source database if not enabled E. running the Pre-Upgrade information tool

Correct Answer: C,E

QUESTION NO: 4
Which two are true about conventional path SQL load? (Choose two.)

A. It cannot load data into clustered tables. B. It always generates redo. C. It locks objects being processed. D. It does not generate UNDO. E. It enforces referential integrity constraints.

Correct Answer: D,E

QUESTION NO: 5
In the ORCL database, UNDOTBS1 is the active undo tablespace with a fixed size of 70 MB and RETENTION GUARANTEE.
UNDO_RETENTION is set to 15 minutes and the tablespace does not have AUTOEXTEND on.
Which statement is true about a transaction if UNDOTBS1 fills with uncommitted undo within 10 minutes of the transaction's first update?

A. It succeeds and the generated undo is stored in SYSTEM. B. It succeeds and the least recently used undo block UNDOTBS1 is overwritten by the generated undo. C. It succeeds and the generated undo is stored in SYSAUX. D. It fails and returns the error message "ORA=30036": unable to extend segment by 8 in undo tablespace 'UNDOTBS1'". E. It succeeds and the generated undo is stored in TEMP. F. It fails and returns the error message "Snapshot too old".

Correct Answer: B

QUESTION NO: 6
Which two are true about complete and incomplete recovery? (Choose two.)

A. Uncommitted transactions will be rolled back after complete recovery completes. B. Incomplete recovery is possible only when the database is open. C. Only incremental backups can be used to roll forward the database while performing complete recovery. D. Uncommitted transactions will be rolled back after incomplete recovery completes. E. The database must have FLASHBACK enabled in order to perform incomplete recovery.

Correct Answer: A,C

QUESTION NO: 7
Which two types of files are opened by a database instance in the NOMOUNT state?

A. the initialization parameter file B. online redo logs C. control files D. the alert log E. data files

Correct Answer: A,E

QUESTION NO: 8
Which two are true about direct path load?

A. It uses the database buffer cache. B. DML statements may occur on tables being loaded. C. It fires insert triggers, if any. D. It enforces only primary key, unique, and not NULL, constraints. E. It writes only to blocks above the high-water mark.

Correct Answer: B,C

QUESTION NO: 9
Which two are true about the AL32UTF8 character set? (Choose two.)

A. It is used to store PL/SQL source code. B. It is used to encode data for columns of any data type. C. It improves the I/O performance of a database compared to other character sets. D. It supports multilingual databases. E. It uses less space than other character sets, for all data types.

Correct Answer: D,E