删除视图salary的命令是( )。A.DROP VIEW salaryB.DROP salary VIEWC.DELETE salaryD.DELETE salary VIEW
删除视图salary的命令是( )。
A.DROP VIEW salary
B.DROP salary VIEW
C.DELETE salary
D.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?()ASELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) 5000 AND MAX(salary) 15000;BSELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) 5000 AND MAX(salary) 15000 GROUP BY dept_id;CSELECT dept_id, MIN(salary), MAX(salary) FROM employees HAVING MIN(salary) 5000 AND MAX(salary) 15000;DSELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id HAVING MIN(salary) 5000 AND MAX(salary) 15000;ESELECT 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?()ASELECT ename, salary*12 ‘Annual Salary’ FROM employees;BSELECT ename, salary*12 “Annual Salary” FROM employees;CSELECT ename, salary*12 AS Annual Salary FROM employees;DSELECT 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的命令是( )。ADROP VIEW salaryBDROP salary VIEWCDELECT salaryDDELECT salary VIEW