Which three are true about Database Point-in-Time Recovery? (Choose three.)

• A.The target point for the recovery must be specified as a stime or System Change Number (SCN).
• B.Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
• C.The Database must be in ARCHIVE LOG mode.
• D.The database must be open RESETLOGS after Database Point-in-Time Recovery.
• E.The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.
• F.The database must be in MOUNT state when performing Database Point-in-Time Recovery.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about performing an Oracle Database install on Linux? (Choose three.)

• A.It can be done after installing Grid Infrastructure for a Standalone Server.
• 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.The Oracle database administrator must be granted access to the root operating system account to tun root privileged scripts.
• E.The runfixup.sh script can install missing RPMs.
• F.The Oracle Preinstallation RPM can be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group
• G.It allows you to select the languages supported by the Oracle database server.

Comment: *

Name: *

Email: *

Verification: *

A user complains about poor database performance.
You want to verify if the user's session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once?

• A.V$SESSION_EVENT
• B.V$SESSTAT
• C.V$SESSION_WAIT
• D.V$SESSION_WAIT_CLASS
• E.V$SESSION

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about Oracle pluggable databases (PDBs)?

• A.An unplugged PDB can be plugged into multiple CDBs simultaneously by sharing data files.
• B.A PDB created from PDB$SEED must be set to READ WRITE after loading data.
• C.A PDB unplugged from a container database (CDB) can be plugged into a different CDB without altering any of its schemas.
• D.A PDB created from PDB$SEED must be set to READ ONLY after loading data.
• E.A PDB in a remote CDB can be accessed transparently thereby aggregating results from local and remote PDBs.
• F.A non-CDB can be converted into a PDB.
• G.A PDB can be plugged into a CDB only if both are of the same Oracle Database release.

Comment: *

Name: *

Email: *

Verification: *

Choose three. The HR_ROOT application container must support the execution of a query on a table shared by application local PDBs PDB1 and PDB2, and remote PDB PDB3. Which three are true?

• A.The HR_ROOT replica must exist in the remote CDB.
• B.A proxy PDB must exist in the application root in the remote CDB.
• C.PDB3's application root replica must exist in the local CDB.
• D.A database link must exist in the remote CDB referring to the local CDB.
• E.A proxy PDB must exist in the application root in the local CDB.
• F.A database link must exist in the local CDB root referring to the remoteCDB.

Comment: *

Name: *

Email: *

Verification: *