对
错
第1题:
删除视图STUDENT的命令是( )。
A.DELETE STUDENT VIEW
B.DELETE STUDETN
C.DROP STUDENT VIEW
D.DROP VIEW STUDENT
第2题:
Jane is a student. Her sister is not a student.(连成一句话)
Jane is a student________ her sister________ a student.
第3题:
A、student has complained of
B、student have complained of
C、student has complained
D、student have complained
第4题:
A. ALTER TABLE student_grades ADD FOREIGN KEY (student_id) REFERENCES students (student_id);
B. ALTER TABLE student_grades ADD CONSTRAINT NAME = student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);
C. ALTER TABLE student_grades ADD CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);
D. ALTER TABLE student grades ADD NAMED CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);
E. ALTER TABLE student grades ADD NAME student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);
第5题:
由于学号(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
第6题:
VBA中打开“student”表的语句是( )。
A)Docmd.OpenForm”student”
B)Docmd.OpenQuery”student”
C)Docmd.OpenTable”student”
D)Docmd.Openreport”student”
第7题:
创建一个名为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.学号
第8题:
A. switched off
B. switched on
C. switched on to
D. switched to
第9题:
The STUDENT_GRADES table has these columns:STUDENT_ID NUMBER(12)SEMESTER_END DATEGPA NUMBER(4,3)The registrar requested a report listing the students‘ grade point averages (GPA) sorted from highest grade point average to lowest.Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar? ()
A. SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;
B. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;
C. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;
D. SELECT student_id, gpa FROM student_grades ORDER BY gpa;
E. SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;
F. SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;
第10题:
A.$student->$getName();
B.$student->name;
C.$student->$name;
D.$student.getName();