更多"对于数据表:student(sno,sname,sex,age,gra"的相关试题:
[单项选择]对于数据表:student(sno,sname,sex,age,grade),查询学习成绩为空的学生的学号和姓名,下面语句正确的是_______。
A. SELECT sno,sname FROM student WHERE grade=NULL
B. SELECT sno,sname FROM student WHERE grade IS NULL
C. SELECT sno,age FROM student WHERE grade IS NULL
D. SELECT sno,age FROM student WHERE grade=NULL
[单项选择]对于学生信息表:student(sno,sname,sex,age,grade),查询学习成绩为空的学生的学号和姓名,下面语句正确的是
A. SELECT sno,sname FROM student WHERE grade=NULL
B. SELECT sno,sname FROM student WHERE grade IS NULL
C. SELECT sno,age FROM student WHERE grade IS NULL
D. SELECT sno,age FROM student WHERE grade=NULL
[单项选择]对于学生信息表:student(sno, sname, sex, age, dept),能够得到年龄在20岁于22岁之间的学生的姓名和学号的语句是
A. SELECT * FROM student WHERE age BETWEEN 20 AND 22
B. SELECT sname, sno FROM student WHERE age BETWEEN 20 AND 22
C. SELECT sname,sno FROM student WHERE age>=20
D. SELECT shame,sno FROM student WHERE age<=22
[单项选择]对于学生信息表:student(sno, sname, sex, age, dept),如果把学生“张明”的姓名改为“张岩”,则正确的语句是
[单项选择]建立一个学生信息表student,要求它由学号sno、姓名sname、性别sex、年龄age4个属性组成,其学号属性唯一,学号、姓名字段不能为空。下列语句正确的是
A. CREATE TABLE student (sno char(5) NOT NULL sname char(8) NOT NULL sex char(1) age in;
B. CREATE TABLE student (sno char(5) NOT NULL UNIQUE sname char(8) sex char(1) age in;
C. CREATE TABLE (sno char(5) NOT NULL UNIQUE sname char(8) NOT NULL sex char(1) age in;
D. CREATE TABLE student (sno char(5) NOT NULL UNIQUE sname char(8) NOT NULL sex char(1) age in;
[单项选择]建立一个学生信息表student,要求它由学号sno,姓名sname,性别sex,年龄age,4个属性组成,其学号属性惟一,学号、姓名字段不能为空。下列语句正确的是( )。