File Info
| Exam | Oracle Database 12cR2 Administration |
| Number | 1z0-072 |
| File Name | Oracle.1z0-072.VCEplus.2019-10-17.80q.tqb |
| Size | 2 MB |
| Posted | Oct 17, 2019 |
| Download | Oracle.1z0-072.VCEplus.2019-10-17.80q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
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
Question 2
Which three failures require intervention for recovery? (Choose three.)
- a user error such as dropping the wrong table
- network interface card (NIC) failure
- user process failure
- statement failure
- media failure
Correct answer: ACE
Question 3
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.
Correct answer: ABF
