Which three are true about requirements for various FLASHBACK operations? (Choose three.)

• A.FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.
• B.FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.
• C.FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.
• D.FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.
• E.FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
• F.FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)

• A.Flashback logs are automatically purged whenever the value of DB_FLASHBACK_RETENTION_TARGET is changed.
• B.Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET only after there is space pressure.
• C.Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is space pressure.
• D.Flashback logs are automatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained.
• E.Flashback logs are monitored for being older than the retention period defined in DB_FLASHBACK_RETENTION_TARGET and can be deleted by an administrator written event trigger.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment?

• A.defining primary keys for all tables to speed up all queries
• B.the configuration of storage arrays
• C.the physical data model
• D.defining foreign keys for all tables to speed up joins
• E.using check constraints to speed up updates

Comment: *

Name: *

Email: *

Verification: *

Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges. You execute the command: SQL>CREATE AUDIT POLICY table_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin,oe_admin; Which statement is true?

• A.It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN or OE_ADMIN role.
• B.It fails because the command does notspecify when the unified audit policy should be enforced.
• C.It fails because system privileges cannot be granted with roles in the same audit policy.
• D.It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them.

Comment: *

Name: *

Email: *

Verification: *