网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
)删除视图salary的命令是
A) DROP VIEW salary
B) DROP salary VIEW
C) DELETE salary
D) DELETE salaryVIEW
参考答案
更多 “ )删除视图salary的命令是A) DROP VIEW salaryB) DROP salary VIEWC) DELETE salaryD) 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权限
热门标签
最新试卷