173.When does a transaction complete? (Choose all that apply.)
来源：互联网 发布：3d算法必中直选 编辑：程序博客网 时间：2024/05/19 23:13
173.When does a transaction complete? (Choose all that apply.)
A.when a DELETE statement is executed
B.when a ROLLBACK command is executed
C.when a PL/SQL anonymous block is executed
D.when a data definition language ( DDL) statement is executed
E.when a TRUNCATE statement is executed after the pending transaction
答案:BDE
解析:
A：错误，delete对事务的提交和回滚没有影响
B：正确
C：错误，匿名块对事务的提交和回滚没有影响
D：正确
E：正确
A.when a DELETE statement is executed
B.when a ROLLBACK command is executed
C.when a PL/SQL anonymous block is executed
D.when a data definition language ( DDL) statement is executed
E.when a TRUNCATE statement is executed after the pending transaction
答案:BDE
解析:
A：错误，delete对事务的提交和回滚没有影响
B：正确
C：错误，匿名块对事务的提交和回滚没有影响
D：正确
E：正确
0 0
- 173.When does a transaction complete? (Choose all that apply.)
- 41 Which statements are true regarding table compression? (Choose all that apply.) A. It saves disk
- 37 In Oracle 11g, which recommendations does the SQL Access Advisor generate? (Choose all that apply
- 134.Where can subqueries be used? (Choose all that apply.)
- 134.Where can subqueries be used? (Choose all that apply.)
- 46.Which statements are correct regarding indexes? (Choose all that apply.)
- 74.Which statements are true regarding single row functions? (Choose all that apply.)
- 174.Which statement is true regarding transactions? (Choose all that apply.)
- 60.In which of the scenarios will the DBA perform recovery? (Choose all that apply.)
- 1.What are the prerequisites for performing flashback transactions? (Choose all that apply)
- 2 Which of the following cannot be used as input to the SQL Tuning Advisor? (Choose all that apply.)
- Define a one-to-many dependency between objects so that when one object changes state, all its depe
- 148.View the Exhibit. Which statements are true regarding the USERS tablespace? (Choose all that app
- mybatis choose when用法
- Write a method that returns all subsets of a set.
- Write a method that returns all subsets of a set
- Algorithm_Write a method that returns all subsets of a set.
- Effective C++ 24. Declare non-member functions when type convesions should apply to all parameters
- PowerDesign
- mybatis缓存 redis实现
- ubuntu连接windows远程桌面
- [Java] 浅谈泛型的意义与不足
- 【LeetCode-1】Two Sum
- 173.When does a transaction complete? (Choose all that apply.)
- chromium源码下载并编译
- 平均年龄-美团笔试
- tomcat Server Locations 不可用 两种解决方式
- keystore 获取(常用命令行,SDK创建应用,找应用签名的方法)
- css基础效果
- sdk23_EditText:singleLine="true"过时及引发inputType="textPassword"失效
- HTML5 表单元素
- iOS资源大全
