A. use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the table
B. restore the entire database from the most recent backup and open it
C. recover the table by using the Flashback Table feature
D. perform point-in-time recovery to recover the table

A. 2， 7， 3， 5， 1， 6， 4
B. 2， 1， 7， 6， 3， 5， 4
C. 7， 1， 3， 2， 6， 5， 4
D. 7， 2， 3， 1， 4， 6， 5

A. The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.
B. Before the instance starts， you receive an error about the missing redo log files of a group.
C. The instance starts and the database opens with an error message written to the alert log file.
D. The instance starts and the database opens because two redo log groups still exist.
E. The instance starts and the database opens， but every attempt to write to redo log files fails with an error.

A. until Thursday morning
B. until that point in time when the database is opened
C. until that point in time when the recovery is performed
D. until last Sunday’s backup
E. until that point in time when the table is dropped and purged
F. until Wednesday evening

A. streams pool
B. shared pool
C. log buffer
D. keep buffer cache
E. recycle buffer cache

A. You need to mention it with every BACKUP command.
B. The block change tracking feature is used automatically by RMAN.
C. You need to configure it using the CONFIGURE command.
D. You need to set the necessary initialization parameters to direct RMAN to use the feature.

A. The member jobs would get dropped when the job class is dropped.
B. Both the jobs would be executed concurrently.
C. The member jobs would get disabled when the job class is dropped.
D. The attributes defined at the class level would be applied to both the jobs.
E. Jobs in the job class must have been assigned the same priority.

A. DB_4K_CACHE_SIZE only
B. DB_8K_CACHE_SIZE only
C. DB_BLOCK_SIZE and DB_4K_CACHE_SIZE
D. DB_BLOCK_SIZE and DB_8K_CACHE_SIZE
E. SGA_TARGET and DB_4K_CACHE_SIZE
F. DB_CACHE_SIZE only

A. You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.
B. You can use this feature to identify the versions of V$ views.
C. You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.
D. You can use this feature for a table only if row movement is enabled for the table.
E. You can use this feature to identify the versions of external and fixed tables.

A. The FLASHBACK TABLE statement will not be written to the alert log file.
B. The EMP table that was dropped by mistake from the database will be restored.
C. The changes made to the EMP table since the specified time will be undone.
D. The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.
E. The FLASHBACK TABLE statement will be executed within a single transaction.
F. The list of transactions that have modified the EMP table since the specified time will be displayed.