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

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

3.You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？ （）A、 Open the database in read-only mode.B、 Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.C、 Enable the block change tracking feature.D、 Execute the ALTER DATABASE FLASHBACK ON statement.

4.The()writestheFlashbackDatabaselogsintheflashrecoveryarea.A.FLSHB.FLDBC.RVWRD.RVRWE.FBDA

更多“单选题The（）writes the Flashback Database logs in the flash recovery area.A  FLSHB  FLDBC  RVWRD  RVRWE  FBDA”相关问题

  • 第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题：

    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

  • 第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题：

    You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEES table. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area.  Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）

    • A、perform point-in-time recovery
    • B、perform a Flashback Table operation to restore the table to the state it was in two days ago
    • C、perform a Flashback Database operation to restore the database to the state it was in two days ago
    • D、perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery

    正确答案:D

  • 第5题：

    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 Recovery Area.
    • 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

  • 第6题：

    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

  • 第7题：

    单选题
    You work as a database administrator at Certkiller .com. You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEEStable. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）
    A

     perform point-in-time recovery

    B

     perform a Flashback Table operation to restore the table to the state it was in two days ago

    C

     perform a Flashback Database operation to restore the database to the state it was in two days ago

    D

     perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery


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

  • 第8题：

    单选题
    What does the DB_FLASHBACK_RETENTION_TARGET parameter configure？（）
    A

     An upper limit on how far you can flash back the database，depending on the information in the redo logs

    B

     An upper limit on how far you can flash back the database，depending on the information in the undo tablespace

    C

     The amount of time for which the flashback data is to be kept in the flash recovery area， provided that there is enough space

    D

     The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace，provided that there is enough space


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

  • 第9题：

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


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

  • 第10题：

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


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

  • 第11题：

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

  • 第12题：

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


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

  • 第13题：

    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

  • 第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题：

    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）

    正确答案:B

  • 第16题：

    What does the DB_FLASHBACK_RETENTION_TARGET parameter configure？（）  

    • A、 An upper limit on how far you can flash back the database，depending on the information in the redo logs
    • B、 An upper limit on how far you can flash back the database，depending on the information in the undo tablespace
    • C、 The amount of time for which the flashback data is to be kept in the flash recovery area， provided that there is enough space
    • D、 The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace，provided that there is enough space

    正确答案:C

  • 第17题：

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

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

    正确答案:C

  • 第18题：

    You work as a database administrator at Certkiller .com. You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEEStable. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）

    • A、 perform point-in-time recovery
    • B、 perform a Flashback Table operation to restore the table to the state it was in two days ago
    • C、 perform a Flashback Database operation to restore the database to the state it was in two days ago
    • D、 perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery

    正确答案:D

  • 第19题：

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


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

  • 第20题：

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

  • 第21题：

    单选题
    You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEES table. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area.  Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）
    A

    perform point-in-time recovery

    B

    perform a Flashback Table operation to restore the table to the state it was in two days ago

    C

    perform a Flashback Database operation to restore the database to the state it was in two days ago

    D

    perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery


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

  • 第22题：

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


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

  • 第23题：

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


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

相关内容