超星 - 第04章数据操作语句-测验1

单选题

分组查询的关键字是( )

A. order by
B. from
C. group by
D. group

单选题

where子句、group by子句、having子句在select语句中的顺序是()

A. having子句、group by子句、where子句
B. group by子句、having子句、where子句
C. group by子句、where子句、having子句
D. where子句、group by子句、having子句

查看答案

单选题

分组查询中,去掉不需要的组用( )关键字。

A. having
B. where
C. group by
D. from

查看答案

单选题

为用户表添加姓名字段的语句是()

A. alter table user add name varchar(40);
B. alter table user drop name;
C. alter table user rename oldname to newname;
D. alter table user alter name varchar(50);

查看答案

单选题

为用户表删除姓名字段的语句是()

A. alter table user add name varchar(40);
B. alter table user drop name;
C. alter table user rename oldname to newname;
D. alter table user alter name varchar(50);

查看答案

单选题

查询数据库表中的记录,用( )语句

A. select语句
B. update语句
C. delete语句
D. insert语句

查看答案

单选题

下列 SQL 语句select * from student where sno = '05880101'union select * from student where sno = '05880102'与此查询语句等价的选项是( )。

A. select * from student where sno= '05880101' and sno= '05880102'
B. select * from student where sno= '05880101' or sno= '05880102'
C. select * from student where sno= '05880101'
D. select * from student where sno= '05880102'

查看答案

单选题