PrepAway - Latest Free Exam Questions & Answers

Which SQL statement will accomplish this?

Consider the Employee relation shown in the exhibit.

A database manager wants to set up a view called Emp_Dept that allows users to find employees and their department ID numbers. Which SQL statement will accomplish this?

PrepAway - Latest Free Exam Questions & Answers

A.
CREATE VIEWEmp_Dept AS SELECT
Last_Name, First_Name, Dept_ID FROM
Employee;

B.
UPDATE VIEWEmp_Dept
AS SELECT * FROM
Employee;

C.
UPDATE VIEWEmp_Dept AS SELECT
Last_Name, First_Name, Dept_ID FROM
Employee;

D.
CREATE VIEWEmp_Dept
AS SELECT * FROM
Employee WHERE ID = 0001
AND ID = 0002 AND ID =
0003 AND ID = 0004;


Leave a Reply