数据库中有一张表名称为Student,有列Name,Age,IDCard,Sex。要求写SQL语句查询出表中所有的数据,下列哪个SQL语句是正确的()
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、Select* From Student
B、Select Name From Student
C、Select Name,Age,IDCard From Student
D、Select Name,Age,IDCard,Sex From Student
A、Select Count(1)From Student B、Select Sum(*)From Student C、Selec tAvg(*)From Student D、Select Count(*)From Student
A、Delete Student‘20140001’ B、Delete Student“20140001” C、Delete Student Where Number=‘20140001’" D、Delete From Student Where Number=”20140001”"
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"
A、Select*FromStudentWhereSex=’男’ B、Select*FromStudentWhereSex<>’女’ C、Select*FromStudentWhereSexLike’男’ D、Select*FromStudentWhereSexIn’男’
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<>’男’
A、Select* From Student Where ZZMM=’党员’And ZZMM=’团员’ B、Select* From Student Where ZZMM=’党员’Or ZZMM=’团员’ C、Select* From Student Where ZZMM="党员"OrZ ZMM="团员" D、Select* From Student Where ZZMM IN(’党员’,‘团员’)
A、表是表空间的基础,表空间是所有相关表所占空间的总和 B、表空间是由一至多个数据文件构成的,每个表占用一个数据文件 C、一张表可以占用多个表空间,一个表空间也可以容纳多张表 D、一个表空间可以容纳多张表,但一张表只能归属于一个表空间 E、一个空数据库是不占用表空间的