问题 单项选择题

(31)到(35)题使用下列数据表。
部门(部门号C (2)、部门名称C (10))
职工(部门号C (2)、职工号C(4)、姓名C(8)、基本工资N(7,2))

向职工表中插入一条记录,正确的命令是( )。

A.APPEND BLANK 职工 VALUES("33", "3305", "李运来", "2700.00")

B.APPEND INTO 职工 VALUES("33","3305","李运来",2700.00)

C.INSERT INTO 职工 VALUES("33","3305","李运来","2700.00")

D.INSERT INTO 职工 VALUES("33","3305","李运来",2700.00)

答案

参考答案:D

解析: Visual FoxPro支持两种SQL插入格式,第一种为标准格式,第二种是Visual FoxPro的特殊格式。
第一种格式为:
INSERT INTO <表名>[(字段名 1[,字段名2,...])];
VALUES(表达式1[,表达式2,...])
其中INSERT INTO <表名>说明向指定的表中插入记录。当插入的不是完整的记录时,可以用字段名1,字段名2,...指定字段;VALUE (表达式1[,表达式2,...])给出具体的记录值。
插入记录时,要注意插入的数据的类型与其字段类型要相同,本题中成绩为数值型数据,不能加字符串定界符("");选项A)和选项B)的语法错误。

阅读理解

Americans are buying more products and services than ever before through the Internet, and the popularity of online sales is likely to spread to other countries. Online sales now represent as much as one-tenth of all retail(零售) sales in the United States,which has led traditional stores to seek new ways to keep their customers loyal.

Lynne Shaner used the Internet to buy everything she needed for her wedding and holiday gifts for her husband. Other than food, 90 percent of her purchases(购买的东西) were made on her home computer. “I find that, by being able to go online and opt for the things that I need to select and have them delivered to me right at my doorstep, I’m free from all the driving, all the crowds, all the noise, and I usually get a better selection.”

There are a lot of people like her. Experts say American online shopping hit records in both November and December. Fifty-seven percent of Americans have bought something electronically. Store owners worry that this growing amount of online sales will hurt their business. Cornell University marketing professor Ed McLaughlin says, “They should be worried. Anything that can move online will be sold online. And it's just a matter of time. However, traditional stores can keep their customers by selling goods like clothing, which buyers may want to see and try on before purchasing. The stores could also offer things that are difficult to ship. ”

Bill Martin, whose business helps stores learn about their customers, says, “Traditional stores offer a social experience that some people enjoy. There is still a lot of emotion in the buying decision that takes place, and you can't always get that on-line. It's a rather cold process. Traditional stores can provide goods for buyers more quickly than online stores. And some retailers are using websites to persuade people to visit their stores. ”

While online shopping worries some business owners, the only worry for delivery services like FedEx and UPS is keeping up with the number of packages. UPS Manager Dana Kline says her company is very busy at this time of year. UPS is so busy that it has filled 55,000 temporary worker positions during the holiday season.

小题1:According to Lynne Shaner, shopping online ________.

A.helps choose things she needs most

B.will replace traditional shopping soon

C.offer many benefits to customers

D.seldom provides a better selection小题2:What does the underlined phrase “opt for” in the second paragraph mean?

A.choose

B.sell

C.design

D.purchase小题3:Professor Ed McLaughlin thinks that _________.

A.online shopping has little effect on traditional stores

B.it is time for store owners to be anxious about their business

C.traditional stores can do nothing to stop challenges from online shopping

D.traditional stores should sell more things that are difficult to ship小题4:What can we know from the fourth paragraph?

A.Online sales fail to offer customers sense of emotion.

B.Customers enjoy social experience when shopping online.

C.Traditional stores can help customers decide what to buy.

D.Customers can buy goods more quickly after visiting websites.小题5:From the passage we can infer _______.

A.UPS has filled more worker positions than FedEx

B.business owners are concerned about delivery services

C.FedEx is keeping up with UPS on the number of packages

D.delivery services are facing more and more pressure from online sales

问答题 简答题