OCP-1Z0-053-V13.02-141题
来源:互联网 发布:js怎么为radio赋值 编辑:程序博客网 时间:2024/06/03 07:04
141.Exhibit:
View the Exhibit for some of the current parameter settings. A user logs in to the HR schema and issues the following commands:
SQL> CREATE TABLE emp (empno NUMBER(3), ename VARCHAR2(20), sal NUMBER(8,2));
SQL>INSERT INTO emp(empno,ename) VALUES(1,'JAMES');
At this moment, a second user also logs in to the HR schema and issues the following command:
SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2);
What happens in the above scenario?
A. The second user's session immediately produces the resource busy error.
B. The second user's command executes successfully.
C. The second user's session waits for a time period before producing the resource busy error.
D. A deadlock is created.
Answer: C
答案解析:
参考:http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams074.htm#REFRN10267
DDL_LOCK_TIMEOUT
specifies a time limit for how long DDL statements will wait in a DML lock queue. The default value of zero indicates a status of NOWAIT
. The maximum value of 1,000,000 seconds will result in the DDL statement waiting forever to acquire a DML lock.
If a lock is not acquired before the timeout period expires, then an error is returned.
- OCP-1Z0-053-V13.02-141题
- 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题
- 定点DSP和浮点DSP差别
- Delphi DLL 入口点分析
- 不接sdk分享到微信,微博等第三方
- Linux中的HZ tick jiffies
- ios Socket使用大全
- OCP-1Z0-053-V13.02-141题
- 简单说说PHP优化那些事
- EWS Managed API 介绍
- windows7配置svn服务器
- linux下提示bash:command not found
- 黑马程序员_java编程基础第3天函数 数组
- CONNECT BY 的应用
- ftp配置
- java操作数据库