course表设计如下,查询‘数据结构‘课程的所有信息的正确SQL语句是()
A. select * from course where cname=’ 数据结构’
B. select * from scourse where cname=’ 数据结构’ ;
C. select * from course where cno= 数据结构
D. select all from course where cname=’ 数据结构’ ;
查看答案
student表设计如下,查询1994后出生的学生信息的正确SQL语句是()
A. select* from student where birth>’1994’;
B. select * from student where year( birth)>’1994’;
C. select * from student where year(birth,yy)>=’1994’;
D. select birth from studen where birth>’1994’;
scores表设计如下,查询每个学生的平均成绩的正确SQL语句是()
A. select avg(Score) as average from scores;
B. select Score as average from scores;
C. select cno , avg(Score) as average from scores group by sno
D. select sno , avg(Score) as average from scores group by sno
scores表设计如下,查询每门课程的平均成绩的正确SQL语句是()
A. select avg(Score) as average from scores;
B. select cno , Score as average from scores;
C. select cno , avg(Score) as average from scores group by cno
D. select Score as average from scores;
数据库创建后就可以创建表了,创建表可以用()等方法来创建。
A. 企业管理器
B. 查询分析器
C. OSQL
D. 企业管理器和CREATE TABLE语句