A.It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them.

B.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.

C.It fails because system privileges cannot be granted with roles in the same audit policy.

D.It fails because the command does notspecify when the unified audit policy should be enforced.

A.V$SESSION_EVENT

B.V$SESSTAT

C.V$SESSION_WAIT

D.V$SESSION_WAIT_CLASS

E.V$SESSION

A.FLASHBACK LOGS are archived after a log switch.

B.A database can be flashed back using SQL*PLUS.

C.Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database.

D.FLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time.

E.It always generates REDO and UNDO.

F.It requires that the target database be in ARCHIVELOG mode.

A.It requires system statistics when generating SQL execution plans.

B.It always generates an index access operation when a statement filters on an indexed column with an equality operator.

C.It can automatically re-optimize execution plans that were detected to be sub-optimal when executing.

D.It ignores stale object statistics in the Data Dictionary.

E.It can re-write a statement internally in order to generate a more optimal plan.

A.The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.

B.The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

C.RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.

D.The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVELOG mode.

E.RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.

F.The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.

G.The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.

H.RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.