问题 单项选择题

第(37)~(38)题基于“学生-选课-课程”数据库中的3个关系:
S(S#,SNAME,SEX,AGE),
SC(S#,C#,GRADE),
C(C#, CNAME, TEACHER)

若要求查找姓名中第二个字为“阳”字的学生的学号和姓名,下列SQL语句中,( )
是正确的。
Ⅰ、SELECT S#,SNAME FROM S WHERE SNAME=’_阳%’
Ⅱ、SELECT S#,SNAME FRQM S WHERE SNAME LIKE’_阳%’
Ⅲ、SELECT S#,SNAME FROM S WHERE SNAME LIKE’%阳%’

A.只有Ⅰ

B.只有Ⅱ

C.只有Ⅲ

D.都正确

答案

参考答案:B

解析: 这是一个LIKE查询,LIKE谓语一般形式是:
列名LIKE字符串常数
这里,列名的数据类型必须是字符型。在字符串常数中字符的含意如下:
①字符_(下划线)表示可以和任意的单个字符匹配。
②字符%(百分号)表示可以和任意长的字符串匹配。
题意要求查找第二个字为“阳”的学生学号和姓名,所以查询条件应该是’_阳%’,所以B)选项是正确的。

选择题
单项选择题

Egyptian wine has an extensive history within the history of Egyptian civilization. Grapes were not (1) to the landscape of Egypt, rather the vines themselves are (2) to have been imported from the Phoenicians, (3) the actual origins remain in (4) . What is known, is that (5) the third millennium BC, Egyptian kings of the first (6) had extensive wine cellars, and wine was used extensively in the temple ceremonies. The main (7) of wine in Egypt, took place between the king, nobles, and the priests in temple ceremonies, and is (8) by numerous painted relief’s, and other (9) evidence. The vineyards of ancient Egypt, were quite different from the modern methods of wine making today. (10) viticulture ( or wine making), ceased to (11) an exclusively ceremonial purpose, the Egyptians began to experiment with simple structures for their vines to train on, (12) found a way to train their vines so they were easy low (13) bushes, and found ways for the soil to (14) more moisture for the vines. Egyptian wine making experiments included the use of different wine presses, adding heat to the must ( the grape juice ready for fermentation) (15) make the wine sweet, and differences in vat types and materials. The (16) finished product of wine, was poured through a cloth filter, and then into earthenware jars, (17) they would be sealed with natural tar and left to (18) . The Egyptians kept accurate records of their vintages, and (19) of their wines, each jar of wine was clearly (20) with it’s own vintage, and quality.

11()

A.act

B.serve

C.work

D.reach