数据库系统概论在线作业第2次3-4章.docx

您的本次作业分数为：97分单选题1.在SQL语言中授权的操作是通过（）语句实现的。A CREATE B REVOKE C GRANT D INSERT 正确答案:C单选题2.在SQL语言中回收权限的操作是通过（）语句实现的。A CREATE B REVOKE C GRANT D INSERT 正确答案:B单选题3.下列SQL语句命令，属于DDL语言的是（）。A SELECT B CREATE C GRANT D DELETE 正确答案:B单选题4.根据SQL标准，创建一个表，应该使用下面哪个语句？A CREATE TABLE B CREATE INDEX C CREATE VIEW D CREATE DATABASE 正确答案:A单选题5.根据SQL标准，删除一个表，应该使用下面哪个语句？A DELETE TABLE B DROP TABLE C DELETE VIEW D DROP DATABASE 正确答案:B单选题6.根据SQL标准，修改表的数据结构，下面哪种语句适用？A UPDATE B ALTER C CHANGE D SHIFT 正确答案:B单选题7.根据SQL标准，创建一个视图，应该使用下面哪个语句？A CREATE TABLE B CREATE INDEX C CREATE VIEW D CREATE DATABASE 正确答案:C单选题8.根据SQL标准，删除一个表中的记录，下面哪个语句适用？A DROP TABLE B DROP C DELETE D ERASE 正确答案:C单选题9.根据SQL标准，下面哪句语句能够找出年龄最小的同学？其中age为学生表student中的年龄字段，sno为学生的学号。A select max(age) from student B select sno from student where age = max(age) C select sno from student having age = max(age) D select sno from student a where a.age = (select min(b.age) from student b) 正确答案:D单选题10.根据SQL标准，要创建唯一索引该使用下面哪种语句？A CREATE UNIQUE INDEX B CREATE CLUSTER INDEX C CREATE ONLY INDEX D CREATE PRIMARY INDEX 正确答案:A单选题11.根据SQL标准，要修改表student中所有学生的年龄age，使之在原值基础上减一，下面哪个语句适用？A update student set age = 1 B update student set age = age - 1 C update age = age -1 from student D update from student where age = age -1 正确答案:B单选题12.根据SQL标准，要删除表student中所有数据，但不将表student的定义一起删除，下面哪个语句可以适用？A delete from student B delete all from student C delete * from student D drop table student 正确答案:A单选题13.根据SQL标准，要查询表student中平均年龄age小于21的所在系dept及其平均年龄值，下面哪条语句适用？A select dept,avg(age) from student where avg(age) 21 B select dept,avg(age) from student group by dept having avg(age) 21 C select dept,avg(age) from student having avg(age) 21 D select dept,avg(age) from student group by dept where avg(age) 21 正确答案:B单选题14.根据SQL标准，要查询表student中所有年龄age小于所有学生的平均年龄的记录，下面哪条语句适用？A select * from student where age avg(age) B select * from student having age avg(age) C select * from student a where a.age (select avg(b.age) from student b) D select * from student a where (select avg(b.a