违法和不良信息举报 联系客服
免费注册 登录

多选题You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）ATo recover a dropped table.BTo recover a dropped schema.CTo recover data from a truncated table.DTo view changes made by al

题目
多选题
You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）
A

To recover a dropped table.

B

To recover a dropped schema.

C

To recover data from a truncated table.

D

To view changes made by all the transactions during a given period of time.

E

To view changes made by a single transaction during a given period of time.

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

第1题：

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

第2题：

In which scenario do you use the Flashback Database feature？（）

  • A、 when a table is dropped and you restore it from the Recycle Bin
  • B、 when a user’s schema is dropped and you recover the user’s schema
  • C、 when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp
  • D、 when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration

正确答案:B

第3题：

The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action?()

A. All the related indexes and views are automatically dropped

B. The flashback drop feature can recover only the table structure

C. Only the related indexes are dropped whereas views are invalidated

D. The flashback drop feature can recover both the table structure and its data


参考答案：C, D

第4题：

You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）

  • A、 To recover a dropped table.
  • B、 To recover a dropped schema.
  • C、 To recover data from a truncated table.
  • D、 To view changes made by all the transactions during a given period of time.
  • E、 To view changes made by a single transaction during a given period of time.

正确答案:D,E

第5题：

In which case would you use the Flashback Database feature to perform a recovery？（）

  • A、to recover a dropped tablespace
  • B、to recover data from a truncated table
  • C、to recover a data file that has been shrunk
  • D、to recover a database to the state that existed before the RESETLOGS operation

正确答案:B

第6题：

The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? （）(Choose two)

  • A、All the related indexes and views are automatically dropped
  • B、The flashback drop feature can recover only the table structure
  • C、Only the related indexes are dropped whereas views are invalidated
  • D、The flashback drop feature can recover both the table structure and its data

正确答案:C,D

第7题：

Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?（）

  • A、point-in-time recovery
  • B、execute the ROLLBACK command with transaction number
  • C、flashback the database to before the transaction was committed
  • D、determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

正确答案:D

第8题：

Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?()

A. point-in-time recovery

B. execute the ROLLBACK command with transaction number

C. flashback the database to before the transaction was committed

D. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery


参考答案：D

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

The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema.  Which two statements are true regarding the outcome of this action？（）

  • A、 All the related indexes and views are automatically dropped
  • B、 The flashback drop feature can recover only the table structure
  • C、 Only the related indexes are dropped whereas views are invalidated
  • D、 The flashback drop feature can recover both the table structure and its data

正确答案:C,D

更多相关问题
相关内容