单选题You enabled the flashback logging feature， but you have not specified the location of the flash recovery area.  Which location would be used as the default location for the flash recovery area？（）A the location used for control filesB the location used 

题目
单选题
You enabled the flashback logging feature， but you have not specified the location of the flash recovery area.  Which location would be used as the default location for the flash recovery area？（）
A

the location used for control files

B

the location used for redo log files

C

the location set by using $ORACLE_BASE

D

the location set by using $ORACLE_HOME

E

the location set by using CORE_DUMP_DEST

F

the location set by using BACKGROUND_DUMP_DEST

相似考题

1.You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.What must you do accomplish this task?()A. Enable supplemental logging for the database.B. Specify undo retention guarantee for the databaseC. Create Flashback Data Archive in the tablespace where the tables are stored.D. Create Flashback Data Archive and enable Flashback Data Archive for specific tables

2. You enabled the flashback logging feature， but you have not specified the location of the flash recovery area.  Which location would be used as the default location for the flash recovery area？（）A、the location used for control filesB、the location used for redo log filesC、the location set by using $ORACLE_BASED、the location set by using $ORACLE_HOMEE、the location set by using CORE_DUMP_DESTF、the location set by using BACKGROUND_DUMP_DEST

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.You must track all transactions that modify certain tables in the sales schema for at least three years.Automatic undo management is enabled for the database with a retention of one day.Which two must you do to track the transactions?（）A. Enable supplemental logging for the database.B. Specify undo retention guarantee for the database.C. Create a Flashback Data Archive in the tablespace where the tables are stored.D. Create a Flashback Data Archive in any suitable tablespace.E. Enable Flashback Data Archiving for the tables that require tracking

更多“You enabled the flashback logging feature， but you have not ”相关问题

  • 第1题：

    You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record， the SQL statement that will undo the deletion， and the transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks？（）

    • A、 Only the Flashback Table
    • B、 Both the Flashback Transaction Query and the Flashback Version Query
    • C、 Only the Flashback Drop
    • D、 Only the Flashback Version

    正确答案:B

  • 第2题：

    You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）

    • A、 You must enable the block change tracking feature.
    • B、 You must have enable the flashback feature.
    • C、 You must use the OMF in your database.
    • D、 You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

    正确答案:D

  • 第3题：

    Which two statements are correct regarding the Flashback Versions Query feature？（）

    • 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,C

  • 第4题：

    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

  • 第5题：

    You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table：  SQL> FLASHBACK TABLE ORDERS TO SCN 771513；   What is the prerequisite to perform Flashback Table？（）

    • A、 You must configure OMF in your database.
    • B、 You must enable block change tracking feature in your database.
    • C、 You must enable ROW MOVEMENT feature on the ORDERS table.
    • D、 You must use the Flashback Version Query before using the Flashback Table feature.

    正确答案:C

  • 第6题：

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


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

  • 第7题：

    单选题
    You have just performed a FLASHBACK TABLE operation using the following command：   flashback table employees to scn 123456；   The employees table has triggers associated with it.  Which of the following statements is true regarding the state of the triggers during the Flashback Table operation？（）
    A

     All the triggers are disabled.

    B

     All the triggers are enabled by default.

    C

     Enabled triggers remain enabled and disabled triggers remain disabled.

    D

     Triggers are deleted when a Flashback Table operation is performed.


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

  • 第8题：

    单选题
    You enabled the flashback logging feature， but you have not specified the location of the flash recovery area.  Which location would be used as the default location for the flash recovery area？（）
    A

    the location used for control files

    B

    the location used for redo log files

    C

    the location set by using $ORACLE_BASE

    D

    the location set by using $ORACLE_HOME

    E

    the location set by using CORE_DUMP_DEST

    F

    the location set by using BACKGROUND_DUMP_DEST


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

  • 第9题：

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


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

  • 第10题：

    单选题
    On Monday， you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct？（）
    A

     You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.

    B

     You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.

    C

     You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.

    D

     You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.


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

  • 第11题：

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


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

  • 第12题：

    单选题
    You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database. What must you do accomplish this task?（）
    A

    Enable supplemental logging for the database.

    B

    Specify undo retention guarantee for the database

    C

    Create Flashback Data Archive in the tablespace where the tables are stored.

    D

    Create Flashback Data Archive and enable Flashback Data Archive for specific tables


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

  • 第13题：

    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

  • 第14题：

    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

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

    正确答案:B

  • 第16题：

    You have just performed a FLASHBACK TABLE operation using the following command：   flashback table employees to scn 123456；   The employees table has triggers associated with it.  Which of the following statements is true regarding the state of the triggers during the Flashback Table operation？（）  

    • A、 All the triggers are disabled.
    • B、 All the triggers are enabled by default.
    • C、 Enabled triggers remain enabled and disabled triggers remain disabled.
    • D、 Triggers are deleted when a Flashback Table operation is performed.

    正确答案:A

  • 第17题：

    单选题
    On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s backup is the most recent backup.Which flashback feature would you use？（）
    A

     Flashback Drop

    B

     Flashback Table

    C

     Flashback Database

    D

     Flashback Version Query

    E

     Flashback Transaction Query


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

  • 第18题：

    单选题
    You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record， the SQL statement that will undo the deletion， and the transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks？（）
    A

     Only the Flashback Table

    B

     Both the Flashback Transaction Query and the Flashback Version Query

    C

     Only the Flashback Drop

    D

     Only the Flashback Version


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

  • 第19题：

    单选题
    You enabled the flashback logging feature， but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area？（）
    A

     The location used for control files.

    B

     The location used for redo log files.

    C

     The location set by using $ORACLE_BASE

    D

     The location set by using $ORACLE_HOME

    E

     The location set by using CORE_DUMP_DEST

    F

     The location set by using BACKGROUND_DUMP_DEST


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

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

    单选题
    You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table：  SQL> FLASHBACK TABLE ORDERS TO SCN 771513；   What is the prerequisite to perform Flashback Table？（）
    A

     You must configure OMF in your database.

    B

     You must enable block change tracking feature in your database.

    C

     You must enable ROW MOVEMENT feature on the ORDERS table.

    D

     You must use the Flashback Version Query before using the Flashback Table feature.


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

  • 第23题：

    单选题
    You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）
    A

     You must enable the block change tracking feature.

    B

     You must have enable the flashback feature.

    C

     You must use the OMF in your database.

    D

     You must define the tablespace of the SCOTT.EMP table for automatic segment space management.


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

  • 第24题：

    单选题
    On Monday， you dropped the DEPT table from your schema and then you re/x7fcreated the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct？（）
    A

    You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.

    B

    You can restore the DEPT table by using the Oracle Flashback Drop feature and a system­generated name will be assigned to the restored table.

    C

    You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table withthe name DEPT already exists in your schema.

    D

    You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.


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

相关内容