186.User A executes the following command to drop a large table in your database: SQL> DROP TABLE tr
来源：互联网 发布：手机检索专利软件 编辑：程序博客网 时间：2024/04/30 03:44
186.User A executes the following command to drop a large table in your database:
SQL> DROP TABLE trans;
While the drop table operation is in progress, user B executes the following command on the same table:
SQL> DELETE FROM trans WHERE tr_type='SL';
Which statement is true regarding the DELETE command?
A.It fails with a "Resource Busy" error.
B.It deletes the rows successfully because the table is locked in SHARE mode.
C.It fails to delete the records because the table is locked in EXCLUSIVE mode.
D.It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.
答案:C
解析：
1.当执行alter table,drop table ,drop index,truncate table,lock exclusive的时候会造成X(exclusive)排他锁,因此排除B,选择C
2.当执行lock share row exclusive的时候会造成SSX(S/Row-X)共享行级别排他锁，排除D
3.当执行insert,update,delete,lock row share的时候会造成SX(Row-X)行级排他锁，在提交前不允许做dml操作，如果操作的话会提示ORA-00054
也就是Resource Busy，因此排除A选项
SQL> DROP TABLE trans;
While the drop table operation is in progress, user B executes the following command on the same table:
SQL> DELETE FROM trans WHERE tr_type='SL';
Which statement is true regarding the DELETE command?
A.It fails with a "Resource Busy" error.
B.It deletes the rows successfully because the table is locked in SHARE mode.
C.It fails to delete the records because the table is locked in EXCLUSIVE mode.
D.It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.
答案:C
解析：
1.当执行alter table,drop table ,drop index,truncate table,lock exclusive的时候会造成X(exclusive)排他锁,因此排除B,选择C
2.当执行lock share row exclusive的时候会造成SSX(S/Row-X)共享行级别排他锁，排除D
3.当执行insert,update,delete,lock row share的时候会造成SX(Row-X)行级排他锁，在提交前不允许做dml操作，如果操作的话会提示ORA-00054
也就是Resource Busy，因此排除A选项
0 0
- 186.User A executes the following command to drop a large table in your database: SQL> DROP TABLE tr
- User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, or a
- 37.You issued the following command to drop the PRODUCTS table:
- 1Z0-051 37. You issued the following command to drop the PRODUCTS table:
- the database principal owns a service in the database -- can't drop a user
- How to drop a SQL Server database?
- 185.User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK,
- How to Create/Drop Database, Table
- 168.You execute this command to drop the ITEM table, which has the primary key referred in the ORDER
- 053-14 You have a very large table that your users access frequently. Which of the following advisor
- Oracle Flashback Drop: Undo a DROP TABLE Operation
- Drop and truncate table command
- 94.You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader
- Fastest Way to Update Rows in a Large Table in SQL Server
- Oracle database does not have a "drop table if exists" clause
- SQL DROP TABLE的用法
- SQL DROP TABLE的用法
- drop a database
- 生成一个集合的所有子集 Subset
- 关于解决android studio各种疑难杂症系列---- 工程的geadle版本跟当前环境不匹配
- TextView去掉自身自带的内边距
- [leetcode] 215. Kth Largest Element in an Array
- jquery 对 Json 的各种遍历
- 186.User A executes the following command to drop a large table in your database: SQL> DROP TABLE tr
- POJ 1141 Brackets Sequence（区间DP）
- MATLAT2012B安装license checkout failed
- IT相关证书
- 兼容ie select option 显示隐藏
- 187.Which two statements describe good practices for an application developer to reduce locking conf
- Handler
- static关键字其实一点也不安静
- Spring参考文档(4.3.2)
