网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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


参考答案

参考解析
解析: 暂无解析
更多 “单选题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, 5B  4, 3, 1, 2, 5C  2, 4, 3, 5, 1D  4, 2, 5, 3, 1” 相关考题
考题 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.

考题 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.

考题 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.

考题 Your Oracle Database 10g is online when you execute the following statement:        SQLALTER 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_TABLESPACEB、 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

考题 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$DATABASEB、 V$FLASHBACK_DATABASE_STATC、 V$FLASHBACK_DATABASE_LOGD、 V$RECOVERY_FILE_DEST

考题 In which case would you use the Flashback Database feature to perform a recovery?()A、to recover a dropped tablespaceB、to recover data from a truncated tableC、to recover a data file that has been shrunkD、to recover a database to the state that existed before the RESETLOGS operation

考题 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

考题 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).

考题 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 BinB、 when you want to identify the transaction ID of the transaction that deleted some important records from a tableC、 when you want to recover the schema of a dropped userD、when you want to restore a dropped tablespace

考题 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.

考题 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

考题 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$DATABASEB、 V$UNDOSTATC、 V$FLASHBACK_DATABASE_LOGD、 V$FLASHBACK_DATABASE_STAT

考题 You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure.  Which configuration will you do to accomplish the task()A、Multiplex all database filesB、Configure the Flash Recovery Area.C、Configure the database instance for ARCHIVELOG mode.D、Configure the FAST_START_MTTR_TARGET initialization parameter.

考题 At 10:30 A.M., you ran a batch job by mistake, which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11:10 A.M., you stopped the batch job. Now, you want to identify the changes made to the database tables by the batch job. Which view will you query?()A、 DBA_PENDING_TRANSACTIONSB、 DBA_AUDIT_STATEMENTC、 V$FLASHBACK_DATABASE_STATSD、 FLASHBACK_TRANSACTION_QUERY

考题 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.

考题 单选题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 BinB  when you want to identify the transaction ID of the transaction that deleted some important records from a tableC  when you want to recover the schema of a dropped userD when you want to restore a dropped tablespace

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

考题 多选题Which three actions are required to configure the Flashback Database?()Aset Flash Recovery AreaBenable Flashback loggingCcreate FLASHBACK tablespaceDstart the database in the ARCHIVELOG modeEstart the database in the NOARCHIVELOG mode

考题 多选题You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()AFlashback logs are not archived.BFlashback logs are maintained in redo log files.CFlashback logs are maintained in the Flash Recovery Area.DFlashback logs are used to maintain Flashback Database related errors.EFlashback logs need to be cleared manually after you disable Flashback Database.

考题 单选题Your Oracle Database 10g is online when you execute the following statement:        SQLALTER 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_TABLESPACEB  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

考题 单选题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$DATABASEB  V$FLASHBACK_DATABASE_STATC  V$FLASHBACK_DATABASE_LOGD  V$RECOVERY_FILE_DEST

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

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

考题 多选题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? ()AOpen the database in read-only mode.BSet the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.CEnable the block change tracking feature.DExecute the ALTER DATABASE FLASHBACK ON statement.

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

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

考题 单选题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: Choose the correct sequence.()A 4, 1, 3, 2, 5B 4, 3, 1, 2, 5C 2, 4, 3, 5, 1D 4, 2, 5, 3, 1