Which two are true about data dictionary views and contents and output in a CDB? (Choose two.)
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 SELECTDBMS_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.reportwcol_usage(SH, 'customers') from dual statement.Identify the correct sequence of steps.
Identify three reasons for using a recovery catalog with Recovery Manager (RMAN). (Choose three.)
Examine the initialization parameter that is set in the PFILE:DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/'You execute the following command to create theCDB1. container database (CDB):SQL>CREATEDATABASECDB1 -DEFAULTTABLESPACE users -DEFAULTTEMPORARY TABLESPACEtemp -UNDO TABLESPACEundotbsl -ENABLEPLUGGA3LEDATABASE -SEED -SYSTEMDATAFILESSIZE125M AUTOEXTEND ON NEXT10M MAXSIZEUNLIMITEDSYSAUXDATAFILESSIZE100M;Which three statements are true?
You take regular backups of one of your production databases by using RMAN with a recovery catalog.You have added two new tablespaces to this database which must be included in future backups.Which process occurs which allows the new backups to contain the new datafiles?
Which two statements are true about scheduling operations in a pluggable database (PDB)?
