Which action takes place when an incremental checkpoint occurs?
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 following steps:1. Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS (SH, CUSTOMERS) FROM dual statement.2. Execute the DBMS_STATS.SEED_COL_USAGE (null, SH, 500) procedure.3. Execute the required queries on the CUSTOMERS table.4. Issue the SELECT DBMS_STATS.REPORT_COL_USAGE (SH, CUSTOMERS) FROM dual statement.Identify the correct sequence of steps.
Your database runs in NOARCHIVELOG mode.Whole database backups are taken daily.A media failure damages data files belonging to the USERS tablespace and the online redo log files.The hardware that is causing this damage is not repairable.You issue the SHUTDOWN ABORT command.Examine these steps:1. Restore only the damaged files from the whole database backup to a new location.2. Restore the whole database backup to a new location.3. Edit the restored initialization parameter file to indicate the new location of the control files.4. Issue the STARTUP MOUNT command.5. Issue the STARTUP NOMOUNT command.6. Issue the RECOVER DATABASE command.7. Update the control file to reflect the new data file locations by using the ALTER DATABASE RENAME FILE command.8. Specify a new location for each affected online log by issuing the command:RECOVER DATABASE UNTIL CANCEL -9. Open the database in RESETLOGS mode.Identify the minimum steps required in the correct sequence to recover your database.
Which three statements are true about Automatic Workload Repository (AWR)?
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?
Which two statements are true about Oracle Managed Files (OMF)? (Choose two.)
