(31)到(35)题使用下列数据表。 “作者”表: 作者编号 姓名 所在城市

题型:单项选择题

问题:

(31)到(35)题使用下列数据表。
“作者”表:
作者编号 姓名 所在城市
1101张晓云 北京
1102李 丽 北京
1103袁熙林 上海
1104赵三立 广州
1105方德胜 上海
1106刘 清 北京
“图书”表:
图书编号 书名出版单位 价格作者编号页数
1101 计算机基础知识 经济科学出版社 32.80 1101 252
2202 会计基础知识 经济科学出版社 17.80 1105 215
1102 VB 9.0初级入门 人民邮电出版社 22.50 1102 264
1103 Word 2003基础知识 大地出版杜 19.80 1101 298
1105 VFP 6.0程序设计基础 大地出版社 38.50 1103 310
2201 中级会计财务知识 经济科学出版社 28.80 1106 245
1110 计算机网络基础 高等教育出版社 26.50 1101 258
11ll 计算机组成原理 北京大学出版社 31.20 1103 98
1112 数据库设计原理 高等教育出版杜 35.50 1101 330
1113 C语言程序设计 北京大学出版社 32.00 1102 326
1114 软件设计分析 高等教育出版社 34.50 1102 330
2203 信息系统分析理论 经济科学出版社 24.50 1102 235

求至少出版3本以上图书的作者姓名及数量,下列SQL语句正确的是( )。

A.SELECT 姓名,COUNT(*)AS 数量 FROM 图书,作者; HAVING COUNT(*)>=3

B.SELECT 姓名,COUNT(*)AS数量FROM图书,作者; WHERE 作者.作者编号=图书.作者编号; GROUP BY图书.作者编号HAVING COUNT(*)>=3

C.SELECT姓名,COUNT(*)AS数量FROM图书,作者; FOR作者.作者编号=图书.作者编号; WHERE图书.作者编号HAVING COUNT(*)>=3

D.SELECT姓名,COUNT(*)AS数量FROM图书,作者; WHERE作者.作者编号=图书.作者编号; GROUP BY图书.作者编号SET COUNT(*)>=3

考点:计算机等级考试VISUALFOXPRO二级VISUALFOXPRO笔试317
题型:单项选择题

集装箱提单的背面条款,除传统海运提单具有的条款外,还包括为适应集装箱运输需要而修改或增列的条款,主要条款有()、承运人的运价本、运费与留置权条款、索赔与诉讼。

A.集装箱运输下的货物

B.集装箱运输下承运人的责任期限

C.集装箱运输下承运人的赔偿责任限制

D.制约托运人的责任条款

E.危险品运输条款

题型:单项选择题

The Fifth China International Fair for Investment and Trade is expected to expand the country’s economic relations with the international community when it opens on September 9. The four-day fair will be held in the Economic Zone of Xiamen, a coastal city in East China’s Fujian province. Compared with the previous four fairs held annually since 1997, this year’s fair will provide more detailed information and better services for the participants, according to Xi Jinping, governor of the Fujian province and director of the organizing committee of the fair.

A series of high-level forums will be held on international investment and China’s entry into the World Trade Organization. Since 1997, Xiamen has successfully hosted four sessions of the China International Fair for Investment and Trade, drawing global attention. Xiamen will redouble its efforts to offer better services for all its guests and friends attending the fair, according to ZhuYayan, the mayor. Altogether 9,141 overseas-funded projects have been negotiated at the past four fairs, with a combined overseas investment of US $ 48.3 billion.

Altogether 1,838 projects using foreign investment were negotiated with a total overseas investment of US $ 9,47 billion. The 1,261 contracts signed at the fourth fair registered a combined pledged overseas investment of US $ 5 billion. The total export and import volume reached US $ 786 million.

1. What is the best title for this passage?

A. The Fifth Fair Will Be Held.                 B. The Fair is Famous.

C. Fairs Attract the World Wide Attention. D. Xiamen is a Trade Zone.

2. How many fingers are there in the logo of the China Fair International Investment and Trade?

A. One.                B. Two.                C. Three.              D. Four.

3. Why is the golden key to success designed as the logo of CFIIT?

A. Because the fair will attract overseas investment to China.

B. Because it is a key to our home.

C. Because it is just like a key.

D. Because the fair is held on August 9.

5. What is the average of the overseas investment on one project in the past four fairs?

A. 0.00380 billion.               B. 0.00529 billion.

C. 0.00513 billion.               D. 0.00397 billion.

题型:单项选择题

“滞胀”理论不符合下列谁的观点?()

A.货币主义

B.凯恩斯主义

C.理性预期学派

D.供应学派

题型:单项选择题

肾不纳气的临床表现为()

A.腰膝酸软,小便频数而清

B.腰膝酸软,呼多吸少

C.腰膝酸软,眩晕耳鸣

D.腰膝酸软,五更泄泻

E.腰膝酸软,发脱齿摇

题型:单项选择题

根据《医疗事故处理条例》,患者一方向卫生行政部门提出医疗事故争议处理申请的期限为自知道或应当知道发生人身损害之日起()

A.1个月

B.3个月

C.半年

D.1年

E.2年

更多题库