175.Which two statements are true regarding savepoints? (Choose two.)

最新推荐文章于 2022-04-28 20:33:47 发布
最新推荐文章于 2022-04-28 20:33:47 发布
阅读量1.4k 收藏
点赞数
分类专栏： 1z0-051 文章标签： 1z0-051
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/dwj19830118/article/details/51143942
版权
175.Which two statements are true regarding savepoints? (Choose two.)
A.Savepoints are effective only for COMMIT.
B.Savepoints may be used to ROLLBACK.
C.Savepoints can be used for only DML statements.
D.Savepoints are effective for both COMMIT and ROLLBACK.
E.Savepoints can be used for both DML and DDL statements.
答案：BC
解析：这里的savepoint是一种tc语言，也就是事务，这道题考察的还是事务，对事务有影响的包括ddl，dcl和tc(除savepoint)
A：错误 
B：正确
C：正确，oracle中对于产生事务的语句只有dml语句
D：错误，savepoint只对rollback有效，commit会把所有的事务进行提交，不管有多少savepoint都会提交
E：和C一样
今年我18
关注
专栏目录
OCP-1Z0-051 第48题 索引
Oracle
05-06 4347
一、原题 Which two statements are true regarding indexes? (Choose two.) A. They can be created on tables and clusters. B. They can be created on tables and simple views. C. You can create only one ind
ocp-1Z0-082
最新发布
qq_36369239的博客
05-04 3740
C、私有临时表和全局临时表都有ON COMMIT DELETE ROWS和ON COMMIT PRESERVE ROWS的两种分类(delete rows用于事务相关,也就在事务结束后truncate data in the temporary table,preserve rows表示在会话结束后清除临时表的数据)A、不可用索引会自动删除segment,但是索引分区后，某个分区的索引不可用，其它索引段还在的。B、私有临时表这个特性18C才引入。答案： B E F。答案： A B D。
oracle ocp 19c考题9，科目082考试题-关于SAVEPOINT
m0_65303136的博客
01-05 125
9.Which two statements are true regarding a SAVEPOINT? (Choose two.) A. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement B. Rolling back to a SAVEPOINT can undo a TRUNCATE statement C. Only one SAVEPOINT may be issued in a transaction D. A
OCP-1Z0-051 第175题 savepoint的注意事项
Oracle
05-26 4553
一、原题 Which two statements are true regarding savepoints? (Choose two.) A. Savepoints are effective only for COMMIT. B. Savepoints may be used to ROLLBACK. C. Savepoints can be used for only DML st
一起学OCP：oracle-082题库及解析(1-20)
技术螃蟹的博客
04-28 3878
一边学习一边整理，有错误的地方欢迎大家评论留言。最后祝愿大家都能顺利拿到OCP证书
130.Which two statements are true regarding listeners? (Choose two.)
dwj19830118的专栏
08-03 1459
130.Which two statements are true regarding listeners? (Choose two.)
OCP-1Z0-051-V9.02-175题
一抹曦阳-Oracle
10-21 9780
175. Which two statements are true regarding savepoints? (Choose two.) A. Savepoints are effective only for COMMIT. B. Savepoints may be used to ROLLBACK.  C. Savepoints can be used for only DML st
java经典常用笔试题（二）
辉的范你学不来的博客
07-22 2418
The following questions have appeared on actual exams. Situational details (ie, names, locations, and quantities) have been changed to avoid copyright infringement. Memorize as many of these questions as possible in the 5 nights prior to your exam. Good l
Oracle10gOCP042题库130题共168题
绿杨
04-17 225
原 Oracle 10g OCP 042 题库 1-30 题 共168题https://blog.csdn.net/tianlesoftware/article/details/5767606版权声明： https://blog.csdn.net/tianlesoftware/article/details/5767606 声明：对于答案的相关的说明，是个人对Oracle的理解。 1. Becau...
【渝粤题库】陕西师范大学200491英美概况 作业（高起专、高起本）
热门推荐
渝粤题库
11-18 1万+
I. Choose the correct answer to each of the following questions: 1.In its imperial prime, Britain ruled A. A fourth of the globe. B. A fifth of the world. C. A third of the world. D. Two-thirds of the earth. 2.Who were the ancestors of the Engl
108.Which two statements are true regarding the COUNT function? (Choose two.)
dwj19830118的专栏
03-07 2465
108.Which two statements are true regarding the COUNT function? (Choose two.)
OCP-1Z0-053-V13.02-14题
一抹曦阳-Oracle
11-17 9115
14.Which two statements are true regarding hot patching? (Choose two.) A. It requires relinking of the Oracle binary. B. It does not require database instance shutdown. C. It can detect conflicts b
139.Which two statements are true regarding a tablespace? (Choose two.)
dwj19830118的专栏
08-04 1376
139.Which two statements are true regarding a tablespace? (Choose two.)
28.Which two statements are true regarding constraints?
dwj19830118的专栏
12-18 2471
28.Which two statements are true regarding constraints?
savepoints
tony_0524的专栏
08-10 160
oracle中的savepoints是什么 2007年07月19日 星期四 18:52 给你个例子 SQL> create table test (id number(7)); 表已创建。 SQL> insert into test values (3); 已创建 1 行。 SQL> savepoint a; 保存点已创建。 SQL> insert into te...
29.Which two statements are true regarding constraints?
dwj19830118的专栏
12-21 2089
29.Which two statements are true regarding constraints?
46.Which statements are correct regarding indexes? (Choose all that apply.)
dwj19830118的专栏
02-25 2341
46.Which statements are correct regarding indexes? (Choose all that apply.)
41.Which two statements are true regarding views? (Choose two.)
dwj19830118的专栏
02-24 2260
41.Which two statements are true regarding views? (Choose two.)
35.Which two statements are true regarding constraints? (Choose two.)
dwj19830118的专栏
01-26 2012
35.Which two statements are true regarding constraints? (Choose two.)
c. 'switch ... case' statements are mandatory in 'public void onClick(View v)' function.
04-03
case' statements is not mandatory in the 'public void onClick(View v)' function. It is just one way of handling multiple button clicks within a single function. Other methods, such as using if-else ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值