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

  1. Question 179: Which two statements are true about tablespaces in multitenant container databases (CDBs)?
  2. Question 180: Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)?
  3. Question 181: You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this setting?
  4. Question 182: As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single…
  5. Question 183: You issue the command: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; Which statement is true about the command?
  6. Question 185: Examine the command: SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL; In which two scenarios is this command required?
  7. Question 186: You must unload data from the orders, order_items, and products database tables to four files using the External Tables. CREATE TABLE orders_ext - (order_id, o…