【单选题】You need to design a student registration database that contains several tables storing academic information. The STUDENTS table stores information about a student. The STUDENT_GRADES table stores inf...
【单选题】如果学生表STUDENT是使用下面的SQL语句创建的: CREATE TABLE STUDENT(SNO C(4)PRIMARY KEY NOT NULL. SN C(8), SEX C(2), AGE N(2)CHECK(AGE>15 AND AGE<25)) 下面的SQL语句中可以正确执行的是( )。
A.
INSERT INTO STUDENT(SN,SEX,AGE)VALUES(”王磊”,”男”,20)
B.
INSERT INTO STUDENT(SN0,SEX,AGE)VALUES(”S9”,”男”,17)
C.
INSERT INTO STUDENT(SEX,AGE)VALUES(”男”,20)
D.
INSERT INTO STUDENT(SN0,SN,AGE)VALUES(”S9”,”王磊”,14)
【简答题】如果学生表STUDENT是使用下面的SQL语句创建的CREATE TABLE STUDENT (SNO C (4) PRIMARY KEY NOT NULL , SN C (8) , C (2) , AGE N (2) CHECK (AGE>15 AND AGE<30 ))下面的SQL语句中可以正确执行的是A)INSERT INTO STUDENT(SNO,,AGE)VALUES('...