Why would you use the following FLASHBACK TABLE command?() F

题目
单选题
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 backup

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

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.


参考答案:B

第2题:

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

第3题:

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 opertion


参考答案:A

第4题:

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.

正确答案:A

第5题:

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

正确答案:B

第6题:

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

正确答案:D

第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题:

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 bin

B. It retrieves the oldest version of the table from the recycle bin

C. It retrieves the version of the table for which undo information is available

D. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column


参考答案:A

第9题:

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 backup

正确答案:A

第10题:

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.

正确答案:C,E

更多相关问题