第1题:
数据库SQL语言中,AGE IN(15,35)短语的正确含义是(14)。
A.AGE=15AND AGE=35
B.AGE=15 OR AGE=35
C.AGE<=35 AND AGE>=15
D.AGE<35 AND AGE>15
第2题:
如果学生表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<30))
下面的SQL语句中可以正确执行的是
A.INSERT INTO STUDENT(SNO,SEX,AGE)VALUES (“S9”,“男”,17)
B.INSERT INTO STUDENT(SN,SEX,AGE)VALUES (“李安琦”,“男”,20)
C.INSERT INTO STUDENT(SEX,AGE)VALUES (“男”,20)
D.INSERT INTO STUDENT(SNO,SN)VALUES (“S9”,“安琦”,16)
第3题:
使用SQL语句将学生表S中年龄(AGE)大于30岁的记录删除,正确的命令是( )。
A.DELETE FOR AGE>30
B.DELETE FROM S WHERE AGE>30
C.DELETE S FOR AGE>30
D.DELETE S WHERE AGE>30
第4题:
Given the following query:SELECT last_name, first_name, age, hire_date FROM employee WHERE age >40Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?()
A.SORT BY age ASC, last_name
B.SORT BY age DESC, last_name
C.ORDER BY age DESC, last_name
D.ORDER BY age ASC, last_name
第5题:
在Visual FoxPro中,使用SQL命令将学生表STUDENT中的学生年龄AGE字段的值增加1岁,应该的使用命令是( )。
A. REPLACE AGE WITH AGE+1
B. MODIFY STUDENT SET AGE=AGE+1
C. ALTER STUDENT SET AGE WITH AGE+1
D. UPDATE STUDENT SET AGE=AGE+1
第6题:
使用SQL语句将学生表S中年龄(AGE)大于30岁的记录删除,正确的命令是______。
A.DELETE FOR AGE>30
B.DELETE FROM S WHERE AGE>30
C.DELETE S FOR AGE>30
D.DELETE S WHERE AGE>30
第7题:
对于学生信息表STUDENT(SNO, SNAME,SEX,AGE,DEPT)(STUDENT由学号SNO、姓名SNAME、性别SEX、年龄AGE、所在系DEPT 5个属性组成,其中SNO为主码),求年龄20~23岁之间的学生姓名和年龄,正确的语句是( )。A.SELECT SNAME,AGE FROM STUDENT WHERE AGE>20 AND AGE<23B. SELECT*FROM STUDENT WHERE AGE BETWEEN 20 AND 23C.SELECT SNAME,AGE FROM STUDENT WHERE AGE BETWEEN 20 AND 23D.以上均不正确
第8题:
使用SQL语句将学生表S中年龄(AGE)大于30岁的记录删除,正确的命令是A)DELETE FOR AGE>30 B)DELETE FROM S WHERE AGE>30C)DELETE S FOR AGE>30 D)DELETE S WHERE AGE>30
第9题:
如果学生表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<30 ))下面的SQL语句中可以正确执行的是A)INSERT INTO STUDENT(SNO,SEX,AGE)VALUES("S9","男",17)B)INSERT INTO STUDENT(SN,SEX,AGE)VALUES("李安琦","男",20)C)INSERT INTO STUDENT(SEX,AGE)VALUES("男",20)D)INSERT INTO STUDENT(SNO,SN) VALUES("S9","安琦",16)
第10题:
与WHERE AGE BETWEEN 18 AND 23完全等价的是( )。
A.WHERE AGE>18AND AGE
B.WHERE AGE>=18AND AGE
C.WHERE AGE>18AND AGE
D.WHERE AGE>=18AND AGE