Oracle Database 12c: Advanced Administration Free Practice Exam Questions

177 real Oracle Database 12c: Advanced Administration exam questions with answers and AI explanations. Oracle certification prep — page 11 of 18.

1. Question 106: Which three statements are true about the keystore storage framework for transparent data encryption?
2. Question 107: Your database instance is abnormally terminated because of a power outage. At the next startup, from which point in the redo log does the recovery start?
3. Question 108: For which two requirements would you use the Database Resource Manager?
4. Question 109: You set the following parameters in the parameter file and restart the database instance: NEMORY_MAX_TARGET=0 - MEMORY__TARGET=500M - PGA_AGGREGATE_TARGET=90M…
5. Question 110: Which three statements are true about persistent lightweight jobs?
6. Question 111: Which two statements are true about unified auditing?
7. Question 112: You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes fo…
8. Question 113: Which two are prerequisites for performing Flashback Transaction?
9. Question 114: In your database, the user SCOTT wants to retrieve the dropped HR. EMPLOYEES table by using the command: SQL> FLASHBACK TABLE HR.EMPLOYEES TO BEFORE DROP; What…
10. Question 115: You plan to create a new PDB by copying PDB$SEED. Which two requirements ensure a successful creation? (Choose two.)