(31)到(35)题使用下列数据表。 “外汇名”表: 外币代码 外币名称 现钞买入价 现钞卖出价 基准价 13 欧元 958.6400 985.2300 996.5400 28 英镑 1220.9700 1330.2200 1287.4565 37 法郎 592.7650 618.1305 612.5910 26 加元 516.4110 531.4280 519.8690 15 美元 811.5410 817.8900 815.6650 “持有数”表: 姓名 外币代码 持有数量 李巡芬 37 30000.00 张武奇 13 1000.00 陆凭凭 15 3000.00 陆凭凭 37 4000.00 张武奇 15 2200.00 林诗诗 26 2000.20 李巡芬 26 30000.00 张武奇 28 3000.00 陆凭凭 26 3000.00 陆凭凭 13 4000.00 张武奇 26 18000.00 删除“持有数”表中所有外币名称为“法郎”的记录,下列SQL语句正确的是( )。
A. DELETE FROM 持有数;
B. WHERE 持有数.外币代码=外汇名.外币代码;
C. AND 外币名称="法郎"
DELETE FROM 持有数,外汇名;
E. WHERE 持有数.外币代码=外汇名.外币代码;
F. AND 外币名称="法郎"
G. DELETE FROM 持有数 WHERE 外币代码 IN;
H. (SELECT 外币代码 FROM 外汇名 WHERE 外币名称="法郎")
I. DELETE FROM 持有数 WHERE 外币代码 IN;
J. SELECT 外币代码 FROM 外汇名 WHERE 外币名称="法郎"
Curt Dunnam bought a Chevrolet Blazer with one of the most popular new features in high-end cars: the OnStar personal security system. The heavily advertised communications and tracking feature is used nationwide by more than two million drivers, who simply push a button to connect, via a built-in cellphone, to a member of the OnStar staff. A Global Positioning System, or G. P. S. , helps the employee give verbal directions to the driver or locate the car after an accident. The company can even send a signal to unlock car doors for locked-out owners, or honk the horn to help people find their cars in an endless plain of parking spaces. The biggest selling point for the system is its use in thwarting car thieves. Once an owner reports to the police that a car has been stolen, the company can track it to help intercept the thieves, a service it performs about 400 times each month. But for Mr. Dunnam, the more he learned about his car’s security features, the less secure he felt. He has enough technical knowledge to worry that someone else-law enforcement officers, or hackers-could listen in on his phone calls, or gain control over his automotive systems without his knowledge or consent. "While I don’t believe G. M. intentionally designed this system to facilitate such activities, they sure have made it easy," he said. Mr. Dunnam said he had become even more concerned because of a federal appeals court case involving a criminal investigation, in which federal authorities had demanded that a company attach a wiretap to tracking services like those installed in his car. The suit did not reveal which company was involved. A three-judge panel in San Francisco rejected the request, but not on privacy grounds; the panel said the wiretap would interfere with the operation of the safety services. OnStar has said that its equipment was not involved in that case. An OnStar spokeswoman, Geri Lama, suggested that Mr. Dunnam’s worries were overblown. The signals that the company sends to unlock car doors or track location-based information can be triggered only with a secure exchange of specific identifying data, which ought to deter all but the most determined hackers, she said. OnStar spokeswoman suggested that Mr. Dunnam’s worries ______.
A. represented reasonable customers concerns
B. exaggerated the problems that might occur
C. presented the problems for them to solve
D. made sense due to the existence of hackers
(31)到(35)题使用下列数据表。 “外汇名”表: 外币代码 外币名称 现钞买入价 现钞卖出价 基准价 13 欧元 958.6400 985.2300 996.5400 28 英镑 1220.9700 1330.2200 1287.4565 37 法郎 592.7650 618.1305 612.5910 26 加元 516.4110 531.4280 519.8690 15 美元 811.5410 817.8900 815.6650 “持有数”表: 姓名 外币代码 持有数量 李巡芬 37 30000.00 张武奇 13 1000.00 陆凭凭 15 3000.00 陆凭凭 37 4000.00 张武奇 15 2200.00 林诗诗 26 2000.20 李巡芬 26 30000.00 张武奇 28 3000.00 陆凭凭 26 3000.00 陆凭凭 13 4000.00 张武奇 26 18000.00 计算出“陆凭凭”所持有的全部外币相当于人民币的价值数量,下列语句正确的是( )。 (某种外币相当于人民币数量的计算公式:人民币价值数量=该种外币的“现钞买入价”* 该种外币“持有数量”)
A. SEIECT SUM(现钞买入价*持有数量) AS 人民币价值;
B. FROM 持有数,外汇名;
C. WHERE 外汇名.外币代码=持有数.外币代码;
D. AND 姓名="陆凭凭"
E. SELECT SUM(现钞买入价*持有数量) As 人民币价值;
FROM 持有数,外汇名;
G. WHERE 外汇名.外币代码=持有数.外币代码;
H. FOR 姓名="陆凭凭"
I. SELECT COUNT(现钞买入价*持有数量) AS 人民币价值;
J. FROM 持有数,外汇名;
K. WHERE 外汇名.外币代码=持有数.外币代码;
L. AND 姓名="陆凭凭"
M. SELECT COUNT(现钞买入价*持有数量) AS 人民币价值;
N. FROM 持有数,外汇名;
O. WHERE 外汇名.外币代码=持有数.外币代码;
P. FOR 姓名="陆凭凭"