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

题目内容 (请给出正确答案)
多选题
You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback?()
A

Oracle Flashback uses undo information to construct consistent data.

B

You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session.

C

You can only use Oracle Flashback view of the data if the required records are still in the online redo log files.

D

Oracle Flashback lists the DML that was executed during the period you identify when initiating your session.


参考答案

参考解析
解析: 暂无解析
更多 “多选题You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback?()AOracle Flashback uses undo information to construct consistent data.BYou can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session.CYou can only use Oracle Flashback view of the data if the required records are still in the online redo log files.DOracle Flashback lists the DML that was executed during the period you identify when initiating your session.” 相关考题
考题 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

考题 By using the transaction identifier provided by()for a particular row change, you can use the Flashback Transaction Query to see the operation performed by the transaction. A、 Flashback TableB、 Flashback DatabaseC、 Flashback Version QueryD、 The RMAN REPORT commandE、 The DBA_PENDING_TRANSACTIONS view

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

考题 On Jan 11, 2005 at 2:30 P.M., an erroneous update operation modified all the values of column LASTNAME in the EMPLOYEE table in the Scott schema to an empty string. You are the system administrator, and you want to return the original values in the table. To do so, you decided to flash back the table. Which two options can you use to flash back a table?()A、 by using Oracle Enterprise ManagerB、 by issuing the FLASHBACK TABLE statement at the RMAN promptC、 by issuing the FLASHBACK TABLE statement at the SQL promptD、 by issuing the FLASHBACK TABLE statement at the LSNRCTL prompt

考题 You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query?()A、 VERSIONS_STARTSCNB、 VERSIONS_STARTTIMEC、 VERSIONS_XIDD、 VERSIONS_OPERATION

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

考题 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 can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback?()A、Oracle Flashback uses undo information to construct consistent data. B、You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. C、You can only use Oracle Flashback view of the data if the required records are still in the online redo log files. D、Oracle Flashback lists the DML that was executed during the period you identify when initiating your session. 

考题 You query the ORDERS table and discover that order number 1101 is missing. One of your reports, generated at 5:00 A.M. on April 23, 2005 using Oracle Reports, includes this order number in the output. You have inserted 100 new orders into the ORDERS table since generating this report. Which flashback technology would you use to recover order number 1101 into the ORDERS table without losing the 100 orders that you added after the report was generated?()  A、 Flashback TableB、 Flashback QueryC、Flashback Version QueryD、 Flashback Transaction Query

考题 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 logsB、 An upper limit on how far you can flash back the database,depending on the information in the undo tablespaceC、 The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough spaceD、 The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace,provided that there is enough space

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

考题 You executed the following query in your database: SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()A、 The time when the last flashback operation in your database was performed.B、 The time when the first flashback operation in your database was performed.C、 A list of flashback operations performed in your database using SCN and time.D、 The approximate time and the lowest system change number (SCN) to which you can flash back your database.

考题 Which of the following Oracle features utilize the undo tablespace?() A、 Flashback QueryB、 Flashback DropC、 Flashback TableD、 Flashback DatabaseE、 Transaction ProcessingF、 Recycle Bin

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

考题 单选题By using the transaction identifier provided by()for a particular row change, you can use the Flashback Transaction Query to see the operation performed by the transaction.A  Flashback TableB  Flashback DatabaseC  Flashback Version QueryD  The RMAN REPORT commandE  The DBA_PENDING_TRANSACTIONS view

考题 单选题You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query?()A  VERSIONS_STARTSCNB  VERSIONS_STARTTIMEC  VERSIONS_XIDD  VERSIONS_OPERATION

考题 多选题On Jan 11, 2005 at 2:30 P.M., an erroneous update operation modified all the values of column LASTNAME in the EMPLOYEE table in the Scott schema to an empty string. You are the system administrator, and you want to return the original values in the table. To do so, you decided to flash back the table. Which two options can you use to flash back a table?()Aby using Oracle Enterprise ManagerBby issuing the FLASHBACK TABLE statement at the RMAN promptCby issuing the FLASHBACK TABLE statement at the SQL promptDby issuing the FLASHBACK TABLE statement at the LSNRCTL prompt

考题 单选题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 query the ORDERS table and discover that order number 1101 is missing. One of your reports, generated at 5:00 A.M. on April 23, 2005 using Oracle Reports, includes this order number in the output. You have inserted 100 new orders into the ORDERS table since generating this report. Which flashback technology would you use to recover order number 1101 into the ORDERS table without losing the 100 orders that you added after the report was generated?()A  Flashback TableB  Flashback QueryC Flashback Version QueryD  Flashback Transaction Query

考题 单选题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 logsB  An upper limit on how far you can flash back the database,depending on the information in the undo tablespaceC  The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough spaceD  The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace,provided that there is enough space

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

考题 单选题You executed the following query in your database: SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()A  The time when the last flashback operation in your database was performed.B  The time when the first flashback operation in your database was performed.C  A list of flashback operations performed in your database using SCN and time.D  The approximate time and the lowest system change number (SCN) to which you can flash back your database.

考题 多选题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? ()ASYSDATE should not be used with TIMESTAMP.BThe database must have multiplexed redo log files.CThe database must be in the MOUNT state to execute the command.DThe database must be opened with the RESETLOGS option after the flashback operation.EThe entire database needs to be restored from the most recent backup before the flashback operation.

考题 多选题You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback?()AOracle Flashback uses undo information to construct consistent data.BYou can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session.CYou can only use Oracle Flashback view of the data if the required records are still in the online redo log files.DOracle Flashback lists the DML that was executed during the period you identify when initiating your session.

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