You are administering a multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode and contains pluggable databases (PDBs), PDB_1 and PDB_2.While opening pdb_1, you get an error:SQL> alter pluggable database pdb_1 open;ORA-01157: cannot identify/lock data file 11-see DBWR trace fileORA-01110: data file 11: '/u01/app/oracle/oradata/cdb1/pcb_1/example01.dbf'To repair the failure, you open an RMAN session for the target database CDB$ROOT. You execute the following as the first command:RMAN> REPAIR FAILURE;Which statement describes the consequence of the command?
What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?
You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire database along with the recovery catalog database is lost.Examine the steps required to recover the database:1.Restore an autobackup of the server parameter file.2.Restore the control file.3.Start up the database instance in nomount state.4.Mount the database.5.Restore the data files.6.Open the database with the resetlogs option.7.Recover the data files.8.Set D3ID for the database.Identify the required steps in the correct order.
Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)?
A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call.Which table organization allows for generating the bills with minimum degree of row sorting?
Which two statements are true about scheduling operations in a pluggable database (PDB)?
