Oracle Upgrade Oracle DBA 11g or 12c to 12c R2 (1z1-074) Free Practice Test
Question 1
The COMPATIBLE parameter is set to 12.2.0.0.0.
Which two statements are true about SQL identifier lengths? (Choose two.)
Which two statements are true about SQL identifier lengths? (Choose two.)
Correct Answer: A,B
Question 2
Which three statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose three.)
Correct Answer: A,C,D
Question 3
From which two failure scenarios can a database be restored and recovered with the REPAIR DATABASE command? (Choose two.)
Correct Answer: B,D
Question 4
Which three statements are true about the SQL Performance Analyzer? (Choose three.)
Correct Answer: A,B,E
Question 5
Which method can be used to migrate from an on-premises Oracle Database 11g to Oracle Database 12c in the cloud if the on-premises platform is big-endian?
Correct Answer: D
Question 6
In your CDB, DEPTCDB, local undo is enabled. You successfully execute this command:
FLASHBACK PLUGGABLE DATABASE hrpdb to SCN 424366;
Which action must you perform next?
FLASHBACK PLUGGABLE DATABASE hrpdb to SCN 424366;
Which action must you perform next?
Correct Answer: D
Question 7
In a Database Cloud Service (DBCS) environment, which pre-created user has sudo privileges to run certain root commands?
Correct Answer: A
Question 8
Identify two operations for which the bkup_api utility can be used. (Choose two.)
Correct Answer: B,C