Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?（）

相似题目

• You work as a database administrator for Certkiller .com. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go？ （）

  A . 3 hours B . 6 months C . until last year D . until last commit E . until the point when the undotablespacewas refreshed F . until the database is shut down and the memory erased

  查看最佳答案

• 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

  查看最佳答案

• 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.

  查看最佳答案

• 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 E . to recover the EMP table to a point in time in the past by restoring the most recent backu

  查看最佳答案

• 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 changes made to the EMP table since the specified time will be undone. C . The EMP table that was dropped by mistake from the database will be restored. D . The FLASHBACK TABLE statement will be executed within a single transaction. E . The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.  F . The list of transactions that have modified the EMP table since the specified time will be displayed.

  查看最佳答案

• What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archivingenabled?（）

  A . It fails with the ORA-665610 Invalid DDL statement on history-tracked message B . The rows in the table are truncated without being archived. C . The rows in the table are archived, and then truncated. D . The rows in both the table and the archive are truncated.

  查看最佳答案

• Which of the following statements is true regarding implementing a Flashback Table recovery？  （）

  A .  An SCN is never used to perform a Flashback Table recovery. B .  If a significant number of changes have been made to the table， row movement must be enabled. C .  The tablespace must be offline before performing a Flashback Table recovery. D .  Flashback Table recovery is completely dependent on the availability of undo data in the undo tablespace.

  查看最佳答案

• 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.

  查看最佳答案

• In which two scenarios should you issue the following command？（） FLASHBACK TABLE SCOTT.EMP TO TIMESTAMP SYSTIMESTAP- INTERVAL ’15’ MINUTE；

  A .  when the schema of the user， SCOTT， was deleted by mistake 15 minutes ago B .  when the table EMP of the SCOTT schema was dropped by mistake 15 minutes ago C .  when some rows of the table， EMP， in the SCOTT schema were deleted by mistake 15 minutes ago D .  when some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutes E .  never， because FLASHBACK TABLE is not a valid command in Oracle 10g.

  查看最佳答案

• Refer to the exhibit.After a RIP route is marked invalid on Router_1， how much time will elapse before that route is removed from the routing table？（）https://assets.asklib.com/images/image2/2018072315210946254.jpg

  A . 30 seconds B . 60 seconds C . 90 seconds D . 180 seconds E . 240 second

  查看最佳答案

• 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.

  查看最佳答案

• 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 E . to recover the EMP table to a point in time in the past by restoring the most recent backu

  查看最佳答案

• For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）

  A . UPDATE TABLE B . CREATE CLUSTER C . TRUNCATE TABLE D . ALTER TABLE MOVE E . INSERT INTO···VALUES F . ALTER TABLE···DROP COLUMN G . ALTER TABLE···DROP PARTITION

  查看最佳答案

• You executed the following query：  SELECT operation， undo_sql， table_name  FROM flashback_transaction_query;  Which statement is correct regarding the query output？（）

  A . It would return information regarding only the last committed transaction. B . It would return only the active transactions in all the undo segments in the database. C . It would return only the committed transactions in all the undo segments in the database.  D . It would return both active and committed transactions in all the undo segments in the database. E . It would return information regarding the transactions that began and were committed in the last 30 minutes.

  查看最佳答案

• You executed the following query：  SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）

  A .  It would return information regarding only the last committed transaction. B .  It would return only the active transactions in all the undo segments in the database. C .  It would return only the committed transactions in all the undo segments in the database. D .  It would return both active and committed transactions in all the undo segments in the database. E .  It would return information regarding the transactions that began and were committed in the last 30 minutes.

  查看最佳答案

• You executed the following query： SELECT operation， undo_sql， table_name FROM flashback_transaction_query；  Which statement is correct regarding the query output？（） 

  A . It would return information regarding only the last committed transaction. B . It would return only the active transactions in all the undo segments in the database. C . It would return only the committed transactions in all the undo segments in the database. D . It would return both active and committed transactions in all the undo segments in the database. E . It would return information regarding the transactions that began and were committed in the last 30 minutes.

  查看最佳答案

• 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.

  查看最佳答案

• 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 operation B .  Because the object number changes after the flashback operation C .  Because the rows are retrieved from the recycle bin during the flashback operation D .  Because the table is moved forward and back to a temporary during the flashback opertio

  查看最佳答案

• Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)

  A . Flash recovery area must be defined B . Undo retention guarantee must be enabled. C . Database must be running in archivelog mode. D . Automatic undo management must be enabled. E . The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).

  查看最佳答案

• refers to the fragrant and appetizing smell of the dishes, served on the table before eating.

  查看最佳答案

• W hen you finished your meal, put your fork and knife back on the table where they were before. ( )

  查看最佳答案

• —“May I speak to your manager Mr. Williams at five o’clock tonight？” —“I’m sorry. Mr. Williams ________ to a conference long before then.”

  A) will have gone B) had gone C) would have gone D) has gone

  查看最佳答案

• 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 operation B. Because the object number changes after the flashback operation C. Because the rows are retrieved from the recycle bin during the flashback operation D. Because the table is moved forward and back to a temporary during the flashback operation

  查看最佳答案

• <table><tbody><tr><td>二氧化碳的化学式是（）<table><tr><td>A．CO₂</td><td>B．H₂O</td><td>C．SO₂</td><td>D．CuO</td></tr></table></td></tr></tbody></table>

  查看最佳答案