Oracle 11G OCP 1Z0-053 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.

答案：（B、C）

解析：

根本沒有DBA_TRANSACTION_QUERY這個檢視, A, D答案完全一樣.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1285560/，如需轉載，請註明出處，否則將追究法律責任。