You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command. Which two statements are true about the dependent objects of the CUSTOMERS table?

• A.Only the primary key constraint created for the table is flashed back, whereas all other indexes must be retrieved separately.
• B.Materialized views that use the CUSTOMERS table are flashed back.
• C.All the triggers associated with the table are flashed back but are disabled.
• D.All the constraints defined on the table, except the referential integrity constraints, are flashed back.
• E.LOB segments associated with the CUSTOMERS table are flashed back.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about the keystore storage framework for transparent data encryption?

• A.It enables a keystore to be stored only in a file on a file system.
• B.It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.
• C.It transparently decrypts data for the database users and applications that access this data.
• D.It handles encrypted data without modifying applications.
• E.It facilitates and helps to enforce keystore backup requirements.
• F.It enables separation of duties between the database administrator and the security administrator.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three actions are mandatory post database upgrade?

• A.Updating client scripts with the new Oracle home.
• B.Migration to unified auditing.
• C.Resetting passwords to enforce case-sensitivity.
• D.Upgrading user tables that depend on Oracle-maintained abstract data types.
• E.Run OPatch commands from the new Oracle home.
• F.Setting threshold values for tablespace alerts.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about recovery operations done without using Recovery Manager (RMAN)?

• A.A lost index tablespace can be re-created without performing any recovery.
• B.A lost password file can be manually re-created with the orapwd utility.
• C.A lost SPFILE can be recovered from memory using SQL*PLUS.
• D.A lost password file can be re-created with SQL*PLUS.
• E.A lost PFILE can be re-created from alert.log using SQL*PLUS.
• F.A lost TEMPFILE must always be re-created manually.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)?

• A.Backing up a database in noarchivelog mode using O/S utilities requires that the database instance be started and the database be in mount state.
• B.Backing up a database in archivelog mode using O/S utilities requires that the database instance be started and the database be in open state.
• C.Backing up a database in archivelog mode using O/S utilities requires that the database instance be started and the database be in mount state.
• D.Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as image copies.
• E.An Oracle database can be restored from backup files copied using O/S utilities.
• F.Backing up a database in noarchivelog mode using O/S utilities requires that the database instance be shut down.
• G.Oracle archive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.

Comment: *

Name: *

Email: *

Verification: *