Welcome to TestSimulate

Pass Your Next Certification Exam Fast!

Everything you need to prepare, learn & pass your certification exam easily.

365 days free updates. First attempt guaranteed success.

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.)

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?

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