Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?()A、DROP emp_dept_uv;B、DELETE emp_dept_uv;C、REMOVE emp_dept_uv;D、DROP VIEW emp_dept_uv;E、DELETE VIEW emp_dept_uv;F、REMOVE VIEW emp_dept_uv;

题目

Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?()

  • A、DROP emp_dept_uv;
  • B、DELETE emp_dept_uv;
  • C、REMOVE emp_dept_uv;
  • D、DROP VIEW emp_dept_uv;
  • E、DELETE VIEW emp_dept_uv;
  • F、REMOVE VIEW emp_dept_uv;
参考答案和解析
正确答案:D
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?()

A. DROP emp_dept_uv;

B. DELETE emp_dept_uv;

C. REMOVE emp_dept_uv;

D. DROP VIEW emp_dept_uv;

E. DELETE VIEW emp_dept_uv;

F. REMOVE VIEW emp_dept_uv;


参考答案:D

第2题:

根据SQL标准,删除索引应该选用下面哪个语句?()

A DELETE INDEX

B DROP INDEX

C DELETE VIEW

D DROP VIEW


参考答案B

第3题:

删除视图 myview 的命令是

A)DELETE myview VIEW

B)DELETE myview

C)DROP myview VIEW

D)DROP VIEW myview


正确答案:D

第4题:

)删除视图salary的命令是

A) DROP VIEW salary

B) DROP salary VIEW

C) DELETE salary

D) DELETE salaryVIEW


正确答案:A
【答案】:A
【知识点】:删除视图的命令格式
【解析】:SQL语句中,删除视图的格式为:DROP VIEW <视图名>,故选A。

第5题:

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

A)DROP stuvw

C) DELETE stuvw

B)DROP VIEW stuvw

D)DELETE VIEW stuvw


正确答案:B
删除视图的命令是DROP VIEW视图名。

第6题:

You are granted the CREATE VIEW privilege. What does this allow you to do? ()

A. Create a table view.

B. Create a view in any schema.

C. Create a view in your schema.

D. Create a sequence view in any schema.

E. Create a view that is accessible by everyone.

F. Create a view only of it is based on tables that you created.


参考答案:C

第7题:

在SQL语言中,删除视图的语句是______。

A.ALTER VIEW;

B.DROP VIEW;

C.ZAP VIEW;

D.DELETE VIEW;


正确答案:B

第8题:

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

A.DROP VIEW salary

B.DROP salary VIEW

C.DELETE salary

D.DELETE salary VIEW


正确答案:A
A。【解析】本题考查基本语句,删除视图应使用DROPVIEW视图名,所以答案选择A。

第9题:

删除视图salary的命令是 A) DROP salary VIEW B)DROP VIEW salary C)DELETE salary VIEW D)DELETE salary


正确答案:B
本题考查SQL中删除视图的命令.删除视图的命令格式为:
  DROP VIEW <视图名>
  故选项B为正确答案。

第10题:

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

A.DELETE myview

B.DELETE VIEW myview

C.DROP VIEW myview

D.REMOVE VIEW myview


正确答案:C
解析:视图由于是从表中派生出来的,所以不存在修改结构问题,但视图可以删除。删除视图的语法是:drop view视图名。

更多相关问题