How to start a user defined transaction in SQL?单项选择题

A

BEGIN TRANSACTION

B

START TRANSACTION

C

START

D

SET AUTOCOMMIT=0

登录即可查看完整答案

我们收录了全球超50000道真实原题与详细解析,现在登录,立即获得答案。

类似问题

Consider the following transaction: START TRANSACTION; INSERT INTO Product VALUES (G43547, "Gucci", "BAMBOO 1947 MINI BAG", 5840, 4300); UPDATE Product SET RetailPrice = RetailPrice * 0.95; COMMIT; ROLLBACK; What will be the result of Rollback in the code above?

Transactions: Case Study Scenario C Time Renata Lillian 0 INSERT INTO Students VALUES (‘[email protected]’, ‘Colton', 85);   1   SELECT * FROM Students; 2 INSERT INTO Students VALUES (‘[email protected]’, ‘David’, 64);     Which result (see Transactions: Case Study Intro) would you expect to see if you were Lillian, when she runs the query?

Transactions: Case Study Scenario B Time Renata Lillian 0 BEGIN;   1 INSERT INTO Students VALUES (‘[email protected]’, ‘Colton', 85);   2   SELECT * FROM Students; 3 INSERT INTO Students VALUES (‘[email protected]’, ‘David’, 64);   4 COMMIT;     Which result (see Transactions: Case Study Intro) would you expect to see if you were Lillian, when she runs the query?

Which of the following statements about COMMIT and ROLLBACK commands is not correct?

更多留学生实用工具

加入我们，立即解锁 海量真题 与 独家解析，让复习快人一步！