A databaseisstoredin an Automatic Storage Management (ASM) disk group,diskgroup, DGROUP1 with SQL:

Thereis enough free spacein the disk group for mirroring to be done.
What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?

• A.Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
• B.Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
• C.The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.
• D.ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.
• E.Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.

Comment: *

Name: *

Email: *

Verification: *

While investigating a possible security breach, you realized that some audit records were not retrieved when the UNIFIED_AUDIT_TRAILview was queried.
How can you ensure that all available audit records are returned when the audit trail is queried?

• A.Query the v$UNIFIED_AUDIT_TRAILview rather than the UNIFIED_AUDIT_TRAILview.
• B.Enable the OS auditing option in the database before querying the UNIFIED_AUDIT_TRAILview.
• C.Configure the IMMEDIATEwrite mode using the DBMS_AUDIT_MGMT.SET_AUDIT_TRAILview.
• D.Execute the DBMS_AUDIT_MGMT.FLUSH_INIFIED_AUDIT_TRAILprocedure before querying the UNIFIED_AUDIT_TRAILview.

Comment: *

Name: *

Email: *

Verification: *

A redaction policy was added to the SALcolumn of the SCOTT.EMPtable:

All users have their default set of system privileges.
For which three situations will data not be redacted? (Choose three.)

• A.SYSsessions, regardless of the roles that are set in the session
• B.SYSTEMsessions, regardless of the roles that are set in the session
• C.SCOTTsessions, only if the MGRrole is set in the session
• D.SCOTTsessions, only if the MGRrole is granted to SCOTT
• E.SCOTTsessions, because he is the owner of the table
• F.SYSTEMsession, only if the MGRrole is set in the session

Comment: *

Name: *

Email: *

Verification: *

What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database? (Choose two.)

• A.Effectively implements role separation
• B.Enables you to take advantage of Oracle Managed Files.
• C.Automatically registers the database with Oracle Restart.
• D.Helps you to easily upgrade the database from a prior release.
• E.Enables the Installation of Grid Infrastructure files on block or raw devices.

Comment: *

Name: *

Email: *

Verification: *

In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer.
Which statement is true?

• A.The CDB must be open.
• B.The CDB must be in the mount stage.
• C.The CDB must be in the nomount stage.
• D.Alt existing PDBs must be closed.

Comment: *

Name: *

Email: *

Verification: *