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

Question 159: You need to perform a block media recovery on the tools01.dbf data file in your database by using Recovery Manager (RMAN). Which two are prerequisites for perf…
Question 160: In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20. Which two storage-tiering actions might be autom…
Question 161: You want to capture column group usage and gather extended statistics for better cardinality estimates for the customers table in the SH schema. Examine the fo…
Question 162: The following parameters are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You wa…
Question 163: Your database is running in archivelog mode and a nightly backup of the database, along with an autobackup of the control file, is taken by using RMAN. Because…
Question 164: Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?
Question 165: You install "Oracle Grid Infrastructure for a standalone server" on a host on which the orcl1 and orcl2 databases both have their instances running. Which two…
Question 166: In your multitenant container database (CDB) that contains pluggable databases (PDBs), the hr user executes the following commands to create and grant privileg…
Question 167: Examine the command used to perform an incremental level-0 backup: RMAN>BACKUPINCREMENTALLEVEL0DATABASE; To enable block change tracking, after the incremental…
Question 168: You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%, respectively. From the tablespace space usage metrics, yo…