Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)? (Choose three.)

What happens if a maintenance window closes before a job that collects optimizer statistics completes?

Which three statements are true concerning unplugging a pluggable database (PDB)? (Choose three.)

Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?

What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving enabled?

Which three statements are true PFILEs, SPFILEs or both? (Choose three.)

You configure your database Instance to support shared server connections. Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection? (Choose two.)

You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output: Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file? (Choose two.)