A.Flashback logs are written sequentially, and are archived.

B.Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

C.The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.

D.Flashback Database uses a restored control file to recover a database.

E.Flashback Database can recover a database to the state that it was in before a reset logs operation.

F.Flashback Database can recover a data file that was dropped during the span of time of the flashback.

A.V$SESSION_EVENT

B.V$SESSTAT

C.V$SESSION_WAIT

D.V$SESSION_WAIT_CLASS

E.V$SESSION

A.Unused blocks below the high water mark are backed up.

B.Compressed backups can be written only to media.

C.Binary compression adds CPU overhead to backup operations.

D.Compression can be done only for locally managed tablespaces.

E.Compressed backups cannot have a section size defined.

A.By default, the transported database will use Oracle Managed Files (OMF)

B.Data files can be converted on the destination system.

C.Data files can be converted on the source system.

D.A new DBID is automatically created for the transported database.

E.Databases can be transported between systems with different endian formats.

F.The password file is automatically converted by RMAN.

A.The solution that best optimizes one SQL statement can degrade the performance of others.

B.Poorly performing SQL statements can be tuned automatically by the Oracle server.

C.SQL statements doing only logical reads never require tuning because they do no physical I/O.

D.SQL statements performing many physical I/Os can always have their performance improved by creating indexes.

E.SQL statements doing joins always do more physical I/O than single table queries.