A.It can be run only automatically.

B.It runs automatically every night by default.

C.It can recommend changes to improve the statistics gathering process.

D.It can be run only manually.

E.It always analyzes all schemas in the database.

A.oracle must be the owner of every Oracle Database installation.

B.oracle will be an owner of the Oracle Inventory.

C.The user account, oracle, and group, oinstall, can be used for all Oracle software installations.

D.oracle will be granted the sysasm privilege when installing the Oracle Database software.

E.oracle can own an Oracle Database installation but not an Oracle Grid Infrastructure installation.

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

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 datanase is opened.

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

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 ACTIV

F.Recovery begins from the beginning of the CURRENT redo log group.

A.Patches are applied via opatchauto.

B.It applies patches in nonrolling mode by default.

C.It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.

D.Users must always input patch plans to opatchauto.

E.It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.

F.It must be invoked by a user with root user privileges.

G.It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.

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

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

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

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

E.It only recommends syntactic changes to SQL statements.

F.It can recommend semantic changes to SQL statements.