题目1单选题
设有学生表student(sno,sname,sage,smajon),各字段含义分别为学号、姓名、年龄、专业;学生选课表score(sno,cname,grade),各字段含义学生学号、课程名、成绩.若要检索"信息管理"专业、选修了课程DB的学生姓名及成绩,如下能实现该检索要求的语句是( )A. SELECT s.no,s.name,grade FROM student as s,score as sc WHERE s.sno=sc.sno AND s.smajor='信息管理' AND cname='DB'B. SELECT s.sno,sname,grade FROM student as s WHERE s.sno=sc.sno AND s.smajor='借息管理' AND cname='DB'C. SELECT s.sno,sname,grade FROM student as s,score as sc WHERE s.smajor='信息管理' AND cname='DB'D. SELECT s.sno,sname,grade FROM student as s WHERE smajor='信息管理' AND cname='DB'
题目6单选题
把对Student表和Course表的全部操作权授予用户Userl和User2的语句是( )A. GRANT All ON Student, Course TO User1, User2B. GRANT Student,Course ON All TO User1, User2C. GRANT All TO User1,User2 ON Student, CourseD. GRANT All TO Student,Course ON User1, User2
题目7单选题
若用如下的SQL语句创建了一个表SC: CREATE TABLE SC (S# CHAR(6) NOT NULL,C# CHAR(3) NOT NULL,SCORE INTEGER,NOTE CHAR(20));向SC表插入如下行时,( )行可以被插入A. ('201009','111',60,必修)B. ('201132',NULL,86,' ')C. (NULL,'103',80,'选修')D. ('200823','101',NULL,NULL)