多选题What are the prerequisites for enabling Flashback Database？ （）AThe database must be started in the MOUNT EXCLUSIVE state.BThe database must have multiplexed control files.CThe database must be opened by using a text-based parameter file instead of a se

题目
多选题
What are the prerequisites for enabling Flashback Database？ （）
A

The database must be started in the MOUNT EXCLUSIVE state.

B

The database must have multiplexed control files.

C

The database must be opened by using a text-based parameter file instead of a server parameter file （SPFILE）.

D

The database must be in ARCHIVELOG mode.

E

The database must be in the NOMOUNT state.

F

The database must be opened in RESTRICTED mode.

相似考题

1.What two are the prerequisites for enabling Flashback Database?()A. The database must be in ARCHIVELOG modeB. The database must be in MOUNT EXCLUSIVE modeC. The database must be opened in RESTRICTED modeD. The database instance must be started in the NOMOUNT stateE. The database instance must have the keep buffer pool defined

2.You plan to execute the following command to perform a Flashback Database operation in your database:SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE －5／24);Which two statements are true about this?()A. The database must have multiplexed redo log filesB. The database must be in the MOUNT state to execute the commandC. The database must be in the NOMOUNT state to execute the commandD. The database must be opened in RESTRICTED mode before this operationE. The database must be opened with the RESETLOGS option after the flashback operation

3.Which two statements are correct about database transportation? ()A. The source and target platforms must be the sameB. Redo logs, control files and temp files are also transportedC. The transported database must have the same database identifier (DBID) as the source database and cannot be changedD. The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transportedE. Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format

4.You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）A. Mount the databaseB. Open the database in NORMAL modeC. Open the database in RESTRICTED modeD. Open the database with the RESETLOGS option

更多“多选题What are the prerequisites for enabling Flashback Database？ （）AThe database must be started in the MOUNT EXCLUSIVE state.BThe database must have multiplexed control files.CThe database must be opened by using a text-based parameter file instead of a se”相关问题

  • 第1题：

    Which two statements are correct about database transportation?() (Choose two.)

    A. The source and target platforms must be the same

    B. Redo logs, control files and temp files are also transported

    C. The transported database must have the same database identifier (DBID) as the source database and cannot be changed

    D. The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported

    E. Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format


    参考答案：D, E

  • 第2题：

    Which two are prerequisites for performing a flashback transaction?()

    A. Flashback Database must be enabled.

    B. Undo retention guarantee for the database must be configured.

    C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.

    D. Supplemental logging must be enabled.

    E. Recycle bin must be enabled for the database.

    F. Block change tracking must be enabled tor the database.


    参考答案：B, C

  • 第3题：

    What two are the prerequisites for enabling Flashback Database?（） (Choose two)

    • A、The database must be in ARCHIVELOG mode
    • B、The database must be in MOUNT EXCLUSIVE mode
    • C、The database must be opened in RESTRICTED mode
    • D、The database instance must be started in the NOMOUNT state
    • E、The database instance must have the keep buffer pool defined

    正确答案:A,B

  • 第4题：

    You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）;  Which two statements are true？ （）

    • A、SYSDATE should not be used with TIMESTAMP.
    • B、The database must have multiplexed redo log files.
    • C、The database must be in the MOUNT state to execute the command.
    • D、The database must be opened with the RESETLOGS option after the flashback operation.
    • E、The entire database needs to be restored from the most recent backup before the flashback operation.

    正确答案:C,D

  • 第5题：

    You plan to execute the following command to perform a Flashback Database operation in your database：   SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）；   Which two statements are true about this？（）

    • A、 The database must have multiplexed redo log files
    • B、 The database must be in the MOUNT state to execute the command
    • C、 The database must be in the NOMOUNT state to execute the command
    • D、 The database must be opened in RESTRICTED mode before this operation
    • E、 The database must be opened with the RESETLOGS option after the flashback operation

    正确答案:B,E

  • 第6题：

    You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）

    • A、Mount the database
    • B、Open the database in NORMAL mode
    • C、Open the database in RESTRICTED mode
    • D、Open the database with the RESETLOGS option

    正确答案:A

  • 第7题：

    Which two statements are correct about database transportation? （）

    • A、The source and target platforms must be the same
    • B、Redo logs, control files and temp files are also transported
    • C、The transported database must have the same database identifier (DBID) as the source database and cannot be changed
    • D、The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported
    • E、Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format

    正确答案:D,E

  • 第8题：

    Which two are prerequisites for performing a flashback transaction?（）

    • A、Flashback Database must be enabled.
    • B、Undo retention guarantee for the database must be configured.
    • C、EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
    • D、Supplemental logging must be enabled.
    • E、Recycle bin must be enabled for the database.
    • F、Block change tracking must be enabled tor the database.

    正确答案:B,C

  • 第9题：

    多选题
    Which two statements are correct about database transportation? （）
    A

    The source and target platforms must be the same

    B

    Redo logs, control files and temp files are also transported

    C

    The transported database must have the same database identifier (DBID) as the source database and cannot be changed

    D

    The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported

    E

    Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format


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

  • 第10题：

    多选题
    You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE ？5/24）； Which two statements are true？ （）
    A

    SYSDATE should not be used with TIMESTAMP.

    B

    The database must have multiplexed redo log files.

    C

    The database must be in the MOUNT state to execute the command.

    D

    The database must be opened with the RESETLOGS option after the flashback operation.

    E

    The entire database needs to be restored from the most recent backup before the flashback operation.


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

  • 第11题：

    多选题
    What two are the prerequisites for enabling Flashback Database?（）
    A

    The database must be in ARCHIVELOG mode

    B

    The database must be in MOUNT EXCLUSIVE mode

    C

    The database must be opened in RESTRICTED mode

    D

    The database instance must be started in the NOMOUNT state

    E

    The database instance must have the keep buffer pool defined


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

  • 第12题：

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


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

  • 第13题：

    What two are the prerequisites for enabling Flashback Database?() (Choose two)

    A. The database must be in ARCHIVELOG mode

    B. The database must be in MOUNT EXCLUSIVE mode

    C. The database must be opened in RESTRICTED mode

    D. The database instance must be started in the NOMOUNT state

    E. The database instance must have the keep buffer pool defined


    参考答案：A, B

  • 第14题：

    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

  • 第15题：

    You work as a database administrator for Certkiller .com. In your production  database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections.  Which activity must you have completed before accomplishing this task？（）

    • A、You must have started the database instance in restricted mode.
    • B、You must have started the database instance inNORMALmode.
    • C、You must have started the database instance with server parameter file.
    • D、You must have started the database instance but must not have mounted.
    • E、You must have started the database instance but must not have opened.

    正确答案:C

  • 第16题：

    What two are the prerequisites for enabling Flashback Database?（）

    • A、The database must be in ARCHIVELOG mode
    • B、The database must be in MOUNT EXCLUSIVE mode
    • C、The database must be opened in RESTRICTED mode
    • D、The database instance must be started in the NOMOUNT state
    • E、The database instance must have the keep buffer pool defined

    正确答案:A,B

  • 第17题：

    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

  • 第18题：

    You are managing a single instance Oracle 10g database that utilizes the following parameters：  Which of the following set of commands must you execute to enable Flashback Database？（）

    • A、  STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；
    • B、  STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；
    • C、  STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；
    • D、  STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

    正确答案:D

  • 第19题：

    What are the prerequisites for enabling Flashback Database？ （）

    • A、 The database must be started in the MOUNT EXCLUSIVE state.
    • B、 The database must have multiplexed control files.
    • C、 The database must be opened by using a text-based parameter file instead of a server parameter file （SPFILE）.
    • D、 The database must be in ARCHIVELOG mode.
    • E、 The database must be in the NOMOUNT state.
    • F、 The database must be opened in RESTRICTED mode.

    正确答案:A,D

  • 第20题：

    多选题
    You plan to execute the following command to perform a Flashback Database operation in your database：   SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）；   Which two statements are true about this？（）
    A

    The database must have multiplexed redo log files

    B

    The database must be in the MOUNT state to execute the command

    C

    The database must be in the NOMOUNT state to execute the command

    D

    The database must be opened in RESTRICTED mode before this operation

    E

    The database must be opened with the RESETLOGS option after the flashback operation


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

  • 第21题：

    多选题
    What two are the prerequisites for enabling Flashback Database?（） (Choose two)
    A

    The database must be in ARCHIVELOG mode

    B

    The database must be in MOUNT EXCLUSIVE mode

    C

    The database must be opened in RESTRICTED mode

    D

    The database instance must be started in the NOMOUNT state

    E

    The database instance must have the keep buffer pool defined


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

  • 第22题：

    多选题
    Which two are prerequisites for performing a flashback transaction?（）
    A

    Flashback Database must be enabled.

    B

    Undo retention guarantee for the database must be configured.

    C

    EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.

    D

    Supplemental logging must be enabled.

    E

    Recycle bin must be enabled for the database.

    F

    Block change tracking must be enabled tor the database.


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

  • 第23题：

    单选题
    You are managing a single instance Oracle 10g database that utilizes the following parameters：  Which of the following set of commands must you execute to enable Flashback Database？（）
    A

      STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

    B

      STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；

    C

      STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；

    D

      STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；


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

相关内容