删除视图STUDENT的命令是( )。A.DELETE STUDENT VIEWB.DELETE STUDETNC.DROP STUDENT VIEWD.DROP VIEW STUDENT

删除视图STUDENT的命令是( )。

A.DELETE STUDENT VIEW

B.DELETE STUDETN

C.DROP STUDENT VIEW

D.DROP VIEW STUDENT


相关考题:

一数据库名为student要想打开该数据库,应使用命令A)OPEN student B)OPEN DATA studentC)USE DATA student D)USE student

删除视图myview的命令是 ______。A.DELETE myview VIEWB.DEL ETE myviewC.DROP myview VIEWD.DROP VIEW myview

删除视图STUDENT的命令是( )。A.DELETE STUDENT VIEWB.DELETE STUDETNC.DROP STUDENT VIEWD.DROP VIEW STUDENT

“show databases like ‘student%’”命令可以显示出以下数据库( )A.student_myB.studentyC.mystudentD.student

创建一个名为RS的视图,用来显示所有学生的学号,姓名和平均成绩,下面正确的语句是__A SELECT STUDENT.学号,STUDENT.姓名,SKB.平均成绩 WHERE STUDENT.学号 = SKB.学号 GROUP BY STUDENT.学号 INTO CURSOR RSB CREATE VIEW RS AS SELECT STUDENT.学号,STUDENT.姓名,SKB.平均成绩 WHERE STUDENT.学号 = SKB.学号 GROUP BY STUDENT. 学号C SELECT STUDENT.学号,STUDENT.姓名,SKB 平均成绩 WHERE STUDENT.学号 = SKB.学号 GROUP BY STUDENT.学号 INTO CURSOR RSD CREATE VIEW RS AS SELECT STUDENT.学号,STUDENT.姓名,AVG(SKB.成绩) AS 平均成绩 WHERE STUDENT.学号 = SKB.学 号 GROUP BY STUDENT.学号

从student表删除年龄大于30的记录的正确SQL命令是( )。A.DELETE FOR年龄30B.DELETE FROM student WHERE年龄30C.DELETE student FOR年龄30D.DELETE student WHERE年龄30

由于学号(SN)为00291的学生已毕业,欲在关系“Student”中删除该学生的所有信息,用元组关系演算语言实现应为(53)。A.GET W(Student): Student. SN = 00291' DELETE WB.GET W: Student. SN = 00291'in Student DELETE WC.HOLD W(student): Student. SN = 00291' DELETE WD.HOLD W: Student. SN = 00291'in Student DELETE W

根据SQL标准,创建一个视图abc,通过该视图只能对表student中系dept为‘IS’的记录进行更新操作。下面哪条语句适用?()A create view abc as select * from student where dept=’IS’B create view abc as select * from student where dept=’IS’ with check optionC create view abc as student where dept=’IS’D create view abc as select dept=’IS’ from student

删除视图STUDENT的命令是( )。A.DELETE STUDENTVIEWB.DELETE STUDETNC.DROP STUDENTVIEWD.DROPVIEW STUDENT

删除视图myview的命令是( )。A.DELETE myview VlEWB.DELETE myviewC.DROP myview VIEWD.DROP VIEW myview

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

从student表删除年龄大于30的记录的正确SQL命令是( )。A. DELETE FOR年龄30B. DELETE FROM student WHERE年龄30C. DELETE student FOR年龄30D. DELETE student WHERE年龄30

删除student表中“平均成绩”字段的正确SQL命令是( )。A. DELETE TABLE student DELETE COLUMN平均成绩B. ALTER TABLE student DELETE COLUMN平均成绩C. ALTER TABLE student DROP COLUMN平均成绩D. DELETE TABLE student DROP COLUMN平均成绩

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

删除student表的“平均成绩”字段的正确SQL命令是( )。A.DELETE TABLE student DELETE COLUMN平均成绩B.ALTER TABLE student DELETE COLUMN平均成绩C.ALTER TABLE student DROP COLUMN平均成绩D.DELETE TABLE student DROP COLUMN平均成绩

删除视图STUDENT的命令是( )。A.DELETE STUI)ENT VIEWB.DELETE STUI)ETNC.DROP STUDENT VIEWD.DROP VIEW STUDENT

删除student表的“平均成绩”字段的正确SQL命令是A.DELETE TABLE student DELETE COLUMN平均成绩B.ALTER TABLE student DELETE C0LUMN平均成绩C.ALTER TABLE student DROP COLUMN平均成绩D.DELETE TABLE student DROP COLUMN平均成绩

删除视图myview的命令是( )。A.DELETE myview VIEWB.DELETE myviewC.DROP myview VIEWD.DROP VIEW myview

运行查询(student)的命令是( )。A.DO studentB.DO student.qprC.DO QUERY studentD.RUN QUERY student

删除student表中“平均成绩”字段的正确SQL命令是( )。A.DELETE TABLE student DELETE COLUMN平均成绩B.ALTER TABLE student DELETE COLUMN平均成绩C.ALTER TABLE student DROP COLUMN平均成绩D.DELETE TABLE student DROP COLUMN平均成绩

( 6 ) SELECT * FROM student 【 6 】 FILE student 命令将查询结果存储在 student . txt 文本文件中。

使用useradd命令添加用户student,然后使用userdel删除该用户。

在SQL Server数据库中,已有数据表student,可以删除该表数据的命令是()。A、DROP FROM studentB、DELETE FROM studentC、REMOVE FROM studentD、KILL FROM student

对于如下代码,描述正确的是哪项? ()   class Student{   public static void main(String[] args){   Student student = new Student();  }  }  A、Student student 声明了一个类B、new Student()创建了Student 对象的一个实例C、Student student 声明了对象Student 的一个引用D、class Student 声明了一个类

单选题创建一个名为student的新类,保存新类的类库名称是mylib,新类的父类是Person,正确的命令是(  )。ACREATE CLASS mylib OF student As PersonBCREATE CLASS student OF Person As mylibCCREATE CLASS student OF mylib As PersonDCREATE CLASS Person OF mylib As student

单选题删除student表的“平均成绩”字段的正确SQL命令是(  )。ADELETE TABLE student DELETE COLUMN平均成绩BALTER TABLE student DELETE COLUMN平均成绩CALTER TABLE student DROP COLUMN平均成绩DDELETE TABLE student DROP COLUMN平均成绩

单选题从student表删除年龄大于30的记录的正确SQL命令是(  )。ADELETE FOR年龄30BDELETE FROM student WHERE年龄30CDELETE student FOR年龄30DDELETE student WHERE年龄30

在数据库中,删除数据表student的命令是什么? (1.0分) [单选.] A. delete table student B. delete student C. drop student D. drop table student