)删除视图salary的命令是A) DROP VIEW salaryB) DROP salary VIEWC) DELETE salaryD) DELETE salaryVIEW - itgle

题目

)删除视图salary的命令是

A) DROP VIEW salary

B) DROP salary VIEW

C) DELETE salary

D) DELETE salaryVIEW

相似考题

1.删除列指令是()A、ALTERTABLE„DELETE„B、ALTERTABLE„DELETECOLUMN„C、ALTERTABLE„DROP„D、ALTERTABLE„DROPCOLUMN„

2.Examine the structures of the EMPLOYEES and TAX tables.EMPLOYEESEMPLOYEE_ID NUMBER NOT NULL, PrimaryKeyEMP_NAME VARCHAR2 (30)JOB_ID VARCHAR2 (20)SALARY NUMBERReferencesMGR_ID NUMBEREMPLOYEE_IDcolumnDEPARTMENT_ID NUMBER Foreign key toDEPARTMENT _IDcolumn of theDEPARTMENT tableTAXMIN_SALARY NUMBERMAX_SALARY NUMBERTAX_PERCENT NUMBERPercentage tax for givensalary rangeYou need to find the percentage tax applicable for each employee. Which SQL statement would you use?（）A. SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary BETWEEN t.min _ salary AND t.max_salaryB. SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary > t.min_salary, tax_percentC. SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salaryD. You cannot find the information because there is no common column between the two tables.

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

4.以下删除表正确的( )A.Delete * from empB.Drop database empC.Drop * from empD.delete database emp

更多“)删除视图salary的命令是A) DROP VIEW salaryB) DROP salary VIEWC) DELETE salaryD) DELETE sal ”相关问题

第1题：

在SQL中，DROP和DELETE的区别在于是否删除了【】结构。

正确答案：表
DROP是删除表结构，DELETE是删除了表中的行
第2题：

以下能删除数据库emp的语句是
A．delete * from emp
B．drop database emp
C．drop * from emp
D．delete database emp

drop database emp
第3题：

下面选项中，删除视图应当拥有的权限是哪个？
A．create权限
B．update权限
C．drop权限
D．delete权限

DROP权限
第4题：

SQL语言中，删除基本表的语句动词是delete，删除数据的语句动词是drop 。

错误
第5题：

在SQL语言中，删除关系表中的一个属性列，要用什么动词，以及删除关系表中的一行或多行元组，要用什么动词？（）
A．delete，delete
B．drop，drop
C．delete，drop
D．drop，delete

D

相关内容