下面选项中，可以清空表数据的SQL语句是

A . Select* From Student Where Sex=’男’ B . Select* From Student Where Number NotIn（Select Number From Student Where Sex<>=’男’） C . Select* From Student Where NumberIn（Select Numbe rFrom Student Where Sex=’男’） D . Select* From Student Where Sex<>’男&rsquo

A . Delete Student‘20140001’ B . Delete Student“20140001” C . Delete Student Where Number=‘20140001’" D . Delete From Student Where Number=”20140001”&quot

A . Select* From Student Where Age>=20 ANDAge>=30 B . Select* From Student Where Age>=20 ANDAge<=30 C . Select* From Student Where Age BET WENN 20AND30 D . Select* From Student Where Age>=20&&Age>=30&quot

A . ALTER TABLE B . CREATE TABLE C . CREATE DATEBASE D . ALTER VIEW

A . Select* From Student B . Select Name From Student C . Select Name，Age，IDCard From Student D . Select Name，Age，IDCard，Sex From Student

A . ALTER B . SELECT C . UPDATE D . INSERT

A .

A、SELECT productname，price from products order by price ASC B、SELECT productname，price from products order by price DESC C、SELECT productname，price from products order by price D、SELECT productname and price from products order by price DESC

A . Select Count（1）From Student B . Select Sum（*）From Student C . Selec tAvg（*）From Student D . Select Count（*）From Student

A . Select*FromStudentWhereSex=’男’ B . Select*FromStudentWhereSex<>’女’ C . Select*FromStudentWhereSexLike’男’ D . Select*FromStudentWhereSexIn’男&rsquo

A．select B．join C．create D．format

A．SELECT sno,sname FROM student WHERE sname= %t_; B．SELECT sno,sname FROM student WHERE sname LIKE %t_; C．SELECT sno,sname FROM student WHERE sname LIKE _t%; D．SELECT sno,sname FROM student WHERE sname=_t%;

<img src='https://img2.soutiyun.com/ask/uploadfile/2511001-2514000/d700e1ec7c8ca71460f029b1430eafef.gif' />

A．DROP TABLE B．TRUNCATE TABLE C．DELETE D．CLEAR

A．SELECT*FROM员工WHERE姓名LIKE"曾*" B．SELECT*FROM员工WHERE姓名LIKE"曾？" C．SELECT*FROM员工WHERE姓名LIKE"*曾*" D．SELECT*FROM员工WHERE姓名LIKE"？曾？"

A．每次只能更新一行数据 B．表中的数据行可以全部被更新 C．如果没有数据项被更新,将提示错误信息 D．更新数据时,不能带有WHERE条件子句

A、CREATETABLE B、GRANT C、CREATEVIEW D、DROPVIEW

A）% B）* C） D）_

A．updatedemo1set B．GRANTupdateondemo 1.*to'user1'@'localhost' C．GRANTupdateondemo1to'user1'@'localhost' D．GRANTupdateondemo1.demo1to'user1'@'localhost'