A.after losing all members of the CURRENT online redo log group

B.after losing a SYSAUX tablespace data file

C.after losing all members of an INACTIVE online redo log group

D.after losing all copies of the control file

E.after losing an UNDO tablespace that is in use

A.Schema Only accounts can be granted administrator privileges.

B.If the password file location changes, then the instance must be restarted.

C.All the Oracle-supplied accounts are Schema Only accounts.

D.Unified Auditing can be configured to audit only events that are issued indirectly by all users

E.Unified Auditing can be configured to audit only events that are issued directly by an audited user.

A.LOB segments associated with the CUSTOMERS table are flashed back.

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.Only the primary key constraint created for the table is flashed back, whereas all other indexes must be retrieved separately.

E.All the constraints defined on the table, except the referential integrity constraints, are flashed back.

A.The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED Correct

B.The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

C.The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

D.Setting the target tablespace offline

E.Settingthetargettablespacetoread-only

A.It builds SQL profiles for each poorly performing SQL statement to prevent regressions.

B.It checks each query being analyzed for missing statistics.

C.It considers all SQL statements being analyzed by the advisor task as a group.

D.It can recommend semantic changes to SQL statements.

E.It checks each query being analyzed for stale statistics.

F.It only recommends syntactic changes to SQL statements.