You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）

A、 VERSIONS_STARTSCN

B、 VERSIONS_STARTTIME

C、 VERSIONS_XID

D、 VERSIONS_OPERATION

相关问题推荐

• A media failure has occurred. This has resulted in all the members of the next hop log group being rendered inaccessible to the log writer process （LGWR） at a log switch. How does this failure affect the operational database？（）

  A、 The database re-created the missing redo log files automatically.

  B、 The database continues to function normally with the existing files.

  C、 The database allows only queries， no other statements are allowed.

  D、 The database returns and error and the database instance shuts down.

  E、 The user sessions that generate redo logs are terminated automatically.

  查看答案

• You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze？（）

  A

   Top SQL

  B

   snapshots

  C

   SQL Tuning sets

  D

   index access path

  E

   optimizer statistics

  F

   materialized view logs

  查看答案

• You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）

  A、 V$BACKUP_CORRUPTION

  B、 V$COPY_CORRUPTION

  C、 V$DATABASE_BLOCK_CORRUPTION

  D、 RC_BACKUP_CORRUPTION

  查看答案

• You issued the following statement in your SQL*Plus session：   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600；   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）

  A、 creating a table in your schema and you exceed your allocated space quota on the tablespace

  B、 executing a long query that involves a sort operation and the statement runs out of temporary space

  C、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit

  D、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

  查看答案

• You are working as a Database Administrator. You erroneously dropped an important table named WAREHOUSE_DETAILS. The table resides in a non-SYSTEM tablespace.  The following dependent objects have been defined on the dropped table：       Due to limited space， some of the indexes and triggers have been removed from the Recycle Bin. You decide to recover the table by using Flashback Drop. You execute the following statement： SQL>FLASHBACK TABLE warehouse_details TO BEFORE DROP；   What will be the implication of executing this statement？（）

  A、  Only the WAREHOUSE_DETAILS table is recovered， and none of the dependent objects are recovered.

  B、  The WAREHOUSE_DETAILS table is recovered along with the NOT NULL constraints， primary key constraint， and the referential integrity constraints.

  C、  The WAREHOUSE_DETAILS table is recovered along with all the dependent objects except the indexes and triggers previously removed from the Recycle Bin.

  D、  The WAREHOUSE_DETAILS table is recovered along with all the dependent objects except the referential integrity constraints and the indexes and triggers previously removed from the Recycle Bin.

  查看答案