1Z1-083 Exam Question 36
Which two are true about creating RMAN backups for an Oracle container database?
1Z1-083 Exam Question 37
Choose three. Which three are true about Audit policies in container databases (CDBs)?
1Z1-083 Exam Question 38
RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database: RMAN> DUPLICATE TARGET DATABASE TO dup1 FROM ACTIVE DATABASE NOFILENAMECHECK PASSWORD FILE SPFILE; Which two statements are true about the execution of the duplicate command?
1Z1-083 Exam Question 39
Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. DEFAULT_SHARING is METADATA.
3. APP_ROOT is an application root contained in CDB1. 4. APP_PDB1 is an application PDB contained in APP_ROOT. 5. COMPANYAPP is an application contained in APP_ROOT. 6. EMP is a common table created in APP_ROOT and all its application PDBs, created when version 1.0 of COMPANYAPP was installed. You execute these commands: $ sqlplus sys/ orac1e@localhost:1521/cdb1 as sysdba SQL> ALTER SYSTEM SET DEFAULT_SHARING=DATA; System altered. SQL> ALTER SESSION SET CONTAINER=app_root; Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp BEGIN UPGRADE '1.0' TO '2.0'; pluggable database altered. SQL> ALTER TABLE emp ADD (sal NUMBER NOT NULL) ; Table altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp END UPGRADE TO '2.0'; Pluggable database altered. SQL> ALTER SESSION SET CONTAINER=app_pdb1; Session altered. SQL> DESC emp; Name Null? Type --------------------------------------------------------------ENO NUMBER ENAME VARCHAR2 (20) SQL> SELECT * FROM emp; ENO ENAME ---------------------------------100 Alan 200 Ben SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp SYNC; What will be the outcome and why?
3. APP_ROOT is an application root contained in CDB1. 4. APP_PDB1 is an application PDB contained in APP_ROOT. 5. COMPANYAPP is an application contained in APP_ROOT. 6. EMP is a common table created in APP_ROOT and all its application PDBs, created when version 1.0 of COMPANYAPP was installed. You execute these commands: $ sqlplus sys/ orac1e@localhost:1521/cdb1 as sysdba SQL> ALTER SYSTEM SET DEFAULT_SHARING=DATA; System altered. SQL> ALTER SESSION SET CONTAINER=app_root; Session altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp BEGIN UPGRADE '1.0' TO '2.0'; pluggable database altered. SQL> ALTER TABLE emp ADD (sal NUMBER NOT NULL) ; Table altered. SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp END UPGRADE TO '2.0'; Pluggable database altered. SQL> ALTER SESSION SET CONTAINER=app_pdb1; Session altered. SQL> DESC emp; Name Null? Type --------------------------------------------------------------ENO NUMBER ENAME VARCHAR2 (20) SQL> SELECT * FROM emp; ENO ENAME ---------------------------------100 Alan 200 Ben SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp SYNC; What will be the outcome and why?
1Z1-083 Exam Question 40
Some archived log backups have been accidentally deleted from storage.
Which two commands should be used to update the status of backups in the recovery catalog to display only the missing backups?
Which two commands should be used to update the status of backups in the recovery catalog to display only the missing backups?
