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

  查看最佳答案

• 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

  查看最佳答案

• 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

  查看最佳答案

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

  查看最佳答案