若有以下定义，则对变量student1中“生日”的正确赋值方式是（ ）。 struct student { int num; char name[20], sex; struct { int year, month, day; } birthday; } ; struct student student1;

9.若有以下定义，则对变量student1中“生日”的正确赋值方式是 struct student { int num; char name[20], sex; struct { int year, month, day; } birthday; } ; struct student student1;

若有以下定义，则对变量student1中“生日”的正确赋值方式是（ ）。struct student{ int num; char name[20], sex; struct { int year, month, day; } birthday;} ; struct student student1; A: student1.birthday.year = 2003;student1.birthday.month = 5;student1.birthday.day = 1; B: year = 2003;month = 5;day = 1; C: birthday.year = 2003;birthday.month = 5;birthday.day = 1; D: student1.year = 2003;student1.month = 5;student1.day = 1;

为表STUDENT1在XM列上创建非聚集索引SS2，SQL语句应为______ A: CREATE VIEW SS2 ON STUDENT1 (XM) B: CREATE INDEX SS2 ON STUDENT1 (XM) C: CREATE TABLE SS2 ON STUDENT1 (XM) D: CREATE DATABASE SS2 ON STUDENT1 (XM)

若STUDENTstudent1，student2；(student1，student2为结构体变量)为正确定义，那么在此之前应做()定义。 A: struct{charname[20]；intnum；}STUDENT； B: structSTUDENT{charname[20]；intnum；}； C: typedefstruct{charname[20]；intnum；}STUDENT； D: typedefstructSTUDENT{charname[20]；intnum；}；

删除student表中id为1的记录（） A: TRUNCATE FROM student where id=1; B: DELETE student where id=1; C: DELETE FROM student where id=1; D: DELETE INTO student where id=1;

在SQL SRVER中，查询STUDENT1表中GJ大于等于300的男生，则SQL语句应为______ A: SELECT * FROM STUDENT1 WHERE CJ＞300 AND XB="男" B: SELECT * FROM STUDENT1 WHERE CJ＞=300 C: SELECT * FROM STUDENT1 WHERE CJ＞=300 AND XB="男" D: 以上都不是

SQL语句：CREATE UNIQUE CLUSTERED INDEX SS1 ON STUDENT1 (XH)的作用是______ A: 为表STUDENT1创建非唯一性聚集索引SS1 B: 为表STUDENT1创建唯一性聚集索引SS1 C: 为表STUDENT1创建唯一性非聚集索引SS1 D: 以上说法都不对

删除student表中id为1的记录，下列语句正确的是 A: DELETE student WHERE id=1; B: DELETE FROM student WHERE id=1; C: DELETE FROM student WHERE id:=1; D: DELETE student WHERE id:=1;

用SQL语句将STUDENT表中字段“年龄”的值加1，可以使用的命令是（ ）。 A: REPLACE STUDENT 年龄 WITH 年龄 + 1 B: UPDATE STUDENT SET 年龄 = 年龄 + 1 C: REPLACE STUDENT 年龄 = 年龄 + 1 D: UPDATE STUDENT 年龄 WITH 年龄 + 1