You are managing this configuration:
* CDB1 is a container database.
* PDB1 and PDB2 are two pluggable databases in CDB1.
* USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2.
CDB1 user SYS executes these commands after connecting successfully to PDB2:

Which two are true? (Choose two.)

• A.The insert on USER2.DEPT is uncommitted.
• B.The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.
• C.The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.
• D.The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.
• E.The inserts on USER1.EMP were rolled back when the session connected to PDB2.
• F.The inserts on USER1.EMP were committed when the session connected to PDB2.
• G.The insert on USER2.DEPT fails because of the active transaction in the parent container.

Comment: *

Name: *

Email: *

Verification: *

Choose two. Which two are true about Lockdown profiles in a container database (CDB) and its pluggable databases (PDBs)?

• A.A Lockdown profile created from a base Lockdown profile is always automatically modified if the profile on which it is based is modified.
• B.A Lockdown profile created from a base Lockdown profile is never automatically modified if the profile on which it is based is modified.
• C.A PDB Lockdown profile can be created in CDB$ROOT .
• D.A PDB Lockdown profile can be created in an application root.
• E.A PDB Lockdown profile can be created in a regular PDB.

Comment: *

Name: *

Email: *

Verification: *

A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The LOCAL_UNDO_ENABLEDdatabase property is set to FALSEin the CDB.
Data file 24 of PDB2was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the BACKUP DATABASEcommand while connected to CDB$ROOT.
Which three are true? (Choose three.)

• A.Data file 24 can be restored and recovered while connected to CDB$ROOT.
• B.Data file 24 can be restored only while connected to CDB$ROOT.
• C.Data file 24 can be recovered only while connected to PDB2.
• D.Data file 24 can be recovered while connected to PDB2.
• E.Data file 24 can be restored only while connected to PDB2.
• F.Data file 24 can be recovered while connected to CDB$ROOT.

Comment: *

Name: *

Email: *

Verification: *

Examine this output:

Which two are true? (Choose two.)

• A.PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.
• B.Any PDB not specified in the plan will be unable to execute statements in parallel.
• C.PDB3 can use all available parallel execution processes at times.
• D.PDB1 is always limited to 40% of the available system resources regardless of demand.
• E.Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.
• F.PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *