OCP-1Z0-053-V12.02-609题
来源:互联网 发布:ubuntu 16.04设置分区 编辑:程序博客网 时间:2024/06/05 20:36
609.Examine the following commands and their output:
SQL> SELECT ename, sal FROM emp WHERE ename='JAMES';
ENAME SAL JAMES 1050
SQL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename='JAMES';
1 row updated.
SQL> SELECT ename, sal FROM emp WHERE ename='JAMES';
ENAME SAL JAMES 2310
View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.
What could be the possible cause for the query not displaying any row?
A. Flashback logging is not enabled for the database.
B. The changes made to the table are not committed.
C. Supplemental logging is not enabled for the database.
D. The database is not configured in ARCHIVELOG mode.
Answer: B
答案解析:
参考:http://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS01004
Using Oracle Flashback Version Query
Use Oracle Flashback Version Query to retrieve the different versions of specific rows that existed during a given time interval. A row version is created whenever a COMMIT
statement is executed.
- OCP-1Z0-053-V12.02-609题
- OCP-1Z0-053-V12.02-679题
- OCP-1Z0-053-V12.02-591题
- OCP-1Z0-053-V12.02-590题
- OCP-1Z0-053-V12.02-552题
- OCP-1Z0-053-V12.02-551题
- OCP-1Z0-053-V12.02-549题
- OCP-1Z0-053-V12.02-548题
- OCP-1Z0-053-V12.02-234题
- OCP-1Z0-053-V12.02-584题
- OCP-1Z0-053-V12.02-595题
- OCP-1Z0-053-V12.02-184题
- OCP-1Z0-053-V12.02-59题
- OCP-1Z0-053-V12.02-676题
- OCP-1Z0-053-V12.02-667题
- OCP-1Z0-053-V12.02-660题
- OCP-1Z0-053-V12.02-580题
- OCP-1Z0-053-V12.02-323题
- python 函数参数的传递(参数带星号的说明)
- 学习opencv----采用Ptr2D()指向绿色通道
- C#动态执行函数:利用反射实现
- 报了这一个错,原来是找不到这个tld文件,把tld放到目录下就ok
- 获取最大值(经典!)
- OCP-1Z0-053-V12.02-609题
- 有关IE8样式不兼容css样式问题处理方式--充分利用IE8
- 剑指Offer之数值的整数次方
- Ubuntu笔记本屏幕亮度调节问题
- SVN版本冲突解决详解
- C# System.Reflection
- 16进制的字符串转数值函数
- SVN分支与合并使用教程——Tortoise SVN客户端
- 红豆子和绿豆子