SQLserver复习题库题目与答案
您的姓名： [填空题] *
_________________________________
1. ()可以同一个表的不同字段进行联接。(选一项) * [单选题] * A、内联接
B、自联接(正确答案) C、外联接 D、左联接
2. 在SQL Server数据库中,UNIQUE约束与PRIMARY KEY约束之间最主要的区别是()(选一项) * [单选题] *
A、UNIQUE约束要求数据库中至少存在一行数据,因此必须在创建数据库表之后才能创建,而PRIMARY KEY约束无此限制
B、UNIQUE约束允许有空值,而PRIMARY KEY约束不允许有空值
C、创建UNIQUE约束后,该数据行允许被更改,而PRIMARY KEY约束的数据行不允许更改
D、UNIQUE约束列不能创建外键,而PRIMARY KEY约束可以创建外键引用(正确答案)
3. 查询student表中的所有非空email信息, 以下语句正确的是()(选一项) * [单选题] *
A、Select email from student where email !=null B、Select email from student where email not is null C、Select email from student where email <> null
D、Select email from student where email is not null(正确答案)
4. SQL语句:select * from students where SNO like '010[^0]%[A,B,C]%',可能会查询出的SNO是( )(选两项) * * A、01053090A(正确答案) B、01003090A01 C、01053090 D、0101A01(正确答案)
5. 查找 student表中所有电话号码(列名:telephone)的第一位为8或6,第三位为0的电话号码()(‘[86]_0%’等同于'[8,6]_0%')(选一项) * [单选题] *
A、SELECT telephone FROM student WHERE telephone LIKE '[86]%0*' B、SELECT telephone FROM student WHERE telephone LIKE '(8,6)*0%' C、SELECT telephone FROM student WHERE telephone LIKE '[8,6]_0*'
D、SELECT telephone FROM student WHERE telephone LIKE '[86]_0%'(正确答案)
6. 查找authors表中的所有电话号码的首位为4,第二位为0或1的电话号码()(选一项) * [单选题] *
A、SELECT phone FROM authors WHERE phone LIKE '4[1,0]%'(正确答案) B、SELECT phone FROM authors WHERE phone in '4[^10]%' C、SELECT phone FROM authors WHERE phone LIKE '4_[1,0]%' D、SELECT phone FROM authors WHERE phone between '41%' and '40%'
7. 查找 student表中所有电话号码(列名:telephone)的第一位为8或6,第三位为0的电话号码()(选一项) * [单选题] *
A、SELECT telephone FROM student WHERE telephone LIKE '[86]%0*' B、SELECT telephone FROM student WHERE telephone LIKE '(8,6)*0%' C、SELECT telephone FROM student WHERE telephone LIKE '[8,6]_0*'
D、SELECT telephone FROM student WHERE telephone LIKE '[86]_0%'(正确答案)
8. 成绩表grade中字段score代表分数,以下( )语句返回成绩表中的最低分。()(选两项) * *
A、select max(score) from grade
B、select top 1 score from grade order by score asc(正确答案) C、Select min(score) from grade(正确答案) D、select top 1 score from grade order by score desc
9. 当你执行下面的SQL语句时,会发生()(选一项) * [单选题] *
SELECT au_id, title_id,sum(royaltyper) FROM titleauthor GROUP BY title_id, au_id ORDER BY title_id, au_id A、该语句会失败
B、在结果集中,对每一个不同的au_id的值和title_id的值的组合都会有一行(正确答案)
C、在结果集中,每一行中au_id的值都不会相同 D、在结果集中,每一行中title_id的值都不会相同
10. 从货物订单数据表(order)中查询出其中订单金额(order_price)在1000和5000之间的订单的详细信息,并按照订单金额(order_price)升序排列。正确的语句是()(选一项) * [单选题] *
A、select * from order where order_price between 1000 and 5000 order by order_price ASC(正确答案)
B、select * from order where order_price between 1000 and 5000 order by order_price DESC
C、select * from order where 1000 11. 分析以下SQL语句: SELECT DISTINCT 产品.产品名称，产品.单价 FROM 产品 WHERE（（（产品.单价）>(SELECT AVG([单价]) FROM 产品)））
SQLserver复习题库题目与答案
