单选题The（）writes the Flashback Database logs in the flash recovery area.AFLSHBFLDBCRVWRDRVRWEFBDA

题目
单选题
The（）writes the Flashback Database logs in the flash recovery area.
A

 FLSH

B

 FLDB

C

 RVWR

D

 RVRW

E

 FBDA

相似考题

1.On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? （）A. Check the alert log fileB. Query the V$FLASHBACK_DATABASE_LOG viewC. Query the V$RECOVERY_FILE_DEST_SIZE viewD.Query the V$FLASHBACK_DATABASE_STAT viewE. Check the value assigned for the UNDO_RETENTION parameter

2.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.

3.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.

4.Which three actions are required to configure the Flashback Database? ()A. set Flash Recovery AreaB. enable Flashback loggingC. create FLASHBACK tablespaceD. start the database in the ARCHIVELOG modeE. start the database in the NOARCHIVELOG mode

更多“The（）writes the Flashback Database logs in the flash recover”相关问题

  • 第1题：

    Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）

    • A、 DBWn
    • B、 RECO
    • C、 RVWR
    • D、 LGWR

    正确答案:C

  • 第2题：

    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

  • 第3题：

    You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors， such as erroneously dropping users， tables， and important data， to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database， you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors， you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running？（）

    • A、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
    • B、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.
    • C、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
    • D、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.

    正确答案:A

  • 第4题：

    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

  • 第5题：

    What is the purpose of the recover command？（） 

    • A、 Recover database datafiles from physical disk backup sets.
    • B、 Recover required incremental backups from physical disk backup sets.
    • C、 Recover required archived redo logs from physical disk backup sets.
    • D、 Apply incremental backups to recover the database. 
    • E、 Apply archived redo logs to recover the database.

    正确答案:B,C,D,E

  • 第6题：

    Which three statements are true about Flashback Database?（）

    • A、Flashback logs are written sequentially, and are archived.
    • B、Flashback Database uses a restored control file to recover a database.
    • C、The Oracle database automatically creates, deletes, and resides flashback logs in the Fast RecoveryArea.
    • D、Flashback Database can recover a database to the state that it was in before a reset logs operation.
    • E、Flashback Database can recover a data file that was dropped during the span of time of the flashback.
    • F、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.

    正确答案:B,C,F

  • 第7题：

    Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）

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

    正确答案:C

  • 第8题：

    多选题
    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


    正确答案： D,B
    解析： 暂无解析

  • 第9题：

    单选题
    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
    解析： 暂无解析

  • 第10题：

    单选题
    Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）
    A

     DBWn

    B

     RECO

    C

     RVWR

    D

     LGWR


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    You dropped a schema of a user in an Oracle 10g by mistake. You decide to flash the database back to its previous state to restore the deleted schema.   Which process writes the before images of the physical database blocks to the flashback database logs？（）
    A

     LGWR

    B

     DBWR

    C

     MMON

    D

     RVWR


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    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）.


    正确答案： D
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    You dropped a schema of a user in an Oracle 10g by mistake. You decide to flash the database back to its previous state to restore the deleted schema.   Which process writes the before images of the physical database blocks to the flashback database logs？（）

    • A、 LGWR
    • B、 DBWR
    • C、 MMON
    • D、 RVWR

    正确答案:D

  • 第15题：

    On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? （）

    • A、Check the alert log file
    • B、Query the V$FLASHBACK_DATABASE_LOG view
    • C、Query the V$RECOVERY_FILE_DEST_SIZE view
    • D、Query the V$FLASHBACK_DATABASE_STAT view
    • E、Check the value assigned for the UNDO_RETENTION parameter

    正确答案:B

  • 第16题：

    The（）writes the Flashback Database logs in the flash recovery area.

    • A、 FLSH
    • B、 FLDB
    • C、 RVWR
    • D、 RVRW
    • E、 FBDA

    正确答案:C

  • 第17题：

    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

  • 第18题：

    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

  • 第19题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第20题：

    多选题
    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
    解析： 暂无解析

  • 第21题：

    单选题
    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）


    正确答案： C
    解析： 暂无解析

  • 第22题：

    单选题
    The（）writes the Flashback Database logs in the flash recovery area.
    A

     FLSH

    B

     FLDB

    C

     RVWR

    D

     RVRW

    E

     FBDA


    正确答案： D
    解析： 暂无解析

  • 第23题：

    多选题
    Which three statements are true about Flashback Database?（）
    A

    Flashback logs are written sequentially, and are archived.

    B

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

    C

    The Oracle database automatically creates, deletes, and resides flashback logs in the Fast RecoveryArea.

    D

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

    E

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

    F

    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.


    正确答案： F,E
    解析： 暂无解析

  • 第24题：

    单选题
    On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30am. Which option must you use to check whether a flashback operation can recover the database to the specified time?（）
    A

    Check the alert log file

    B

    Query the V$FLASHBACK_DATABASE_LOG view

    C

    Query the V$RECOVERY_FILE_DEST_SIZE view

    D

    Query the V$FLASHBACK_DATABASE_STAT view

    E

    Check the value assigned for the UNDO_RETENTION parameter


    正确答案： B
    解析： 暂无解析

相关内容