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 15 of 18.

1. Question 149: In a database supporting an OLTP workload, tables are frequently updated on both key and non-keycolumns. Reports are also generated by joining multiple tables.…
2. Question 150: Which two statements are true regarding Oracle Data Pump?
3. Question 151: Which three statements are true about common roles?
4. Question 152: Examine the initialization parameter that is set in the PFILE: DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/' You execute the following command to create theC…
5. Question 153: Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?
6. Question 154: Examine the parameters for your database instance: NAMETYPEVALUE - ------------------------------------------------ optimizer_adaptive_reporting_onlybooleanFAL…
7. Question 155: A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance?
8. Question 156: For which three pieces of information can you use the RMAN list command?
9. Question 157: Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)?
10. Question 158: You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command. Which two statements are true about the dependent objects…