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_WAIT
• B.V$SESSION_WAIT_CLASS
• C.V$SESSION_EVENT
• D.V$SESSION
• E.V$SESSTAT

Comment: *

Name: *

Email: *

Verification: *

Which three are true about the tools for diagnosing Oracle Database failure situations? (Choose three.)

• A.Flashback commands help with repairing physical errors.
• B.The ADR command-line utility (ADRCI) can package incident information to send to Oracle Support.
• C.The ADR can store metadata in an Oracle Database repository.
• D.The Automatic Diagnostic Repository (ADR) has a separate home directory for each instance of each Oracle product that is installed and uses it.
• E.RMAN can always repair corrupt blocks.
• F.The Data Recovery Advisor uses the ADR.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about an application seed pluggable database (PDB)? (Choose three.)

• A.It cannot be dropped from its application container.
• B.It is automatically synchronized with its application root PDB when an application is installed.
• C.A new application PDB created by cloning an application seed PDB can have an up-to-date version of the application installed after cloning completes.
• D.It is automatically synchronized with its application root PDB when an application is upgraded.
• E.It cannot be added to an application container after the application container has already been created.
• F.It is not required in an application container.
• G.A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.

Comment: *

Name: *

Email: *

Verification: *

choose three Which three are true about Transparent Data Encryption (TDE)?

• A.Master encryption keys are managed by Oracle Database Vault.
• B.It can encrypt data at the column level.
• C.It uses a single master key for a database.
• D.It replaces secure application roles.
• E.It encrypts only data on the client.
• F.It stores the current and all past master keys in the keystore.

Comment: *

Name: *

Email: *

Verification: *

Examine these queries and their output: An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to recover PDB1 to Restore Point R1. How do you achieve this?

• A.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using RMAN while connected to CDB$ROOT.
• B.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using RMAN while connected to PDB1.
• C.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using SQL while connected to CDB$ROOT.
• D.This cannot be done due to the lack of a clean restore point.
• E.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using SQL while connected to PDB1.

Comment: *

Name: *

Email: *

Verification: *