“The student” in the sentence “The student liked the linguistic lecture.”,and “The linguistic lecture” in the sentence “The linguistic lecture liked the student.”belong to the same syntactic category.
第1题:
创建一个名为RS的视图,用来显示所有学生的学号,姓名和平均成绩,下面正确的语句是__
A SELECT STUDENT.学号,STUDENT.姓名,SKB.平均成绩 WHERE STUDENT.学号 = SKB.学号 GROUP BY STUDENT.学号 INTO CURSOR RS
B CREATE VIEW RS AS SELECT STUDENT.学号,STUDENT.姓名,SKB.平均成绩 WHERE STUDENT.学号 = SKB.学号 GROUP BY STUDENT. 学号
C SELECT STUDENT.学号,STUDENT.姓名,SKB 平均成绩 WHERE STUDENT.学号 = SKB.学号 GROUP BY STUDENT.学号 INTO CURSOR RS
D CREATE VIEW RS AS SELECT STUDENT.学号,STUDENT.姓名,AVG(SKB.成绩) AS 平均成绩 WHERE STUDENT.学号 = SKB.学 号 GROUP BY STUDENT.学号
第2题:
此题为判断题(对,错)。
第3题:
A. switched off
B. switched on
C. switched on to
D. switched to
第4题:
此题为判断题(对,错)。
第5题:
Reference relates linguistic forms to some other related linguistic forms.()
第6题:
要求选出学生中平均成绩最高的人的学号,姓名和平均分,下列语句中正确的是_____
A SELECT TOP 1 学号,姓名,平均分 FROM STUDENT,SKB.DBF ORDER BY 平均分
B SELECT TOP 1 STUDENT.学号,STUDENT.姓名,AVG(SKB.成绩) AS 平均分FROM STUDENT INNER JOIN SKB.DBF WHERE STUDENT. 学号=SKB.学号 GROUP BY STUDENT.学号 ORDER BY 3 DESC
C SELECT TOP 1 STUDENT.学号,STUDENT.姓名,AVG(SKB.成绩) AS 平均分FROM STUDENT INNER JOIN SKB.DBF ON STUDENT.学号=SKB.学号 GROUP BY STUDENT.学号 ORDER BY 3 DESC
D SELECT TOP 1 PERCENT STUDENT.学号,STUDENT.姓名,AVG(SKB.成绩) AS 平均分 FROM STUDENT INNER JOIN SKB.DBF ON STUDENT.学号=SKB.学号 GROUP BY STUDENT.学号 ORDER BY 3 DESC
第7题:
A、 historical reason and class reason
B、 historical reason and psychological reason
C、 class reason and psychological reason
D、 extra-linguistic factors and linguistic factors
第8题:
Jane is a student. Her sister is not a student.(连成一句话)
Jane is a student________ her sister________ a student.
第9题:
A the student
B liked
C anidea
D the linguistic lecture
第10题:
由于学号(SN)为00291的学生已毕业,欲在关系“Student”中删除该学生的所有信息,用元组关系演算语言实现应为(53)。
A.GET W(Student): Student. SN = 00291' DELETE W
B.GET W: Student. SN = 00291'in Student DELETE W
C.HOLD W(student): Student. SN = 00291' DELETE W
D.HOLD W: Student. SN = 00291'in Student DELETE W