Which of these are valid Flashback Database recovery point p

题目
多选题
Which of these are valid Flashback Database recovery point parameters?()
A

SCN

B

Timestamp

C

Named recovery point

D

Transaction ID

E

Session ID

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()

  • A、 Flashback logs are not archived.
  • B、 Flashback logs are maintained in redo log files.
  • C、 Flashback logs are maintained in the Flash Recovery Area.
  • D、 Flashback logs are used to maintain Flashback Database related errors.
  • E、 Flashback logs need to be cleared manually after you disable Flashback Database.

正确答案:A,C

第2题:

You decide to enable Flashback Database in your Oracle 10g database so that future recoveries will take less time than traditional recoveries. Which of the following parameters must be included in your initialization parameter file before enabling Flashback Database?()

  • A、 DB_RECOVERY_FILE_DEST only
  • B、 DB_FLASHBACK_RETENTION_TARGET only
  • C、 DB_RECOVERY_FILE_DEST_SIZE and DB_RECOVERY_FILE_DEST only
  • D、 DB_RECOVERY_FILE_DEST and DB_FLASHBACK_RETENTION_TARGET only
  • E、 DB_RECOVERY_FILE_DEST_SIZE, DB_RECOVERY_FILE_DEST and
  • F、 DB_FLASHBACK_RETENTION_TARGET

正确答案:C

第3题:

Which three actions are required to configure the Flashback Database? ()

A. set Flash Recovery Area

B. enable Flashback logging

C. create FLASHBACK tablespace

D. start the database in the ARCHIVELOG mode

E. start the database in the NOARCHIVELOG mode


参考答案:A, B, D

第4题:

You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information?()

  • A、 Query the V$FLASHBACK_DATABASE_LOG view.
  • B、 Query the V$FLASHBACK_DATABASE_STAT view.
  • C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
  • D、 Query the V$RECOVERY_FILE_DEST view.

正确答案:B

第5题:

Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode?() 

  • A、 Database datafiles
  • B、 Control files
  • C、 Archived redo logs
  • D、 Online redo logs
  • E、 Flashback logs

正确答案:A,B,D

第6题:

Flashback Database relies on which technologies to recover to a point in time?()  

  • A、 Flashback Data Archive
  • B、 Flashback logs in the flash recovery area
  • C、 FlashbUndo tablespace
  • D、 RMAN command line
  • E、 None of the above

正确答案:B

第7题:

You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations.  Which view would you query to estimate the flashback space required?()

  • A、 V$DATABASE
  • B、 V$FLASHBACK_DATABASE_STAT
  • C、 V$FLASHBACK_DATABASE_LOG
  • D、 V$RECOVERY_FILE_DEST

正确答案:B

第8题:

Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?()

A. point-in-time recovery

B. execute the ROLLBACK command with transaction number

C. flashback the database to before the transaction was committed

D. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery


参考答案:D

第9题:

Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?()

  • A、point-in-time recovery
  • B、execute the ROLLBACK command with transaction number
  • C、flashback the database to before the transaction was committed
  • D、determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

正确答案:D

第10题:

You are maintaining your database in Oracle10g. On Tuesday at 8:00 A.M., while starting the database, you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6:00 P.M. Which type of recovery will you perform?()

  • A、 incomplete recovery
  • B、 complete recovery
  • C、 recovery using the Flashback Database feature
  • D、 recovery using the export/import utility

正确答案:A

更多相关问题