问题 单项选择题

(15)~(27)题使用的数据如下:
当前盘当前目录下有数据库db_ stock,其中有数据库表stock.. dbf,该数据库表的内容是:
股票代码 股票名称 单价 交易所
600600 青岛啤酒 7.48 上海
600601 方正科技 15.20 上海
600602 广电电子 10.40 上海
600603 兴业房产 12.76 上海
600604 二纺机 9.96 上海
600605 轻工机械 14.59 上海
000001 深发展 7.48 深圳
000002 深万科 12.50 深圳

执行如下SQL 语句后:
SELECT DISTINCT 单价 FROM stock;
WHERE 单价=(SELECT min(单价)FROM stock)INTO DBF stock_ x
表stock_ x中的记录个数是( )。

A.1

B.2

C.3

D.4

答案

参考答案:A

解析: 该SQL语句具体的执行过程是:首先从数据表db_ stock中找出所有记录中单价字段值最低的记录,并且记住该记录的单价字段值。然后再查找数据表db_ stock,从中查出单价字段等于该最低单价的记录,同时用DISTINCT进行限定,即选出的记录是不允许重复的,最后将结果存放到表 stock_ x中,因此可以看小,stock_ x表中的记录个数为1。

单项选择题

"I delight in Buckingham Palace", said Queen Victoria, when she moved in three weeks after ascending to the throne. Today the 40-acre secluded garden contains specimen shrubs, trees and a large lake. Eight to nine thousand people visit it during the annual garden parties.
It took George Ⅳ, on becoming King in 1820, and John Nash, Surveyor-general to GeorgeⅣ when he was Prince Regent, many years to turn the house into a sumptuous palace. Nash demolished the North and South wings and rebuilt them. He constructed Marble Arch as a grand entrance to the enlarged courtyard. As work continued, Nash let his costs run away with him, and Parliament complained. Joseph Hume, an English politician and reformer fighting for financial retrenchment, said, "The Crown of England does not require such splendour. Foreign countries might indulge in frippery, but England ought to pride herself on her plainness and simplicity." Nevertheless, elegance reigned.
Queen Victoria was crowned in 1837. When she moved in, Buckingham Palace became, for the first time, the official London residence of Britain’s sovereigns. There wasn’t a room large enough for grand entertainments, so in 1853 — 1855, Queen Victoria ordered the Ballroom built. 122 feet long, 60 feet wide and 45 feet high, it is, today, used for many events such as the State Banquet, the Diplomatic Reception, and memorial concerts. This is the site of Investitures, where the Queen (who was crowned in 1952) presents the recipients of British honours with their awards. During World War Ⅱ, a chapel, converted by Queen Victoria from Nash’s conservatory, was bombed. Prince Philip oversaw its rebuilding as the Queen’s Gallery, home to a rotating collection of art from the Royal Collection. The Gallery, currently in the process of renovation, will reopen in 2002 for the Queen’s Golden Jubilee.
More than 600 rooms, including 52 Royal and guest bedrooms, 188 staff bedrooms, 92 offices and 78 bathrooms comprise the castle’s assets. But the "room" best known around the world is the Balcony where the Royal family’ gathers on celebratory and solemn occasions to be seen by their subjects.
The Palace is more than a home for the Royals. It is the official administrative headquarters of the monarchy and contains the Offices of their staff. It is the place where all Royal ceremonies and official banquets are held. Government ministers, top civil servants and heads of state visit to carry out their duties. It brings a whole new meaning to the phrase "working from home".

According to the passage, which is the most famous place in Buckingham Palace

A.(A) The Ballroom.

B.(B) The Queen’s Gallery.

C.(C) Marble Arch.

D.(D) The Balcony

单项选择题