OCP-083

Choose three. Which three are true about corrupted data blocks and their recovery in an Oracle

Database?

Choose three. Which three are true about upgrading an application in an application container?

Choose three. You must migrate a non-CDB Oracle 11g Database to a CDB without first performing an

Upgrade to the non-CDB.

User-defined objects are stored in several tablespaces in the non-CDB.

Which three methods can you use?

Choose the best answer. Examine this configuration:

1>CDB1 is a container database.

2>COMMON_USER_PREFIX is set to an empty string.

3>PDB1 is a pluggable database in CDB1.

4>APP1_ROOT is an application container in CDB1.

5>APP1_PDB1 is an application PDB in APP1_ROOT.

You execute these commands:

$ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba

SQL> CREATE ROLE role1 CONTAINER=CURRENT;

Which is true?

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?

Choose three. Which three are true about post-upgrade activities when upgrading an Oracle database

Using Database Upgrade Assistant?

Choose two. Which two are true about backup encryption?

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 and synchronized 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 sysdba

SQL> ALTER SESSION SET CONTAINER=app1_root;

Session altered.

SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app BEGIN UPGRADE '1.0' TO

'2.0';

Pluggable database altered.

SQL> GRANT CREATE SESSION TO USER1;

Grant succeeded.

SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app END UPGRADE TO '2.0';

Pluggable database altered

SQL> 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. Which two are true about PDB archive files?

Choose the best answer. Examine this configuration:

1>CDB1 is an Oracle container database from an older release.

2>PDB1, PDB2, PDB3, and PDB4 are pluggable databases in CDB1.

A priority list UpgrdList has these entries:

1, pdb2

2, pdb1, pdb3

You execute this command:

$ /u01/app/oracle/product/18.1.0/db_1/rdbms/admin/dbupgrade -L UpgrdList

In which order will the upgrade occur?

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

Choose two. Your database is in ARCHIVELOG mode and you plan to use Flashback Database.

Which two features or parameters manage space availability in the fast recovery area?

Choose two. Which two are true about an RPM-based Oracle Database installation?

Choose two. Which two are true about an Oracle gold image-based installation in Oracle 18c and later

Releases?

Choose three. Which three are true about a container database (CDB)?

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

Choose three. Which three actions are mandatory post database upgrade?

Choose two. 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?

Choose the best answer. Your CDB has two regular PDBs as well as one application container with two

Application PDBs and an application seed.

No changes have been made to the standard PDB$SEED.

How many default temporary tablespaces can be assigned in the CDB?

Choose three. Which three are true about backing up the control file?