OCP 1Z0 051 158
来源:互联网 发布:手机格式化后数据恢复 编辑:程序博客网 时间:2024/06/01 19:10
158. Which statements are true regarding the FOR UPDATE clause in a SELECT statement? (Choose all
that apply.)
A. It locks only the columns specified in the SELECT list.
B. It locks the rows that satisfy the condition in the SELECT statement.
C. It can be used only in SELECT statements that are based on a single table.
D. It can be used in SELECT statements that are based on a single or multiple tables.
E. After it is enforced by a SELECT statement, no other query can access the same rows until a
COMMIT or ROLLBACK is issued.
见上一节
http://blog.csdn.net/jgmydsai/article/details/27846329
1、整行锁定
2、也可以锁定多个表
3、锁定当前过滤条件过滤出来的行
4、oracle读不等写,写不等读。锁定的行不会限制其它会话的读取。
Answer: BD
that apply.)
A. It locks only the columns specified in the SELECT list.
B. It locks the rows that satisfy the condition in the SELECT statement.
C. It can be used only in SELECT statements that are based on a single table.
D. It can be used in SELECT statements that are based on a single or multiple tables.
E. After it is enforced by a SELECT statement, no other query can access the same rows until a
COMMIT or ROLLBACK is issued.
见上一节
http://blog.csdn.net/jgmydsai/article/details/27846329
1、整行锁定
2、也可以锁定多个表
3、锁定当前过滤条件过滤出来的行
4、oracle读不等写,写不等读。锁定的行不会限制其它会话的读取。
Answer: BD
0 0
- OCP 1Z0 051 158
- OCP 1Z0 052 158
- OCP 1Z0 053 158
- OCP 1Z0 051 1
- OCP 1Z0 051 2
- OCP 1Z0 051 3
- OCP 1Z0 051 4
- OCP 1Z0 051 5
- OCP 1Z0 051 6
- OCP 1Z0 051 7
- OCP 1Z0 051 8
- OCP 1Z0 051 9
- OCP 1Z0 051 10
- OCP 1Z0 051 11
- OCP 1Z0 051 12
- OCP 1Z0 051 13
- OCP 1Z0 051 14
- OCP 1Z0 051 15
- 开始学习web安全 & 搭建 Damn Vulnerable Web App 渗透测试平台
- 编写ant:build.xml的方法
- 快速排序代码实现
- 一个长整数串去除m位使其最大
- Spring-配置文件Bean定义中parent属性详解
- OCP 1Z0 051 158
- 二分查找法
- 冒泡排序(转载等 要注明出处,谢谢!)
- java在指定路径下查找所有文件及其子文件名中,是否包含指定查询的关键字
- 加密与解密_Playfair密码变种加密方法-解题思路及过程
- 邮件正文及其附件的发送的C++实现
- hid keyboard device异常,电脑键盘驱动出现问题,无法输入,利用虚拟键盘解决问题
- DateTime之时间比较(Compare 方法)
- HDU 4839 The Game of Coins _(:зゝ∠)_