Question 1

Choose two. Which two are true about memory advisors?

Options :

A : If Automatic Memory Management is enabled, no memory advisors are available.

B : If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components.

C : All memory advisors use data from Automatic Workload Repository

D : If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.

E : If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.

Answer: C,D

Question 2

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

Options :

A : Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.

B : Add only the CREATE_FILE_DEST clause to the statement.

C : Set only the PDB_FILE_NAME_CONVERT parameter.

D : Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.

E : Enable only OMF.

F : Add the FILE_NAME_CONVERT clause to the statement and enable Oracle Managed Files (OMF)

Answer: A,B,C

Question 3

Choose the best answer. Examine this output of an export from the current release of an Oracle multitenant database: $ sqlplus system/oracle . SQL> col name for a10 SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE ---------------------------------------PDB$SEED READ ONLY PDB1 READ WRITE PDB2 MOUNTED SQL> exit Next you execute: $ expdp system/oracle full=y What is the outcome?

Options :

A : It fails because Data Pump cannot be container.

B : It creates a full export of the root

C : It creates a full export of only the used while connected to the root container and PDB1. container and all PDBs. container and all open PDBs. root container.

Answer: A

Question 4

Choose three. Which three are true about RMAN archival backups with the RESTORE POINT clause?

Options :

A : They are never considered obsolete by RMAN.

B : They can optionally be written to a fast recovery area (FRA).

C : Â All archive logs are retained after an archival backup is taken, until the next archival backup is taken of the same database.

D : Archive logs are retained if they are necessary to allow the database to be recovered to a consistent state when an archival backup is restored.

E : The SPFILE is included in the archival backup.

F : Use of a recovery catalog is always required to support the creation and use of archival backups. G)The ARCHIVAL attribute for a backup overrides the RMAN retention policy.

G :

Answer: A,B,D

Question 5

T schema owned by the RC12C user. The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open. You execute the RMAN commands: RMAN> CONNECT CATALOG rcl2c/passl2c@catdbl2c RMAN> IMPORT CATALOG rcll/pwdcatll@ractll Which two tasks are performed as part of the import?

Options :

A : Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.

B : Recovery catalog is resynchronized with the control files of the registered databases.

C : Imported databases are unregistered from the RC11 catalog.

D : Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.

E : All databases registered in the RC11 catalog are registered in the RC12C catalog.

Answer: A,D