QUESTION 68
Choose two. Which two are true about backup set compression using RMAN default compression?

QUESTION 69
Your sales_root application container has two application PDBs.
The sales_app application has a common table, FIN.REVENUE, in the two PDBs.
Examine this query and its output:

Which two are true?

QUESTION 70
Which three capabilities require the use of the RMAN recovery catalog? (Choose three.)

QUESTION 71
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?

QUESTION 72
Identify three benefits of Unified Auditing.

QUESTION 73
Choose two. Which two are true about RMAN duplexed backup sets?

QUESTION 74
A database is configured in ARCHIVELOG mode.
A full RMAN backup exists but no control file backup to trace has been taken.
A media failure has occurred.
In which two scenarios is incomplete recovery required? (Choose two.)

QUESTION 75
You take your database backups by using the RMAN media management interface (MMI).
Which two are true about the use of the RMAN MMI?

QUESTION 76
Which two are true about the SQL Tuning Advisor?

QUESTION 77
Choose two. Which two are true about Oracle Database Configuration Assistant (DBCA)?

QUESTION 78
Examine the command for creating pluggable database PDB2 in container database CDB2.

Select three options, any one of which is required for it to execute successfully. (Choose three.)

QUESTION 79
Which three actions are mandatory post database upgrade?

QUESTION 80
Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)

QUESTION 81
Choose three. Which three activities are possible for PDBs?

QUESTION 82
Examine this configuration:
CDB1 is a container database.
COMMON_USER_PREFIX is C##.
PDB1 is a pluggable database contained in CDB1.
APP1_ROOT is an application container contained in CDB1.
APP1_PDB1 is an application PDB contained in APP1_ROOT.
You execute these commands successfully:

Which two are true? (Choose two.)

QUESTION 83
Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)

QUESTION 84
Which three are true about Audit policies In container databases (CDBs)?

QUESTION 85
Which three are true about requirements for various flashback operations?