You work as a Database Administrator for Domain.com. You have created a new table named
Employee. Now, you want to create a view employee_view for this table. The view will contain the
emp_id, emp_name, emp_desig, salary, and emp_dept of those employees whose salary is
greater than $25000. You do not want to make changes to the column values through the view.
Which of the following syntaxes will you use to accomplish the task?
A.
CREATE VIEW employee_view
AS SELECT emp_id, emp_name, emp_desig, emp_dept
FROM Employee
HAVING salary > 25000
WITH READ ONLY;
B.
CREATE VIEW employee_view
AS SELECT emp_id, emp_name, emp_desig, emp_dept
FROM Employee
WHERE salary > 25000
WITH CHECK OPTION CONSTRAINT;
C.
CREATE VIEW employee_view
AS SELECT emp_id, emp_name, emp_desig, emp_dept
FROM Employee
WHERE salary > 25000
WITH READ ONLY;
D.
CREATE VIEW employee_view
AS SELECT emp_id, emp_name, emp_desig, emp_dept
FROM Employee
ORDER BY salary > 25000
WITH READ ONLY;