A.flashback table can undrop a column.

B.flashback query can retrieve redo records from online and archived redo log files.

C.After a database is restored from flashback logs using the flashback database command, it is sometimes rolled forward using redo logs.

D.flashback drop can undrop an index when undropping a table.

E.flashback version query can retrieve redo records from online and archived redo log files.

A.creating a database service using Oracle Database Configuration Assistant (DBCA)

B.creating an Oracle Database service by modifying the SERVICE_NAMES parameter

C.creating an Oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant (ASMCA)

D.creating a disk group using the CREATE DISKGROUP SQL statement

E.creating a database using the CREATE DATABASE SQL statement

F.creating a database service using DBMS_SERVICE.CREATE_SERVICE

A.They can be retained forever.

B.They are generated if STATISTICS_LEVEL is set to TYPICAL.

C.They are always created automatically.

D.They are generated if STATISTICS_LEVEL is set to BASIC.

E.They are generated if STATISTICS_LEVEL is set to ALL.

F.They are always created manually.

A.Setting fast_start_mttr_target to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.

B.It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.

C.It is not possible if an archived log is missing.

D.Setting fast_start_mttr_target to a higher value reduces instance recovery time by causing the log writer to write more frequently, thereby reducing the number of I/Os needed during instance recovery.

E.It is performed by the Recovery Writer (rvwr) background process.

F.It is performed automatically while the database remains in mount state. Then the database is opened.

A.They are generated if STATISTICS LEVEL is set to TYPICAL.

B.They are always created automatically.

C.They are always created manually.

D.They are generated if STATISTICS LEVEL is set to ALL.

E.They are generated if STATISTICS LEVEL is set to BASIC.

F.They can be retained forever.