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

最新推荐文章于 2015-10-10 20:25:31 发布

Riveore

最新推荐文章于 2015-10-10 20:25:31 发布

阅读量5.2k

点赞数

分类专栏： OCP-1Z0-053 OCP11g解析

本文链接：https://blog.csdn.net/rlhua/article/details/14519763

版权

OCP11g解析同时被 2 个专栏收录

870 篇文章 151 订阅

订阅专栏

OCP-1Z0-053

796 篇文章 0 订阅

订阅专栏

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
`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`