A.It can be run only manually.

B.It is part of the DBMS_ADVISOR package.

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

D.It always analyzes all schemas in the database.

E.It runs automatically every night by default.

F.It is part of the DBMS_STATS package.

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

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

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

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

E.Data Recovery Advisor can proactively check for failures.

A.using check constraints to speed up updates

B.the physical data model

C.defining foreign keys for all tables to speed up joins

D.defining primary keys for all tables to speed up all queries

E.the configuration of storage arrays

A.Recovery begins from the last checkpoint position that wascalculated by the Database Writer before instance failure.

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

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

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

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

F.Recovery reads redo until the end of the redo thread. SMON rollsback any dead transactions, and then the datanase is opened.

A.By default, AWR snapshots are taken every 60 minutes.

B.Its collection level is determined by the value of the STATISTICS_LEVELdatabase parameter.

C.By default, AWR snapshots are retained for 7 days.

D.The taking of AWR snapshots can be disabled.

E.AWR data is stored in the SYSTEMtablespace.