下面SQL语句中，用于删除student表中age小于20的记录的语句是 A: DELETE student where age<20; B: DELETE FROM student where age<20; C: DELETE FROM student set age<20; D: DELETE studentset age<20;
下面SQL语句中，用于删除student表中age小于20的记录的语句是 A: DELETE student where age<20; B: DELETE FROM student where age<20; C: DELETE FROM student set age<20; D: DELETE studentset age<20;
有学生信息表student，求年龄在20～22岁之间(含20岁和22岁)的学生姓名和年龄的SQL语句是：SELECT sname,age FROM student WHERE age（ ）。 A: >20 and age<22 B: BETWEEN 20 AND 22 C: >=20 and age<22 D: >20 and age<=22
有学生信息表student，求年龄在20～22岁之间(含20岁和22岁)的学生姓名和年龄的SQL语句是：SELECT sname,age FROM student WHERE age（ ）。 A: >20 and age<22 B: BETWEEN 20 AND 22 C: >=20 and age<22 D: >20 and age<=22
下面选项中，用于将表user中字段age值更新为55的SQL语句是 A: ALTER TABLE user set age=55; B: UPDATE user set age=55 where age=55; C: UPDATE user set age=55; D: UPDATE user set age=55 where age<=55;
下面选项中，用于将表user中字段age值更新为55的SQL语句是 A: ALTER TABLE user set age=55; B: UPDATE user set age=55 where age=55; C: UPDATE user set age=55; D: UPDATE user set age=55 where age<=55;
What is the best-corrected visual acuity to give a diagnosis of amblyopia? ( ) A: Age 3-5: <0.5 B: Age≥6:<0.7 C: Adult: <1.0 D: Interocular difference≥2 lines
What is the best-corrected visual acuity to give a diagnosis of amblyopia? ( ) A: Age 3-5: <0.5 B: Age≥6:<0.7 C: Adult: <1.0 D: Interocular difference≥2 lines
查询所有目前年龄不到18岁的学生的姓名、所在班级及年龄，正确的命令是（ ）。 A: SELECT StName, ClName，YEAR(GETDATE())-YEAR(birthdate) age FROM StInfo WHERE age<18 B: SELECT StName,ClName, YEAR(GETDATE())-YEAR(birthdate) FROM StInfo WHERE YEAR(birthdate)<18 C: SELECT StName, ClName, YEAR(GETDATE())-YEAR(birthdate) ageFROM StInfo WHERE YEAR(GETDATE())-YEAR(birthdate)<18 D: SELECT StName,ClName, YEAR(date())-YEAR(birthdate) FROM StInfo WHERE age<18
查询所有目前年龄不到18岁的学生的姓名、所在班级及年龄，正确的命令是（ ）。 A: SELECT StName, ClName，YEAR(GETDATE())-YEAR(birthdate) age FROM StInfo WHERE age<18 B: SELECT StName,ClName, YEAR(GETDATE())-YEAR(birthdate) FROM StInfo WHERE YEAR(birthdate)<18 C: SELECT StName, ClName, YEAR(GETDATE())-YEAR(birthdate) ageFROM StInfo WHERE YEAR(GETDATE())-YEAR(birthdate)<18 D: SELECT StName,ClName, YEAR(date())-YEAR(birthdate) FROM StInfo WHERE age<18
程序代码如下：age = 17if age < 18： print('未成年')程序执行完之后，会输出：
程序代码如下：age = 17if age < 18： print('未成年')程序执行完之后，会输出：
表达式“AGE BETWEEN 18 AND 24”等价于（ ）。 A: AGE>18 AND G<24 B: AGE>=18 AND G<24 C: AGE>18 AND G<=24 D: AGE>=18 AND AGE<=24
表达式“AGE BETWEEN 18 AND 24”等价于（ ）。 A: AGE>18 AND G<24 B: AGE>=18 AND G<24 C: AGE>18 AND G<=24 D: AGE>=18 AND AGE<=24
下面If语句统计满足职称（用字符串变量duty表示）为副教授或教授、且年龄（用整型变量age表示）小于40岁条件的人数，正确的语句是______。 A: If age < 40 And （duty = "教授" or duty = "副教授"） Then n = n + 1 B: If age < 40 And duty = "教授" or duty = "副教授" Then n = n + 1 C: If age < 40 And duty = "教授" or "副教授" Then n = n + 1 D: If age < 40 Or duty = "教授" And duty = "副教授" Then n = n + 1
下面If语句统计满足职称（用字符串变量duty表示）为副教授或教授、且年龄（用整型变量age表示）小于40岁条件的人数，正确的语句是______。 A: If age < 40 And （duty = "教授" or duty = "副教授"） Then n = n + 1 B: If age < 40 And duty = "教授" or duty = "副教授" Then n = n + 1 C: If age < 40 And duty = "教授" or "副教授" Then n = n + 1 D: If age < 40 Or duty = "教授" And duty = "副教授" Then n = n + 1
在学生信息表中，查询年龄在18岁到20岁的学生姓名和年龄，正确的SQL语句是（）。 A: select sn,agefrom swhere age between 18 and 20 B: select sn,agefrom swhere age>=18 and age<=20 C: select sn,agefrom swhere age>18 and age<20 D: select sn,agefrom swhere age>=18 or sAge<=20
在学生信息表中，查询年龄在18岁到20岁的学生姓名和年龄，正确的SQL语句是（）。 A: select sn,agefrom swhere age between 18 and 20 B: select sn,agefrom swhere age>=18 and age<=20 C: select sn,agefrom swhere age>18 and age<20 D: select sn,agefrom swhere age>=18 or sAge<=20
如果学生表STUDENT是使用下面的SQL语句创建的CREATE TABLE STUDENT( SNO varchar(4) PRIMARY KEY,SNAME varchar(8),SEX char(2),AGE int CHECK(AGE>15 AND AGE<30))则下面的语句中可以正确执行的是( )。 A: INSERT INTO STUDENT(SNO,SEX,AGE)values(‘S9’, ’男’, 17) B: INSERT INTO STUDENT(SNO,SEX,AGE)values(‘S9’, ‘男’, 14) C: INSERT INTO STUDENT(SNO,SEX,AGE)values(‘男’, 20) D: INSERT INTO STUDENT(SNO,SEX,AGE)values(‘S9’,‘安琦’, 16)
如果学生表STUDENT是使用下面的SQL语句创建的CREATE TABLE STUDENT( SNO varchar(4) PRIMARY KEY,SNAME varchar(8),SEX char(2),AGE int CHECK(AGE>15 AND AGE<30))则下面的语句中可以正确执行的是( )。 A: INSERT INTO STUDENT(SNO,SEX,AGE)values(‘S9’, ’男’, 17) B: INSERT INTO STUDENT(SNO,SEX,AGE)values(‘S9’, ‘男’, 14) C: INSERT INTO STUDENT(SNO,SEX,AGE)values(‘男’, 20) D: INSERT INTO STUDENT(SNO,SEX,AGE)values(‘S9’,‘安琦’, 16)