一个信息表student,要求它由学号sno,姓名sname,性别sex,年龄age,4个属性组成。现在对这个现有的表
A.AITER TABLE student ADD cometime DATE NOT NULL;
B.ALTER TABLE student ADD cometime DATE;
C.ALTER TABLE student DROP cometime DATE NOT NULL;
D.ALTER TABLE student MODIPY cometime DATE;
A.AITER TABLE student ADD cometime DATE NOT NULL;
B.ALTER TABLE student ADD cometime DATE;
C.ALTER TABLE student DROP cometime DATE NOT NULL;
D.ALTER TABLE student MODIPY cometime DATE;
A.ALTER TABLE student ADD cometime DATE NOT NULL;
B.ALTER TABLE student ADD cometime DATE;
C.ALTER TABLE student DROP cometime DATE NOT NULL;
D.ALTER TABLE student MODIFY cometime DATE;
A.ALTER TABLE student ADD cometime DATE NOT NULL;
B.ALTER TABLE student ADD cometime DATE;
C.ALTER TABLE student DROP cometime DATE NOT NULL:
D.ALTER TABLE student MODIFY cometime DATE;
A.ALTER TABLE student ADD cometime DATE NOT NULL;
B.ALTER TABLE sudent ADD cometime DATE;
C.AlTER TABLE student DROP cometime DATE NOT NULL;
D.ALTER TABLE sudent MODIFY cometime DATE;
A.CREATE TABLE student (sno char(5)NOT NULL sname char(8)NOT NULL sex char(1) age int);
B.CREATE TABLE student (sno char(5)NOT NULL sname char(8)NOT NULL sex char(1) age int);
C.CREATE TABLE (sno char(5)NOT NULL UNIQUE sname char(8)NOT NULL sex char(1) age int);
D.CREATE TABLE student (sno char(5)NOT NULL UNIQUE sname char(8)NOT NULL sex char(1) age int);
A.CREATE TABLE student (sno char(5)NOT NULL sname char(8)NOT NULL sex char age int);
B.CREATE TABLE student (sno char(5)NOT NULL UNIQUE sname char(8) sex char age int);
C.CREATE TABLE (sno char(5)NOT NULL UNIQUE sname char(8)NOT NULL sex char age int);
D.CREATE TABLE student (sno char(5)NOT NULL UNIQUE sname char(8)NOT NULL sex char age int);
A.CREATE TABLE student(sno char(5) NOT NULL sname char(8) NOT NULL sex char(1) age int);
B.CREATE TABLE student (sno char(5) NOT NULL UNIQUE sname char(8) sex char(1) age int);
C.CREATE TABLE (sno char(5) NOT NULL UNIQUE sname char(8) NOT NULL sex char(1) age int);
D.CREATE TABLE student (sno char(5) NOT NULL UNIQUE sname char(8) NOT NULL sex char(1) age int);
A.CREATE TABLE student (sno char(5) NOT NULL sname char(8) NOT NULL sex char(1) age int);
B.CREATE TABLE atudent (sno char(5) NOT NULL UNIQUE sname char(8) sexchar(1) age int);
C.CREATE TABLE (sno char(5) NOT NULL UNIQUE sname char(8) NOT NULL sex char(1) age iht);
D.CREATE TABLE student (sno char(5) NOT NULL UNIQUE shame char(8) NOT NULL sex char(1) age int);
A.CREATE TABLE student (sno char(5)NOT NUIL sname char(8)NOT NULL sex char(1) age int);
B.CREATE TABLE student (sno char(5)NOT NULL UNIQUE sname char(8) Sex char(1) age int);
C.CREATE TABLE (sno char(5)NOT NULL UNIQUE sname char(8)NOT NULL sex char(1) age int);
D.CREATE TABLE student (sno char(5)NOT NULL UNIQUE sname char(8)NOT NULL Sex char(1) age int);
A.CREATE TABLE student (sno char(5) NOT NULL sname char(8) NOT NULL sex char(1) age int);
B.CREATE TABLE student (sno char(5) NOT NULL UNIQUE sname char(8) sex char(1) age int);
C.CREATE TABLE (sno char(5) NOT NULL UNIQUE sname char(8) NOT NULL sex char(1) age int);
D.CREATE TABLE student (sno char(5) NOT NULL UNIQUE sname char(8) NOT NULL sex char(1) age int);
对于学生信息表S(SNUMBER,SNAME,SEX,AGE,DEPT)(STUDENT 由学号 SNO,姓名SNAME,性别SEX,年龄AGE,所在系DEPT5个属性组成,其中SNUMBER为主码),求年龄20~23岁之间的学生姓名和年龄,正确的语句是()。
A.SELECT SNAME,AGE FROM S WHERE AGE>20 AND AGE<23
B.SELECT SNAME,AGE FROM S WHERE AGE BETWEEN 20 AND 23
C.SELECT *FROM S WHERE. AGE BETWEEN 20 AND 23
D.以上均不正确
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!