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?

• A.It creates a full export of the root
• 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.
• D.It fails because Data Pump cannot be container.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about performing an Oracle Database install on Linux?

• A.The runfixup.sh script can install missing RPMs.
• B.It can be done before installing Grid Infrastructure for a Standalone Server.
• C.The Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.
• D.It allows you to select the languages supported by the Oracle database server.
• E.The Oracle database administrator must be granted access to the root operating system account to run root privileged scripts.
• F.It can be done after installing Grid Infrastructure for a Standalone Server.
• G.The Oracle PreinstallationRPMcan be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:

While CDB1 is open, '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl' is accidentally deleted.
To recover from this critical failure, you execute these commands:

What will be the outcome?

• A.It will re-create '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'
• B.It will create '/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl'.
• C.It will fail because there is no autobackup of the controlfiles.
• D.It will create '$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl'
• E.It will create '/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl'.

Comment: *

Name: *

Email: *

Verification: *

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

• A.APP1_USER1 can be created in CDB1.
• B.APP1_USER1 can be created in PDB1.
• C.APP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT.
• D.C##_USER1 will have the same privileges and roles granted in all PDBs in CDB1.
• E.C##_APP_USER1 can be created in CDB1.
• F.P1_USER1 can be created in CDB1.

Comment: *

Name: *

Email: *

Verification: *

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

• A.Enable only OMF.
• B.Add only the CREATE_FILE_DEST clause to the statement.
• C.Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.
• D.Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
• E.Add the FILE_NAME_CONVERT clause to the statement and enable Oracle Managed Files (OMF)
• F.Set only the PDB_FILE_NAME_CONVERT parameter.

Comment: *

Name: *

Email: *

Verification: *