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

题目

相似考题

1.删除视图salary的命令是A．DROP salary VIEWB．DROP VIEW salaryC．DELETE salary VIEWD．DELETE salary

2.Examine the data in the EMPLOYEES table:Which three subqueries work? ()A. SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);B. SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);C. SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);D. SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);E. SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);F. SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));

3.Click the Exhibit button and examine the data in the EMPLOYEES table.Which three subqueries work? ()A.SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id);B.SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);C.SELECT distinct department_id FROM employees WHERE salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);D.SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);E.SELECT last_name FROM employees WHERE salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department_id);F.SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));

4.删除视图salary的命令是( )。A.DROP VIEW salaryB.DROP salary VIEWC.DELETE salaryD.DELETE salary VIEW

更多“删除视图salary的命令是 A) DROP salary VIEW B)DROP VIEW salary C)DELETE salary VIEW ”相关问题

第1题：

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

正确答案：A
【答案】：A
【知识点】：删除视图的命令格式
【解析】：SQL语句中，删除视图的格式为：DROP VIEW <视图名>，故选A。
第2题：

向量的计算（1）将上题中的salary_A和salary_B按元素相加，存入变量salary_total （2）将salary_total打印出来（3）将salary_A和salary_B按元素相减，存入变量salary_diff，并打印出来

B
第3题：

将变量salary重新赋值为原来取值的3倍的语句是（）
A．salary=salary*2.00;
B．salary=salary+(salary*3.00);
C．salary=salary*3;
D．salary=*3;

DECLARE @countSELECT @count=1
第4题：

● 设有职工表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.Wage
FROM emp, salary
WHERE emp.Eno=salary.Eno
ORDER BY ENO
在此视图上查均月工资在3000以上的职工工资情况的SQL语句为：
SELECT Eno，Ename，AVG（Wage）
FROM V-Salary
GROUP 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.Ename
C.Month D.Wage

正确答案：B,A
此题第一空容易，考查考生是否了解建立视图的语法规则。第二空也比较明显，在salary中有字段Month，用于标识当前记录是哪个月的工资记录，这就意味着在数据表中，一个Eno对应着多个工资记录，要计算平均值，可以先按Eno进行分组，再求工资平均值，所以第2空填A。
第5题：

【填空题】创建、修改和删除视图命令分别是__________view、_________ view和_________ view

CREATE VIEW

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

题目

相似考题

更多“删除视图salary的命令是 A) DROP salary VIEW B)DROP VIEW salary C)DELETE salary VIEW ”相关问题

相关内容