CMS专题
单选题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 tri
题目
All the triggers are disabled.
All the triggers are enabled by default.
Enabled triggers remain enabled and disabled triggers remain disabled.
Triggers are deleted when a Flashback Table operation is performed.
参考答案和解析
相似问题和答案
第1题：
You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?（）
- A、Drop the table.
- B、Partition the table
- C、Truncate the table.
- D、Add a column to the table.
- E、Rename a column in the table.
正确答案:D
第2题：
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 Manager
- B、 by issuing the FLASHBACK TABLE statement at the RMAN prompt
- C、 by issuing the FLASHBACK TABLE statement at the SQL prompt
- D、 by issuing the FLASHBACK TABLE statement at the LSNRCTL prompt
正确答案:A,C
第3题：
Which two statements regarding the Flashback Table feature are correct?（）
- A、Flashback Table can be performed on system tables.
- B、Flashback Table operation does not shrink the segments.
- C、Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.
- D、Flashback Table operation acquires exclusive data manipulation language (DML) locks.
正确答案:B,D
第4题：
A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take？（）
- A、 Initiate an incomplete recovery operation using RMAN.
- B、 Copy the table from a development database.
- C、 Advise the user to rekey the data.
- D、 Perform a Flashback Drop operation.
- E、 Perform a Flashback Recovery operation.
正确答案:D
第5题：
By using the transaction identifier provided by （） for a particular row change， you can use theFlashback Transaction Query to see the operation performed by the transaction.
- A、Flashback Table
- B、Flashback Database
- C、Flashback Versions Query
- D、the RMAN REPORT command
- E、the DBA_PENDING_TRANSACTIONS view
正确答案:C
第6题：
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、 RESETLOGS
- B、 TO TIMESTAMP
- C、 TO BEFORE DROP
- D、 RENAME TO
- E、 TO SCN
正确答案:B,E
第7题：
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 Table
- B、 Flashback Query
- C、Flashback Version Query
- D、 Flashback Transaction Query
正确答案:B
第8题：
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 Table
- B、 Flashback Database
- C、 Flashback Version Query
- D、 The RMAN REPORT command
- E、 The DBA_PENDING_TRANSACTIONS view
正确答案:C
第9题：
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.
正确答案:D
第10题：
You executed the following query in your database： 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
正确答案:D