OCP-1Z0-053-V13.02-616题
来源:互联网 发布:保障房摇号软件 编辑:程序博客网 时间:2024/06/04 19:40
616.The EMP table has some discrepancy in data entry with a particular employee ID. You execute the
query as shown in the Exhibit to retrieve all versions of the row that exist between two SCNs.View the Exhibit.
Which two statements about the results of the query shown in the Exhibit are correct? (Choose two.)
Exhibit:
A. The LAST_SCN value in the first row is NULL, which means that the versions of the row still exist at SCN 6636300.
B. The LAST_SCN value in the second row in NULL, which means that the version of the row still exists at SCN 6636300.
C. The LAST_SCN value in the third row is 6636280, which means that the version of row exists above SCN 6636280.
D. The LAST_SCN value in the second row is NULL, which means that the version of the row no longer exists because it was deleted.
Answer: AD
答案解析:
参考:http://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS1006
Table 12-1 Oracle Flashback Version Query Row Data Pseudocolumns
VERSIONS_STARTSCN
VERSIONS_STARTTIME
Starting System Change Number (SCN) or TIMESTAMP
when the row version was created. This pseudocolumn identifies the time when the data first had the values reflected in the row version. Use this pseudocolumn to identify the past target time for Oracle Flashback Table or Oracle Flashback Query.
If this pseudocolumn is NULL
, then the row version was created before start
.
VERSIONS_ENDSCN
VERSIONS_ENDTIME
SCN or TIMESTAMP
when the row version expired.
If this pseudocolumn is NULL
, then either the row version was current at the time of the query or the row corresponds to a DELETE
operation.
VERSIONS_XID
Identifier of the transaction that created the row version.
VERSIONS_OPERATION
Operation performed by the transaction: I
for insertion, D
for deletion, or U
for update. The version is that of the row that was inserted, deleted, or updated; that is, the row after anINSERT
operation, the row before a DELETE
operation, or the row affected by an UPDATE
operation.
For user updates of an index key, Oracle Flashback Version Query might treat an UPDATE
operation as two operations, DELETE
plus INSERT
, represented as two version rows with a D
followed by an I
VERSIONS_OPERATION
.
- OCP-1Z0-053-V13.02-616题
- OCP-1Z0-053-V13.02-1题
- OCP-1Z0-053-V13.02-682题
- OCP-1Z0-053-V13.02-687题
- OCP-1Z0-053-V13.02-692题
- OCP-1Z0-053-V13.02-696题
- OCP-1Z0-053-V13.02-711题
- OCP-1Z0-053-V13.02-710题
- OCP-1Z0-053-V13.02-709题
- OCP-1Z0-053-V13.02-708题
- OCP-1Z0-053-V13.02-706题
- OCP-1Z0-053-V13.02-490题
- OCP-1Z0-053-V13.02-24题
- OCP-1Z0-053-V13.02-36题
- OCP-1Z0-053-V13.02-43题
- OCP-1Z0-053-V13.02-45题
- OCP-1Z0-053-V13.02-60题
- OCP-1Z0-053-V13.02-651题
- 一句话新闻
- 【Cocos2D-X 游戏引擎】初窥门径(4)Touch 事件:移动精灵
- NetFilter
- JQuery autocomplete使用手册
- TCP/IP详解学习笔记(7)-广播和多播,IGMP协议
- OCP-1Z0-053-V13.02-616题
- TCP/IP详解学习笔记(8)-DNS域名系统
- GLSL变换颜色的三角形(C语言)
- TCP/IP详解学习笔记(9)-TCP协议概述
- CodeForces 390C Inna and Candy Boxes
- NYOJ 479 Coprimes
- TCP/IP详解学习笔记(10)-TCP连接的建立与中止
- Top K 算法详解
- apache+tomcat,ngix+tomcat使用场景