Download Oracle.1z0-072.VCEplus.2019-10-17.80q.tqb

Vendor:	Oracle
Exam Code:	1z0-072
Exam Name:	Oracle Database 12cR2 Administration
Date:	Oct 17, 2019
File Size:	2 MB
Downloads:	1

Download Exam

Demo Questions

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?

It suspends the transaction, which can be resumed by increasing the size of UNDOTBS2.
It returns an error because UNDOTBS2 is fixed size and has RETENTION GUARANTEE.
It suspends the transaction, which can be resumed by increasing USER1's quota on UNDOTBS2.
It returns an error because UNDOTBS2 has RETENTION GUARANTEE.
It suspends the transaction, which can be resumed by setting UNDOTBS1 as the active undo tablespace.
It returns an error because UNDOTBS2 is fixed size.

Correct answer: F

Which three failures require intervention for recovery? (Choose three.)

Correct answer: ACE

Which three are true about Oracle Managed Files (OMF)? (Choose three.)

If DB_CREATE_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_CREATE_FILE_DEST by default.
If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.
If only DB_CREATE_FILE_DEST is specified, only the data files and temp files are OMF.
If DB_RECOVERY_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_RECOVERY_FILE_DEST by default.
If DB_CREATE_ONLINE_LOG_DEST_1 is specified but DB_CREATE_FILE_DEST is not, the data files and temp files are placed in DB_CREATE_ONLINE_LOG_DEST_1 by default.
If only DB_CREATE_ONLINE_LOG_DEST_n is specified, only the redo logs and control files are OMF.