SQL语言的命令：“SELECT-FROM-WHERE”的基本功能是（）

A、DELETE B、DROP C、CLEAR D、REMORVE

A . DELETE B . DROP C . CLEAR D . REMOVE

A、DELETE  TRIGGER B、DROP  TRIGGER C、REMOVE  TRIGGER D、DISABLE  TRIGGER

A . 3COMMIT属于数据控制语言语句 B . 数据定义语言用来建立数据库中各种数据对象 C . UPDATE是修改已经存在于表中的数据的语句 D . GRANT是收回权限的语句

A . DELETE B . DVROP C . CLEAR D . RDEMOVE

A . DELETE B . DROP C . CLEAR D . REMOVE

A、DELETE B、DROP C、CLEAR D、REMORE

A . SORT BY B . ORDER BY C . GROUP BY D . WHERE

A.CREATE TRIGGER/images/work/phone/right_v1.png B.CREATE RULE C.CREATE DURE D.CREATE FILE

A．DESTROY TABLE B．REMOVE TABLE C．DELETE TABLE D．DROP TABLE

A．CREATE PROCEDURE B．CREATE RULE C．CREATE VIEW D．CREATE FILE

A．DELETE TRIGGER B．DROP TRIGGER C．REMOVE TRIGGER D．DISABLE TRIGGER

A．DELETETABLE B．DROPTABLE C．REMOVETABLE D．DISABLETABLE

A．DELETE B．SELECT C．INSERT D．UPDATE

A．SELECT s.学号,姓名,平均成绩 FROM s JOIN sc ON s.学号 = sc.学号 GROUP BY s.学号 HANVING COUNT(*)＞=5 ORDER BY 平均成绩 DESC B．SELECT 学号,姓名,AVG(成绩) 平均成绩 FROM s JOIN sc ON s.学号 = sc.学号 WHERE COUNT(*)＞=5 GROUP BY 学号 ORDER BY 平均成绩 DESC C．SELECT s.学号,姓名,AVG(成绩) 平均成绩 FROM s CROSS JOIN sc WHERE s.学号 = sc.学号 AND COUNT(*) ＞= 5 GROUP BY s.学号 ORDER BY 平均成绩 DESC D．SELECT s.学号,姓名,AVG(成绩) 平均成绩 FROM s JOIN sc ON s.学号 = sc.学号 GROUP BY s.学号,姓名 HANV

A．数据查询 B．数据定义 C．数据操纵 D．数据控制

是 否

A．INSERTINTO B．CREATEVIEW C．UPDATE D．DROPTABLE