Which SQL statement is used to set transaction properties such as isolation level in SQL:92?单项选择题

登录即可查看完整答案

我们收录了全球超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?

How to start a user defined transaction in SQL?

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?

更多留学生实用工具

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