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

题目内容 (请给出正确答案)
单选题
Why would you use the following FLASHBACK TABLE command?() FLASHBACK TABLE emp TO TIMESTAMP (’11:45’.’hh12:mi’);
A

 to undo the changes made to the EMP table since the specified time

B

 to restore the EMP table that was wrongly dropped from the database

C

 to view the transactions that have modified the EMP table since the specified time

D

 to view the changes made to the EMP table for one or more rows since the specified time


参考答案

参考解析
解析: 暂无解析
更多 “单选题Why would you use the following FLASHBACK TABLE command?() FLASHBACK TABLE emp TO TIMESTAMP (’11:45’.’hh12:mi’);A  to undo the changes made to the EMP table since the specified timeB  to restore the EMP table that was wrongly dropped from the databaseC  to view the transactions that have modified the EMP table since the specified timeD  to view the changes made to the EMP table for one or more rows since the specified time” 相关考题
考题 Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed?() A. Because row IDs may change during the flashback operationB. Because the object number changes after the flashback operationC. Because the rows are retrieved from the recycle bin during the flashback operationD. Because the table is moved forward and back to a temporary during the flashback opertion

考题 You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows, You then issue the following statement to recover the table:SQL FLASHBACK TABLE sales_emp TO BEFORE DROP;What would be the outcome of the precedent statement?()A. It retrieves the latest version of the table from the recycle binB. It retrieves the oldest version of the table from the recycle binC. It retrieves the version of the table for which undo information is availableD. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column

考题 You opened the encryption wallet and then issued the following command:Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.What is the outcome?()A. It creates the table and encrypts the data in it.B. It generates an error because the wallet is closed.C. It creates the table but does not encrypt the data in it.D. It generates an error because the NO SALT option cannot be used with the ENCRYPT option.

考题 You are working in an online transaction processing (OLTP) environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the System Change Number (SCN) was 663571. After flashing back the CUSTOMERS table,you realize that the table is not in the correct state and the resultant changes are not what you had desired. So, you need to reverse the effects of the FLASHBACK TABLE command while ensuring that:  a) No other user data in the database is affected.  b) The operation takes the minimum possible time.  Which option would you choose?() A、use the ROLLBACK command with SCN 663571B、perform Flashback Transaction Query with SCN 663571C、execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571D、execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

考题 You are performing flashback of the EMPLOYEE table in SCOTT’s schema because some incorrect data was inserted into the table and committed by mistake. Which two clauses will you use in the FLASHBACK TABLE statement for using the Flashback Table feature? ()A、 RESETLOGSB、 TO TIMESTAMPC、 TO BEFORE DROPD、 RENAME TOE、 TO SCN

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

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

考题 Why would you use the following FLASHBACK TABLE command?() FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’); A、to undo the changes made to the EMP table since the specified timeB、to restore the EMP table that was wrongly dropped from the databaseC、to view the transactions that have modified the EMP table since the specified timeD、to view the changes made to the EMP table for one or more rows since the specified timeE、to recover the EMP table to a point in time in the past by restoring the most recent backup

考题 Note the output of the following query;   SQL SELECT flashback_archieve_name, status FROM dba_flashback_archieve; FLASHBACK_ARCHIEVE_NAME STATUS FLA1   You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table:   ALTER TABLE exchange_rate FLASHBACK ARCHIEVE;   What is the outcome of this command?()  A、 The table uses the default Flashback Data Archive.B、 The Flashback Data Archive Is created In the SYSAUX tablespace.C、 The Flashback Data Archive is created in the same tablespace where the tables are stored.D、 The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.

考题 You executed the following FLASHBACK TABLE command: FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’); Which two statements are correct? ()A、 The FLASHBACK TABLE statement will not be written to the alert log file.B、 The EMP table that was dropped by mistake from the database will be restored.C、 The changes made to the EMP table since the specified time will be undone.D、 The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.E、 The FLASHBACK TABLE statement will be executed within a single transaction.F、 The list of transactions that have modified the EMP table since the specified time will be displayed.

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

考题 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 working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06:00 p.m., you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03:00 p.m. What would you do to recover the table?()A、 use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the tableB、 restore the entire database from the most recent backup and open itC、 recover the table by using the Flashback Table featureD、 perform point-in-time recovery to recover the table

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

考题 单选题Why would you use the following FLASHBACK TABLE command?()  FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’);A to undo the changes made to the EMP table since the specified timeB to restore the EMP table that was wrongly dropped from the databaseC to view the transactions that have modified the EMP table since the specified timeD to view the changes made to the EMP table for one or more rows since the specified timeE to recover the EMP table to a point in time in the past by restoring the most recent backup

考题 单选题Why would you use the following FLASHBACK TABLE command?() FLASHBACK TABLE emp TO TIMESTAMP (’11:45’.’hh12:mi’);A  to undo the changes made to the EMP table since the specified timeB  to restore the EMP table that was wrongly dropped from the databaseC  to view the transactions that have modified the EMP table since the specified timeD  to view the changes made to the EMP table for one or more rows since the specified time

考题 多选题You executed the following FLASHBACK TABLE command: FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’); Which two statements are correct?()AThe FLASHBACK TABLE statement will not be written to the alert log file.BThe changes made to the EMP table since the specified time will be undone.CThe EMP table that was dropped by mistake from the database will be restored.DThe FLASHBACK TABLE statement will be executed within a single transaction.EThe FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.FThe list of transactions that have modified the EMP table since the specified time will be displayed.

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

考题 单选题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 working in an online transaction processing (OLTP) environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the System Change Number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state and the resultant changes are not what you had desired. So, you need to reverse the effects of the FLASHBACK TABLE command while ensuring that:  a) No other user data in the database is affected.  b) The operation takes the minimum possible time.  Which option would you choose?()A use the ROLLBACK command with SCN 663571B perform Flashback Transaction Query with SCN 663571C execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571D execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

考题 单选题You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?()A Restore the backup control file and open the database with RESETLOGS option.B Perform point-in-time recovery because flashback cannot be performed again on this tableC Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571D Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

考题 单选题Note the output of the following query;   SQL SELECT flashback_archieve_name, status FROM dba_flashback_archieve; FLASHBACK_ARCHIEVE_NAME STATUS FLA1   You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table:   ALTER TABLE exchange_rate FLASHBACK ARCHIEVE;   What is the outcome of this command?()A  The table uses the default Flashback Data Archive.B  The Flashback Data Archive Is created In the SYSAUX tablespace.C  The Flashback Data Archive is created in the same tablespace where the tables are stored.D  The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.

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

考题 单选题Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?()A Because row IDs may change during the flashback operationB Because the object number changes after the flashback operationC Because the rows are retrieved from the recycle bin during the flashback operationD Because the table is moved forward and back to a temporary during the flashback operation

考题 多选题You are performing flashback of the EMPLOYEE table in SCOTT’s schema because some incorrect data was inserted into the table and committed by mistake. Which two clauses will you use in the FLASHBACK TABLE statement for using the Flashback Table feature? ()ARESETLOGSBTO TIMESTAMPCTO BEFORE DROPDRENAME TOETO SCN

考题 单选题You are working in an online transaction processing (OLTP) environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the System Change Number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state and the resultant changes are not what you had desired. So, you need to reverse the effects of the FLASHBACK TABLE command while ensuring that:  a) No other user data in the database is affected.  b) The operation takes the minimum possible time.  Which option would you choose?()A  Use ROLLBACK command with SCN 663571.B  Perform Flashback Transaction Query with SCN 663571.C  Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571.D  Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571.

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

考题 单选题Before a Flashback Table operation,you execute the following command:   ALTER TABLE employees ENABLE ROW MOVEMENT;   Why would you need this to be executed?()A  Because row IDs may change during the flashback operationB  Because the object number changes after the flashback operationC  Because the rows are retrieved from the recycle bin during the flashback operationD  Because the table is moved forward and back to a temporary during the flashback opertion