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

)删除视图salary的命令是

A) DROP VIEW salary

B) DROP salary VIEW

C) DELETE salary

D) DELETE salaryVIEW


相关考题:

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

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

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.

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

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

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

以下能删除数据库emp的语句是A.delete * from empB.drop database empC.drop * from empD.delete database emp

在SQL语言中,删除关系表中的一个属性列,要用什么动词,以及删除关系表中的一行或多行元组,要用什么动词?()A.delete,deleteB.drop,dropC.delete,dropD.drop,delete

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