网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
删除视图salary的命令是( )。
A.DROP VIEW salary
B.DROP salary VIEW
C.DELETE salary
D.DELETE salary VIEW
参考答案
更多 “ 删除视图salary的命令是( )。A.DROP VIEW salaryB.DROP salary VIEWC.DELETE salaryD.DELETE salary VIEW ” 相关考题
考题
建立一个视图salary，该视图包括了系号和(该系的)平均工资两个字段，正确的 SQL语句是A．CREATE VIEW salary AS系号，AVG(工资)AS平均工资FROM教师； GROUP BY系号B．CREATE VIEW salary AS SELECT系号,AVG(工资)AS平均工资FROM教师； GROUP BY系名C．CREATE VIEW salary SELECT系号,AVG(工资)AS平均工资FROM教师； GROUP BY系号D．CREATE VIEW salary AS SELECT系号,AVG(工资)AS平均工资FROM教师； GROUP BY系号
考题
为视图重命名的命令是( )。 A.MODIEY VlEWB.CREATE VIEWC.DELETE VIEWSXB
为视图重命名的命令是（ ）。A.MODIEY VlEWB.CREATE VIEWC.DELETE VIEWD.RENAME VIEW
考题
● 设有职工表emp（Eno，Ename，Sex，Age）（Eno为职工号，Ename为职工姓名，Sex为性别，Age为年龄）和salary（Eno，Hour，Month，Wage）（Hour为工作时长为多少小时，Month表示几月份，Wage为薪水），建立一个视图V-Salary（Eno，Ename，Hour，Month，Wage），并按Eno升序排序的SQL语句为：（1）CREATE （ ）AS SELECT emp.Eno，emp.Ename ，salary.Hour，salary.Month，salary.WageFROM emp, salaryWHERE emp.Eno=salary.EnoORDER BY ENO在此视图上查均月工资在3000以上的职工工资情况的SQL语句为：SELECT Eno，Ename，AVG（Wage）FROM V-SalaryGROUP BY （ ）HAVING AVG(Wage)3000（ ）A. CREATE TABLE V-Salary（emp.Eno，emp.Ename，salary.Hour，salary.Month，salary.Wage）B. CREATE VIEW V-Salary（Eno，Ename，Hour，Month，Wage）C. CREATE TABLE V-Salary（Eno，Ename，Hour，Month，Wage）D. CREATE INDEX V-Salary（Eno，Ename，Hour，Month，Wage）（ ）A. Eno B.EnameC.Month D.Wage
考题
建立一个视图salary,该视图包括了系号和(该系的)平钧工资两个字段,正确的是SQL语句是A）CREATE VIEW salaryAS系号，AVG（工资）AS平均工资FROM教师；GROUP BY系号B) CREATE VIEW salary AS SELECT系号，AVG(工资)AS平均工资FROM教师；GROUP BY系名C) CREATE VIEW salary SELECT系号，AVG(工资）AS平均工资FROM教师；GROUP BY系号D）CREATE VIEW salary AS SELECT系号，AVG（工资）As平均工资FROM教师；GROUP BY系号
考题
为视图重命名的命令是( )。A.MODIEY VIEWB.CREATE VIEWC.DELETE VIEW
为视图重命名的命令是（ ）。A.MODIEY VIEWB.CREATE VIEWC.DELETE VIEWD.RENAME VIEW
考题
SQL中，SALARYIN(1000，2000)的语义是______。A．SALARY≤2000 AND SALARY≥1000B．SALARY＜2000 AND SALARY＞1000C．SALARY=1000 AND SALARY=2000D．SALARY=1000 OR SALARY=2000
考题
SQL语句中删除视图的命令是( )。A.DRP TABLE B.DROP VIEW C.ERASE TABLE S
SQL语句中删除视图的命令是（ ）。A.DRP TABLEB.DROP VIEWC.ERASE TABLED.ERASE VIEW
考题
建立一个视图salary，该视图包括了系号和(该系的)平均工资两个字段，正确的SQL语句是（ ）。A)CREATE VIEW salary AS系号，AVG(工资)AS平均工资FROM教师；GROUPBY系号B)CREATEVIEW salaryAS SELECT系号，AVG(工资)AS平均工资FROM教师；GROUPBY系名C)CREATE VIEW Salary SELECT系号，AVG(工资)AS平均工资FROM教师；GROUP BY系号D)CREATE VIEW salaryAS SELECT系号，AVG(工资)AS平均工资FROM教师；GROUPBY系号
考题
单选题Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_ NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) JOB_CAT VARCHAR2(30) SALARY NUMBER(8,2) Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only if the minimum salary is less than 5000 and maximum salary is more than 15000?（）A
SELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) 5000 AND MAX(salary) 15000;B
SELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) 5000 AND MAX(salary) 15000 GROUP BY dept_id;C
SELECT dept_id, MIN(salary), MAX(salary) FROM employees HAVING MIN(salary) 5000 AND MAX(salary) 15000;D
SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id HAVING MIN(salary) 5000 AND MAX(salary) 15000;E
SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id, salary HAVING MIN(salary) 5000 AND MAX(salary) 15000;
考题
单选题Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）A
SELECT ename, salary*12 ‘Annual Salary’ FROM employees;B
SELECT ename, salary*12 “Annual Salary” FROM employees;C
SELECT ename, salary*12 AS Annual Salary FROM employees;D
SELECT ename, salary*12 AS INITCAP(“ANNUAL SALARY”) FROM employees
考题
单选题评估此CREATE VIEW语句： CREATE VIEW emp_view AS SELECT SUM(salary) FROM employees; 以下哪个说法是的（）A
使用“雇员视图”视图不能更新“雇员”表中的数据B
使用“雇员视图”视图可以更新“雇员”表中的任何数据C
使用“雇员视图”视图不能删除“雇员”表中的记录D
使用“雇员视图”视图仅能更新“雇员”表中的“薪金”列
考题
单选题删除视图salary的命令是（ ）。A
DROP VIEW salaryB
DROP salary VIEWC
DELECT salaryD
DELECT salary VIEW
热门标签
最新试卷