现有关系模式:学生Student(学号,姓名,性别,出生年月,所在系)请用SQL的GRANT和REVOKE语句(加上视图机制)完成授权定义或存取控制功能:用户张新具有修改学生表的结构的权力。(____) view Student_view4(____)(____) * from Student(____) (____) on Student(____) ZhangXin

下列哪条语句可以创建视图( )。 A: create view v_student as select * from student; B: alter view v_student as select * from student; C: drop view v_student as select * from student; D: sp_help view v_student as select * from student;

在student表上创建view_stu视图,正确的语句是( )。 A: CREATE VIEW view_stu IS SELECT * FROM student; B: CREATE VIEW view_stu AS SELECT * FROM student; C: CREATE VIEW view_stu SELECT * FROM student; D: CREATE VIEW SELECT * FROM student AS view_stu;

创建数据表student的SQL语句为（） A: CREATE DATABASE student B: CREATE VIEW student C: CREATE PROCEDURE student D: CREATE TABLE student

要显示表student的表结构，可以使用命令______。 A: STRUCTURE student; B: DESCRIBE student; C: SHOW CREATE TABLE student; D: VIEW student;

下列语句中正确创建数据库“student”的是（） A: create table student B: create database student C: alter database student D: create view student

The optimistic view is that college student is climbing and will continue to do so, only at a slower-than-anticipated rate.

以下是修改视图的语句是 A: create or replace view st1 as select* from student; B: alter view st1 as select name from student join class on student.cid=class.id; C: alter table st1 modify class int(3); D: create or replace table st1 as select* from student;

建立信息系选修了1号课程的学生视图，正确的SQL语句为（） A: CREATE VIEW IS_S1 ASSELECT Student.Sno，Sname，Grade FROM Student，SCWHERE Sdept= 'IS' AND Student.Sno=SSno AND SCno= '1'； B: CREATE VIEW IS_S1 (Sno，Sname，Grade) ASSELECT Student.Sno，Sname，Grade FROM Student，SCWHERE Sdept= 'IS' AND SCno= '1'； C: CREATE VIEW IS_S1 (Sno，Sname，Grade) ASSELECT Student.Sno，Sname，GradeFROM Student，SC WHERE Sdept= 'IS' ANDStudent.Sno=SSno AND SCno= '1'

下面选项中，能够更新表student中id值小于4的SQL语句是（） A: ALTER TABLE student where id<4; B: UPDATE student set grade=100 where id<4; C: UPDATE student set grade=100 where id<=4; D: UPDATE Table student set grade=100 where id<4;