A.It is integrated with the SQL Access Advisor.

B.It offers fine-grained analysis of all the SQL statements in the analysis task as a group.

C.SQL statements that were originally run concurrently are run concurrently by SPA.

D.It predicts the impact of system changes on SQL workload response time.

E.It provides before and after execution statistics for each SQL statement in the analysis task

A.Recovery begins from the beginning of the current redo log group.

B.Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (ckpt).

C.Recovery reads redo until the end of the redo thread, smon rolls back any dead transactions, and then the database is opened.

D.Recovery reads redo until the end of the redo thread, and then opens the database, smon then rolls back any dead transactions.

E.Recovery begins from the start of any active redo log group or the start of the current log group if no other group is active.

F.Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.

A.The database must be in archivelog mode.

B.The database must be open resetlogs after Database Point-in-Time Recovery.

C.The target point for the recovery must be specified as a time or System Change Number (SCN).

D.The database must be in mount state when performing Database Point-in-Time Recovery.

E.The database must have flashback database on to perform Database Point-in-Time Recovery.

F.Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)

A.It can encrypt data at the column level.

B.It uses a single master key for a database.

C.It encrypts only data on the client.

D.It replaces secure application roles.

E.It stores the current and all past master keys in the keystore.

F.Master encryption keys are managed by Oracle Database Vault.

A.A failure can be closed only when it has been repaired.

B.Using the Data Recovery Advisor list failure command always requires that the database for which failures are to be listed is in mount state.

C.Data Recovery Advisor can be used if a database is closed.

D.The Data Recovery Advisor change failure command can be used only to change failure priorities.

E.Data Recovery Advisor can proactively check for failures.