ITPub博客

首页 > 数据库 > Oracle > Oracle OCP 1Z0 053 Q387(FLASHBACK_TRANSACTION_QUERY)

Oracle OCP 1Z0 053 Q387(FLASHBACK_TRANSACTION_QUERY)

原创 Oracle 作者:abstractcyj 时间:2016-04-03 14:46:15 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


注意可以通过视图flashback_transaction_query,并指定SCN或者时间戳来检索DML历史

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8520577/viewspace-2074564/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
曾从事java方向开发多年。近年已经转入数据库方向。主要擅长SQL优化,Oracle数据库问题诊断,Oracle备份与恢复等。服务于医药物流,医院等行业

注册时间:2010-01-26

  • 博文量
    581
  • 访问量
    928075