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.)

A. after losing a SYSAUX tablespace data file

B. after losing all members of an INACTIVE online redo log group

C. after losing all members of the CURRENT online redo log group

D. after losing all copies of the control file

E. after losing an UNDO tablespace that is in use

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

A. By default, AWR snapshots are taken every 60 minutes.

B. Its collection level is determined by the value of the STATISTICS_LEVEL database parameter.

C. By default, AWR snapshots are retained for 7 days.

D. The taking of AWR snapshots can be disabled.

E. AWR data is stored in the SYSTEM tablespace.

You want to create a test database as a replica of your production database with minimum intervention from a DBA. Which method would you use?

A. Use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location.

B. Use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure.

C. Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump.

D. Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump.

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?

A. SAL will be added to APP_PDB1.EMP, with 0 in columns of existing rows.

B. SAL will be added to APP_PDB1.EMP, with NULLs in columns of existing rows.

C. It will return an error because the SYNC operation is not allowed when constraints are added to common objects.

D. It will return an error because EMP is not empty in APP_ROOT.

E. It will return an error because EMP.SAL is empty in APP_ROOT.

Which two are true about backup set compression using RMAN default compression? (Choose two.)

A. Compressed backups can be written only to media.

B. Binary compression adds CPU overhead to backup operations.

C. Unused blocks below the high water mark are backed up.

D. Compressed backups cannot have a section size defined.

E. Compression can be done only for locally managed tablespaces.