违法和不良信息举报 联系客服
免费注册 登录

You want to configure the Flashback Database feature and ret

题目
单选题
You want to configure the Flashback Database feature and retain flashback logs for three days.  Presently the database is open and configured in ARCHIVELOG mode. The following steps must be performed in the correct sequence to do this：   1. Set the retention target：  SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320；  2. Enable Flashback Database：  SQL> ALTER DATABASE FLASHBACK ON；  3. Mount the database：  SQL> STARTUP MOUNT EXCLUSIVE  4. Shutdown the instance： SQL> SHUTDOWN IMMEDIATE  5. Open the database：  SQL> ALTER DATABASE OPEN；   Choose the correct sequence.（）
A

 4， 1， 3， 2， 5

B

 4， 3， 1， 2， 5

C

 2， 4， 3， 5， 1

D

 4， 2， 5， 3， 1

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

第1题：

You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）

  • A、 You must use automatic undo management in the database.
  • B、 You must configure OMF in your database.
  • C、 You must configure ASM for storing the datafiles.
  • D、 You must multiplex the online redo log file.

正确答案:A

第2题：

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

第3题：

You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE － 5／24);Which two statements are true about this flashback scenario?()

A. The database must have multiplexed redo logs for the flashback to succeed.

B. The database must be MOUNTED for the flashback to succeed.

C. The database must use block change tracking for the flashback to succeed.

D. The database must be opened in restricted mode for the flashback to succeed.

E. The database must be opened with the RESETLOGS option after the flashback is complete.

F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.


参考答案：E, F

第4题：

In which scenario will you use the Flashback Version Query feature？（）

  • A、 when you want to restore a table that has been dropped from the Recycle Bin
  • B、 when you want to identify the transaction ID of the transaction that deleted some important records from a table
  • C、 when you want to recover the schema of a dropped user
  • D、when you want to restore a dropped tablespace

正确答案:B

第5题：

You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task（）

  • A、Multiplex all database files.
  • B、Configure the Flash Recovery Area.
  • C、Configure the database instance for ARCHIVELOG mode.
  • D、Configure the FAST_START_MTTR_TARGET initialization parameter

正确答案:C

第6题：

Your Oracle Database 10g is online when you execute the following statement：        SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF；   What is the result of executing this statement if the Flashback Database feature is already enabled in the database？（）

  • A、 The database does not record flashback logs for MY_TABLESPACE
  • B、 The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.
  • C、 All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.
  • D、 None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE

正确答案:A

第7题：

In which case would you use the Flashback Database feature to perform a recovery？（）

  • A、to recover a dropped tablespace
  • B、to recover data from a truncated table
  • C、to recover a data file that has been shrunk
  • D、to recover a database to the state that existed before the RESETLOGS operation

正确答案:B

第8题：

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

第9题：

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 Managed Files （OMF）.
  • E、Flashback logs are deleted only if you are using Automatic Storage Management （ASM）.

正确答案:B

第10题：

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

更多相关问题
相关内容