Which three functions are performed by the SQL Tuning Advisor?
Which three can be performed on a Data Pump type external table? (Choose three.)
Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?
Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.Which three steps should you perform to recover the control file and make the database fully operational? (Choose three.)
A new report process containing a complex query is written, with high impact on the database. You want to collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and the CONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.What should you do to accomplish this task?
Which two statements are true about Oracle Managed Files (OMF)? (Choose two.)
