)删除视图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„
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.
在SQL语言中,删除关系表中的一个属性列,要用什么动词,以及删除关系表中的一行或多行元组,要用什么动词?()A.delete,deleteB.drop,dropC.delete,dropD.drop,delete
下面选项中,删除视图应当拥有的权限是哪个?A.create权限B.update权限C.drop权限D.delete权限