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

  1. Question 116: Which two are true about incremental backups? (Choose two.)
  2. Question 117: You want to create a guaranteed restore point for your database by executing the command: SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE; Identi…
  3. Question 118: In which three scenarios is media recovery required?
  4. Question 119: Users report this error message when inserting rows into the orders table: ERROR atline1: ORA-01654f:unable to extend index USERS.ORDERS_IND by 8in tablespace…
  5. Question 120: Evaluate these statements: CREATE TABLE purchase_orders - (po_idNUMBER(4), po_dateTIMESTAMP, supplier_idNUM8ER(6), po_totalNUMBER(8,2), CONSTRAINT order_pk PRI…
  6. Question 121: Which four actions are possible during an Online Datafile Move operation?
  7. Question 122: You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media fai…
  8. Question 123: You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common…
  9. Question 124: user_data is a nonencryptedtablespace containing tables with data. You must encrypt ail data in this tablespace. Which three methods can do this?
  10. Question 125: You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or featu…