【单选题】Note the output of the following query; SQL> SELECT flashback_archieve_name, status FROM dba_flashback_archieve; FLASHBACK_ARCHIEVE_NAME STATUS FLA1 You executed the following command to enable Fl...
A.
The table uses the default Flashback Data Archive.
B.
The Flashback Data Archive Is created In the SYSAUX tablespace.
C.
The Flashback Data Archive is created in the same tablespace where the tables are stored.
D.
The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.
【多选题】These are the details about V$FLASHBACK_DATABASE_STAT: SQL> DESC V$FLASHBACK_DATABASE_STAT Name Null? Type ------------- -------- -------------- BEGIN_TIME DATE END_TIME DATE FLASHBACK_DATA NUMBER...
A.
BEGIN_TIME is the time at which Flashback logging is enabled.
B.
END_TIME is the time at which the query is executed on the view.
C.
REDO_DATA is the number of bytes of redo data written during the interval.
D.
This view contains information about flashback data pertaining to the last 24 hours.
E.
FLASHBACK_DATA is the amount of flashback data generated since the database was opened.
【单选题】A corporation is a busine s s o r ganization that is f o rmed to act as a single person and is l e g a lly ______ with particular rights and duties.
【单选题】You executed the following query in your database: SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()
A.
The time when the last flashback operation in your database was performed.
B.
The time when the first flashback operation in your database was performed.
C.
A list of flashback operations performed in your database using SCN and time.
D.
The approximate time and the lowest system change number (SCN) to which you can flash back your database.
【单选题】You disabled the Flashback Database feature by using the following command: SQL> ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback logs?()
A.
Flashback logs are not deleted.
B.
Flashback logs are deleted automatically.
C.
Flashback logs are deleted only if you are using Recovery Manager (RMAN)
D.
Flashback logs are deleted only if you are using Oracle Manager Files (OFM)
E.
Flashback logs are deleted only if you are using Automatic Storage Management (ASM)