1、对student的学号和班级编号列创建唯一聚集索引IX_student_sno_classno2、对student的姓名列创建非聚集索引IX_student_name3、利用索引IX_student_name查询名字叫'李健'的学生信息4、重新组织student表中的IX_student_name5、重建student表中的IX_student_name6、重命名表student的索引IX_student_name为IX_name7、删除表student中的索引IX_name
举一反三
- 表student中的包含两个字段，整型的id，字符串型的name。只显示表student中name列记录的SQL语句正确的是（） A: select name from student B: select * from student C: select from name in student D: select name
- Student类中存在String类型name属性,下列Student类的构造方法中,哪个是正确的？ A: Student(String name){} B: Student(String name) C: Student(name)() D: NewStudent (String name){}
- 若想查询student表中name为空值的记录，则正确的SQL语句是（ ）。 A: SELECT * FROM student WHERE name = NULL; B: SELECT * FROM student WHERE name like NULL; C: SELECT * FROM student WHERE name = 'NULL'; D: SELECT * FROM student WHERE name is NULL;
- 若想查询student表中name为空值的记录，则正确的SQL语句是（1.0分） A: select * from student where name = null; B: select * from student where name link null; C: select * from student where name = 'null'; D: select * from student where name is null;
- 修改表Student中姓名Name为“张三”的学生的专业Major改为“计算机” A: ALTER TABLE Student SET Name='张三' WHERE Major='计算机' B: UPDATE Student SET Name='张三' WHERE Major='计算机' C: UPDATE Student SET Major='计算机' WHERE Name='张三' D: ALTER TABLE Student SET Major='计算机' WHERE Name='张三'