题目内容
（请给出正确答案）
A.开启事务，将a账户的100元钱转给b账户
B.开启事务，将b账户的100元钱转给a账户
C.提交事务，将a账户的100元钱转给b账户
D.提交事务，将b账户的100元钱转给a账户
如搜索结果不匹配，请 联系老师 获取答案
更多“阅读下面SQL语句： START TRANSACTION; …”相关的问题
第1题
B.COMMIT;
C.UPDATEaccountSETmoney=money-100WHEREtname='王小可';
D.CREATEDATABASEmydata;
第2题
CREATE TABLE销售明细表(
销售单据编号varchar(8)，
商品编号varchar(8)，
单价money，
数量int，
总价money
) ，
为了保证数据的一致性，建有如下触发器：
CREATE TRIGGER AutoCountSum
ON销售明细表FOR INSERT，UPDATE
AS
DECLARE@UnitPrice money，@Quantity int
DECLARE@Amount money
SELECT@UnitPrice=单价，@Quantity=数量
FROM inserted
SET@Amount=@UnitPrice*@Quantity
UPDATE销售明细表SET总价=@Amount
WHERE销售单据编号IN(SELECT销售单据编号FROM inserted)
AND商品编号IN(SELECT商品编号FROM inserted)
①设系统运行一段时间后此表中有近一百万条记录，此时发现对该表的插入操作速度很慢，请分析插入速度慢的原因。(3分)
在不改变数据库服务器硬件和表结构、不清理数据的情况下，请说明应如何优化此表的插入操作。(2分)
②在解决了①中的问题后，程序员在数据库中执行如下SQL语句：
SELECT商品编号，sum(总价)FROM销售明细表
WHERE单价>50
GROUP BY商品编号
请在不改变该SQL语句的情况下，给出提高该查询执行效率的方案。(5分)
第3题
A．there is only salt
B．metal tools are used
C．the people's trading needs are fairly simple
D．money is unheard of
第4题
Where you save your money often depends on what you are saving for. If you are saving to buy a dictionary or to go to a concert, then probably keep your money somewhere in your room.
If you are saving for a big purchase like a mountain bike or a school trip, where would you save your money One place to save money is the bank. Putting your money in a savings account will help your money earn more money. If you put your money in a piggy bank （猪形储蓄罐）,one year later you'll still have the same amount of money you put in. If you put your money in a savings account, one year later, you'll have more money than you put in.
Why When you keep your money in a bank, your money earns interest. Interest is the amount of money a bank pays you to use your money. The bank uses your money （and the money of other people, too） to loan money to people and businesses.
The bank will send you a statement several times a year. A．bank statement tells you how much money there is in your account. It also tells you how much interest you have earned. If you leave your money in the bank, you can watch it grow!
Another way you can save money is to buy a certificate of deposit or CD． If you have some money that you don't need to use for a long time, this is a good way to make your money grow.You can buy a CD at a bank. You agree not to use the money for a certain period of time.
That period might be from six months to five years. You can't touch your money during that time. If you do, you must pay .a penalty, or fee.
Since the bank is using your money for that time period, it will pay you interest. You will earn more interest with a CD than in a savings account. Can you guess why It's because you promise to leave your money in the bank for a certain period of time. Banks pay different rates of interest. So, you may want to compare rates in newspaper ads before buying a CD．
第 36 题 Which way will help your money earn more money.
A．Putting your money in your room.
B．Putting your money in a piggy bank,
C．Putting your money in your pocket.
D．Putting your money in a savings account.
第5题
If you are saving for a big purchase like a mountain bike or a school trip，where would you save your money?
One place to save money is the bank Putting your money in a savings account will help your money early more money If you put your money in a piggy bank(猪形储蓄罐)，one year later you’11 still have the same amount of money you put in.If you put your money in a savings account，one year later, you’ll have more money than you put in Why?
When you keep your money in a bank，your money earns interest.Interest is the amount of money a bank pays you to use your money.The bank uses your money (and the money of other people，too)to loan money to people and businesses.
The bank will send you a statement several times a year A bank statement tells you how much money you have in your account，It also tells you how much interest you have earned.If you leave your money in the bank，you Can watch it grow!
Another way you can save money is to buy a certificate of deposit or CD.If you have some money that you don’t need to use for a long time，this is a good way to make your money grow.
You Can buy a cd at a bank.You agree not to use the money for a certain period of time That period might be from six months to five years.You Can’t touch your money during that time If you do，you must pay a penalty，or fee.
第6题：Your money will earn more money if you put it
A．in your room
B．in a piggy bank
C．in your pocket
D．in a savings account
第6题
If you are saving for a big purchase like a mountain bike or a school trip, where would you save your money?
One place to save money is the bank.Putting your money in a savings account will help your money earn more money.If you put your money in a piggy bank(猪形储蓄罐)，one year later you’ll still have the same amount of money you put in
If you put your money in a savings account，one year late，you’ll have more money than you put in.Why?When you keep your money in a bank，your money earns interest.Interest is the amount of money a bank pays you to use your money. The bank uses your money(and the money of other people，too)to loan money to people and businesses.
The bank will send you a statement several times a year.A bank statement tells you how much money there is in your account，It also tells you how much interest you have earned
If you leave your money in the bank，you can watch it grow!Another way you can save money is to buy a certificate of deposit or CD. If you have some money that you don’t need to use for a long time，this is a good way to make your money grow.
You can buy a CD at a bank.You agree not to use the money for a certain period of time.
That period might be from six months to five years You can’t touch your money during that time.
If you do，you must pay a penalty，or fee.Since the bank is using your money for that time period，it will pay you interest.You will earn more interest with a CD than in a savings account.Can you guess why? It’s because
you promise to leave your money in the bank for a certain period of time. Banks pay different rates of interest. So,you may want to compare rates in newspaper ads before buying a CD.
第36题：Which way will help your money earn more money?
A．Putting your money in your room.
B．Putting your money in a piggy bank.
C．Putting your money in your pocket．
D．Putting your money in a savings account．
为了保护您的账号安全，请在“上学吧”公众号进行验证，点击“官网服务”-“账号验证”后输入验证码“”完成验证，验证成功后方可继续查看答案！
微信搜一搜
上学吧
微信搜一搜
上学吧
