Oracle Database 12c: Installation and Administration Free Practice Exam Questions

211 real Oracle Database 12c: Installation and Administration exam questions with answers and AI explanations. Oracle certification prep — page 17 of 22.

  1. Question 184: Your database is configured for ARCHIVELOG mode, and a daily full database backup is taken. RMAN is configured to perform control file autobackup. In which thr…
  2. Question 188: Examine the following command: CREATE TABLE (prod_id number(4), Prod_name varchar2 (20), Category_id number(30), Quantity_on_hand number (3) INVISIBLE); Which…
  3. Question 190: You use multiple temporary tables frequently in your database. Which two are benefits of configuring temporary undo? (Choose two.)
  4. Question 191: Which two categories of segments are analyzed by the Automatic Segment Advisor? (Choose two.)
  5. Question 192: In which two scenarios do you use SQL* Loader to load data? (Choose two.)
  6. Question 193: Your database is open and the listener LISTENER is up. You issue the command: LSNRCTL> RELOAD - What is the effect of reload on sessions that were originally e…
  7. Question 196: Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Da…
  8. Question 197: Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance Oracle 11g R2 database to Oracle Database 12c?
  9. Question 198: Which three statements are true concerning unplugging a pluggable database (PDB)? (Choose three.)
  10. Question 199: Which two statements are true concerning dropping a pluggable database (PDB)? (Choose two.)