XID
VERSIONS_PK
VERSIONS_XID
VERSIONS_UNIQUE
第1题:
By using the transaction identifier provided by()for a particular row change, you can use the Flashback Transaction Query to see the operation performed by the transaction.
第2题:
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?()
第3题:
In which scenario will you use the Flashback Transaction Query feature?()
第4题:
By using the transaction identifier provided by () for a particular row change, you can use theFlashback Transaction Query to see the operation performed by the transaction.
第5题:
By mistake, you ran the batch job (for updating the BILL_DETAILS table) twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify: a) A list of changes made along with the transaction identifier of each change. b) The necessary SQL statements to undo the erroneous changes. Which option would you choose?()
第6题:
when you want to restore an important table that is dropped from the Recycle Bin
when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction
when you want to restore a dropped user’s schema
when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period
第7题:
Flashback Table
Flashback Database
Flashback Version Query
The RMAN REPORT command
The DBA_PENDING_TRANSACTIONS view
第8题:
Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.
Flashback Versions Query is used to view all version changes on rows that existed between the time the query was executed and a point in time in the past.
Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.
Flashback Versions Query is used to view all version changes on rows that existed between two points in time.
第9题:
You must use automatic undo management in the database.
You must configure OMF in your database.
You must configure ASM for storing the datafiles.
You must multiplex the online redo log file.
第10题:
RMAN only
Flashback Table only
Flashback Versions Query only
Flashback Database and Flashback Transaction Query
Flashback Versions Query and Flashback Transaction Query
第11题:
You can use this feature to identify the committed versions of the rows, but not the uncommitted versions.
You can use this feature to identify the versions of V$ views.
You can use this feature to identify the inserts, deletes, and updates performed on a particular row but not the data definition language (DDL) operations performed on the table.
You can use this feature for a table only if row movement is enabled for the table.
You can use this feature to identify the versions of external and fixed tables.
第12题:
Flashback Table
Flashback Database
Flashback Versions Query
the RMAN REPORT command
the DBA_PENDING_TRANSACTIONS view
第13题:
By mistake, you ran the batch job (for updating the BILL_DETAILS table) twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify: a) a list of changes made along with the transaction identifier of each change b) the necessary SQL statements to undo the erroneous changes Which option would you choose?()
第14题:
In which scenario do you use the Flashback Database feature?()
第15题:
Which two statements are correct regarding the Flashback Versions Query feature?()
第16题:
By using the transaction identifier provided by () for a particular row change, you can use the Flashback Transaction Query to see the operation performed by the transaction.
第17题:
Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query?()
第18题:
when a table is dropped and you restore it from the Recycle Bin
when a user’s schema is dropped and you recover the user’s schema
when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp
when a row of a table is updated frequently and committed, and you view all the versions of the row within a specific duration
第19题:
VERSIONS_STARTSCN
VERSIONS_STARTTIME
VERSIONS_XID
VERSIONS_OPERATION
第20题:
Only the Flashback Table
Both the Flashback Transaction Query and the Flashback Version Query
Only the Flashback Drop
Only the Flashback Version
第21题:
The row movement is not enabled on the table.
The first two updates were not explicitly committed.
The Flashback Versions Query lists only the most recent update.
The Flashback Versions Query stops producing rows after it encounters a time in the past when the table structure was changed.
第22题:
when you want to restore a table that has been dropped from the Recycle Bin
when you want to identify the transaction ID of the transaction that deleted some important records from a table
when you want to recover the schema of a dropped user
when you want to restore a dropped tablespace
第23题:
RMAN only.
Flashback Table only.
Flashback Version Query only.
Flashback Database and Flashback Transaction Query.
Flashback Version Query and Flashback Transaction Query.
第24题:
XID
VERSIONS_PK
VERSIONS_XID
VERSIONS_UNIQUE