题目内容

若用SQL语句编写的转账业务事务程序如下:
START TRANSACTION;
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
UPDATE Accounts
SET CurrentBalance=CurrentBalance-Amount
WHERE AccountID=A;
if error then ROLLBACK;
COMMIT;
UPDATE Accounts
SET CurrentBalance=CurrentBalance+Amount
WHERE AccountID=B;
if error then ROLLBACK;
COMMIT;
其中:Accounts为账户表,CurrentBalance为当前余额,Amount为新存入的金额。
该事务程序能否保证数据的一致性?如不能,请说明原因并改正。(100字以内)

查看答案
更多问题

把整体市场细分为不同的市场,要以需求的同类性为基础,但确立一个具体的细分市场,又要以某些消费者需求的差异性为条件。()

影视艺术最独特的艺术语言就是蒙太奇。()

&8226;Read the text below about consumer electronics model.
&8226;In most of the lines 34--45 there is one extra word. It is either grammatically incorrect or does not fit in with the meaning of the text. Some lines, however, are correct.
&8226;If a line is correct, write CORRECT on your Answer Sheet.
&8226;If there is an extra word in the line, write the extra word in CAPITAL LETTERS on your Answer Sheet.
Interconnect Your Home
Correct If the Consumer Electronics Show (CES) in Las Vegas is any indication, this will
come be the year of PCs going from the desktop and come into your hand, your living
34 room, or your kitchen appliances. The idea of interconnectivity is emerged as a
35 central theme at the massive trade show. Increasing more companies, including
36 Microsoft, were showing off products that allow PCs, TVs, stereos, and media
37 recorders are to be connected by home networks. Intel said it would enter the
38 consumer electronics market as for the first time with a chip specifically
39 designed to provide power cheaper, better flat-panel TV displays and an
40 all-in-one home entertainment PC. "Entertainment PCs", according to Intel, will
41 come on the market later this year, priced at between 6, 400 yuan or less. They
42 are intended to offer that live TV tuning, video recording, DVD and photo display,
43 and even video gaming. What at stake is the traditional consumer electronics
44 model, since then PC companies push into the higher-margin market for
45 consumer electronics, driving down costs and playing up interactive feature.
(34)

In the experiment the recruiters should snap their fingers when they decide ______.

答案查题题库