單項(xiàng)選擇題

You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20.Which SQL statement would you use to create the view EMP_VU?（）

A. CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);
B. CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;
C. CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;
D. CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);
E. CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;

你可能感興趣的試題

多項(xiàng)選擇題

From SQLPlus, you issue this SELECT statement:
SELECT
FROM order;
You use this statement to retrieve data from a data table for （）.

A. Updating
B. Viewing
C. Deleting
D. Inserting
E. Truncating

單項(xiàng)選擇題

Examine the description of the EMPLOYEES table:

Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only of the minimum salary is less then 5000 and the 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;

<blockquote id="svfj7"></blockquote>

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20.Which SQL statement would you use to create the view EMP_VU?（）

你可能感興趣的試題

From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.

Examine the description of the EMPLOYEES table: Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only of the minimum salary is less then 5000 and the maximum salary is more than 15000?（）

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

From SQLPlus, you issue this SELECT statement:
SELECT
FROM order;
You use this statement to retrieve data from a data table for （）.

Examine the description of the EMPLOYEES table:

Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only of the minimum salary is less then 5000 and the maximum salary is more than 15000?（）