Choose three. Which three are true about Recovery Manager (RMAN)active database duplication?

Choose two. Your database is in ARCHIVELOG mode and you plan touse Flashback Database. Which two features or parameters manage spaceavailability in the fast recovery area?

Choose two. Which two are prerequisites for using FLASHBACK TABLE?

Choose two. Some archived log backups have been accidentallydeleted from storage. Which two commands should be used to update thestatus of backups in the recovery catalog to display only the missingbackups?

Examine this configuration: -1. CDB1 is a container database. 2. PDB1 and PDB2 are pluggable databases in CDB1.You execute these commands successfully: Which two are true? (Choose two.)

Choose three. PDB1 and PDB2 are pluggable databases in CDB1. Examine these commands:$ export ORACLE_SID=CDB1$ sql plus / as sysdbaSQL> STARTUP....... Database opened. SQL> SHOW PDBS CON_I D CON_NAME OPEN MODE RESTRICTED.2 PDB$ SEED READ ONLY NO .3 PDB1 MOUNTED.4 PDB2 MOUNTEDSQL> ALTER PLUGGABLE DATABASE pdb1 OPEN;Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE pdb1 SAVE STATE;Pluggable database altered. SQL> ALTER PLUGGABLE DATABASE pdb1 CLOSE;Pluggable database altered. SQL> ALTER PLUGGABLE A DATABASE pdb2 OPEN;Pluggable database altered. CDB1 is then restarted. Which three are true?

Examine this configuration: -1. CDB1 is a container database. 2. PDB1 and PDB2 are pluggable databases in CDB1. 3. PDB1 and PDB2 are OPEN in READ WRITE mode. You execute these commands successfully: Which two are true? (Choose two.)

Choose two. You are managing this configuration: -1. CDB1 is a container database. 2. PDB1 and PDB2 are two pluggable databases in CDB1. 3. USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2 . CDB1 user SYS executes these commands after connecting successfully toPDB2:SQL> ALTER SESSION SET CONTAINER=pdb1;Session altered. SQL> INSERT INTO user1.emp VALUES (100, 'Alan' ,1) ; .1 row created. SQL> INSERT INTO user1.emp VALUES (101, 'Ben' ,1) ; .1 row created. SQL> ALTER SESSION SET CONTAINER=pdb2;Session altered. SQL> INSERT INTO user2.dept VALUES(1, 'IT');Which two are true? (Choose two.)

Examine this configuration: -1. CDB1 is a container database. 2. COMMON_USER_PREFIX is C##. 3. PDB1 is a pluggable database contained in CDB1. 4. APP1_ROOT is an application container contained in CDB1. 5. APP1_PDB1 is an application PDB contained in APP1_ROOT. You execute these commands successfully: Which two are true? (Choose two.)

Choose two. Examine this configuration: -1. CDB1 is a container database. 2. APP1_ROOT is an application container contained in CDB1. 3. APP1_ROOT$SEED is the application seed contained in APP1_ROOT andsynchronized with APP1_ROOT. 4. APP1_PDB1 and APP1_PDB2 are application PDBs contained in APP1_ROOT. 5. APP1_USER_APP is an application installed in APP1_ROOT at version 1.0. 6. USER1 is a common user in APP1_ROOT and all its application PDBs, created when version 1.0 of APP1_USER_APP was installed. You execute these commands:$ sqlplus sys/oracle@localhost:1521/cdb1 as sysdbaSQL> ALTER SESSION SET CONTAINER=app1_root;Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app BEGINUPGRADE '1.0' TO '2.0';pluggable database altered. SQL> GRANT CREATE SESSION TO USER1; Grant succeeded. SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app ENDUPGRADE TO '2.0'; Pluggable database alteredSQL> ALTER SESSION SET CONTAINER=app1_pdb1;Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app SYNC;Pluggable database altered. Which two are true?

Choose two. Examine this configuration: -1. CDB1 and CDB2 are two container databases. 2. PDB1 is a pluggable database in CDB1. 3. PDB1_C1_SRV is a service for PDB1. 4. CDB1_LINK is a database linkin CDB2 referring to PDB1. 5. CDB2 is also an entry in tnsnames.ora pointing to the CDB2 databasedefault service. You execute these commands successfully:$ sql plus sys/oracle_4U@cdb2 as sysdbaSQL> CREATE PLUGGABLE DATABASE PDB1 FROM PDB1@CDB1_LINKSERVICE_NAME_CONVERT=('PDB1_C1_SRV', 'PDB1_C2_SRV') ;Which two are true?

Which three are true about Automatic Workload Repository (AWR)snapshots?

Choose three. A container database, CDB1, contains a pluggable database PDB1. Another container database is called CDB2. You want to relocate PDB1 from CDB1 to CDB2 with near-zero down time. Which three are required?

choose three Which three RMAN persistent settings can be setexplicitly?

Which two are true about gathering optimizer statistics? (Choose two.)