若要在STUDENT表中增加一个宽度为2的“性别”字段，应使用的SQL命令为（）。 A: ALTER TABLE STUDENT ADD 性别CHAR(2) B: ALTER TABLE STUDENT ADD 性别 WITH CHAR(2) C: INSERT TABLE STUDENT ADD 性别 CHAR(2) D: INSERT  STUDENT  ALTER ADD 性别  WITH CHAR(2)

打开表并设置当前有效索引(相关索引已建立)的正确命令是 A: ORDER student IN 2 INDEX 学号 B: USE student IN 2 0RDER 学号 C: INDEX 学号 ORDER student D: USE student IN 2

下面选项中，查询student表中id值不在2和5之间的SQL语句是（ ）。 A: SELECT * FROM `student` WHERE `id`!=2,3,4,5 B: SELECT * FROM `student` WHERE `id` NOT BETWEEN 5 AND 2 C: SELECT * FROM `student` WHERE `id` NOT BETWEEN 2 AND 5 D: SELECT * FROM `student` WHERE `id` NOT IN 2,3,4,5

使用SQL语句从表STUDENT中查询所有姓王的同学的信息，正确的命令是： A: SELECT*FROM STUDENT WHERE LEFT(姓名,2)="王" B: SELECT*FROM STUDENT WHERE RIGHT(姓名,2)="王" C: SELECT*FROM STUDENT WHERE TRIM(姓名,2)="王" D: SELECT*FROM STUDENT WHERE STR(姓名,2)="王"

下面选项中,查询student表中id值不在2和5之间的学生的SQL语句是 A: SELECT * FROM student where id!=2,3,4,5; B: SELECT * FROM student where id not between 5 and 2; C: SELECT * FROM student where id not between 2 and 5; D: SELECT * FROM student where id not in 2,3,4,5;

Read Passage 2 and judge: The ... student in America.

下面选项中,查询student表中id值不在2和5之间的学生,其中正确的SQL语句是() A: SELECT * FROM student where id!=2,3,4,5; B: SELECT * FROM student where id not between 5 and 2; C: SELECT * FROM student where id not between 2 and 5; D: SELECT * FROM student where id not in 2,3,4,5;

Jack is a student and studies at the No. 2 Middle School. _____.

20.以下为非法用户标识符的是( )。 ( A ) ( B ) (C) ( D )， A: student2 B: 2student C: student_2 D: _student2

若用如下SQL语句创建一个student表： create table student ( id char (4) not null, name char (8)　not null, sex char (2), age smallint (2) ) 可以插入到student表中的是（　　）。