OCP-1Z0-053-V12.02-387题

387.Which method could be utilized to identify both DML operations and the SQL statements needed to

undo those operations for a specific schema owner? (Choose all that apply.)

A. Query DBA_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL. Limit rows

by START_SCN and TABLE_OWNER.

B. Query FLASHBACK_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL.

Limit rows by START_SCN and TABLE_OWNER.

C. Query FLASHBACK_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL.

Limit rows by START_TIMESTAMP and TABLE_OWNER.

D. Query DBA_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL. Limit rows

by START_SCN and TABLE_OWNER.

Answer: BC

 答案解析：

START_SCN和START_TIMESTAMP都是指一个时间点。

FLASHBACK_TRANSACTION_QUERY

FLASHBACK_TRANSACTION_QUERY displays information about all flashback transaction queries in the database. The database must have at least minimal supplemental logging enabled to avoid unpredictable behavior.

Column	Datatype	NULL	Description
XID	RAW(8)	Transaction identifier
START_SCN	NUMBER	Transaction start system change number (SCN)
START_TIMESTAMP	DATE	Transaction start timestamp
COMMIT_SCN	NUMBER	Transaction commit system change number; NULL for active transactions
COMMIT_TIMESTAMP	DATE	Transaction commit timestamp; NULL for active transactions
LOGON_USER	VARCHAR2(30)	Logon user for the transaction
UNDO_CHANGE#	NUMBER	Undo system change number (1 or higher)
OPERATION	VARCHAR2(32)	Forward-going DML operation performed by the transaction: D - Delete I - Insert U - Update B UNKNOWN
TABLE_NAME	VARCHAR2(256)	Name of the table to which the DML applies
TABLE_OWNER	VARCHAR2(32)	Owner of the table to which the DML applies
ROW_ID	VARCHAR2(19)	Rowid of the row that was modified by the DML
UNDO_SQL	VARCHAR2(4000)	SQL to undo the DML indicated by OPERATION

来源： <FLASHBACK_TRANSACTION_QUERY>