Examine the commands executed in CDBS ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB): SQL> CREATE ROLE c ##role1 CONTAINER-ALL; SQL> GRANT CREATE SESSION, CREATE TABLE TO c##role1 CONTAINER’ALL; SQL>CREATE USER c##adnin IDENTIFIED BY orcl123;…
The CATDB12C database contains an Oracle Database 12c catalog schema owned by the rci2c user. The CATD3H database contains an Oracle Database Ug catalog schema owned by the rch user. A database with dbid=H2324I is registered in the catdbII catalog.…
The CATDBI2c database contains an Oracle Database 12c catalog schema owned by the rc12c user. The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RCII user. A database with DBID=1423241 is registered in the CATDB11 catalog.…
You issue the command: SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE; Which statement is true about the command? A. It creates a copy of the control file and stores it in the location specified in the diagnostic_dest initialization parameter. B.…
You create a default Flashback Data Archive FLA1and enable it for the EMPLOYEES table in the HR schema. After a few days, you want to alter the EMPLOYEES table by executing the command: SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);…
Which two statements are true regarding Oracle Data Pump? A. EXPDP and IMPDP are the client components of Oracle Data Pump. B. DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients. C. Oracle Data Pump export and…
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)? A. A DBA can check specific tables with the DMU B. The database to be migrated must be opened read-only. C. The release of…
Identify three reasons for using a recovery catalog with Recovery Manager (RMAN). A. to store backup information of multiple databases in one place B. to restrict the amount of space that is used by backups C. to maintain a backup…
Examine the command to duplicate a database: RMAN> DUPLICATE TARGET DATABASE TO cdb PLUGGABLE DATABASE pdb1, pdb5; Which two statements are true about the DUPLICATE command? A. The SPFILE is copied along with the data files of the pluggable databases…
As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database. Which step should you perform next to start the upgrade of the…