PDB1 and PBD2 are pluggable databases in CDB1.
Examine these commands:

CDB1 is then restarted.
Which three are true? (Choose three.)

• A.PDB$SEED will be MOUNTED.
• B.PDB1 will be opened READ WRITE.
• C.PDB1 will be MOUNTED.
• D.PDB2 will be opened READ WRITE.
• E.PDB$SEED will be opened READ ONLY.
• F.PDB2 will be MOUNTED.

Comment: *

Name: *

Email: *

Verification: *

Which three are true? (Choose three.)

• A.Application-common TSDP policies are always container specific.
• B.Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.
• C.Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.
• D.Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.
• E.Unified auditing can be automatically synchronized to all application PDBs in an application container.
• F.Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.
• G.Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.

Comment: *

Name: *

Email: *

Verification: *

You execute the following piece of code with appropriate privileges: BEGIN DBMS_REDACT.ADD_POLICY ( END; object_schema object_name column_name policy_name function_type expression => 'SCOTT', => 'EMP', => 'SAL', => 'SCOTT_EMP', => DBMS_REDACT.FULL, => 'SYS_CONTEXT (''SYS_SESSION_ROLES'',''MGR'') = ''FALSE'''); END; BEGIN DBMS_REDACT.ADD_POLICY ( object_schema object_name column_name policy_name function_type expression => 'SCOTT', => 'EMP_VW', => 'SAL', => 'SCOTT_EMP_VW', => DBMS_REDACT.NONE, => 'SYS_CONTEXT (''SYS_SESSION_ROLES'',''MGR'') = ''FALSE'''); User SCOTT has been granted the CREATE SESSION privilege and the MGR role. Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?

• A.DataisredactedfortheEMP.SALcolumnonlyiftheSCOTTsessiondoesnothavetheMGR role set.
• B.DataisredactedforEMP.SALcolumnonlyiftheSCOTTsessionhastheMGRroleset.
• C.Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set. Correct
• D.Data is never redacted for the EMP_VW.SAL column.
• E.Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.

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: *

Which two are true about the Oracle database methodology? (Choose two.)

• A.SQL statements should always be tuned before tuning any file systems.
• B.The alert log should be used to find the database and instance areas most in need of tuning.
• C.Tuning activities should stop once agreed service levels for performance have been met.
• D.The database instance memory should always be tuned before tuning any file systems.
• E.Tuning activities should stop once the user is satisfied with performance.
• F.The Oracle Database time model should be used to find the database and instance areas most in need of tuning.

Comment: *

Name: *

Email: *

Verification: *