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?
A) CREATE VIEW Emp_Dept AS SELECT Last_Name, First_Name, Dept_ID FROM Employee;
B) UPDATE VIEW Emp_Dept AS SELECT * FROM
C) UPDATE VIEW Emp_Dept AS SELECT
D) CREATE VIEW Emp_Dept Employee WHERE ID = 0001 AND ID = 0002 AND ID = 0003 AND ID = 0004;

Question

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? 
A) CREATE VIEW Emp_Dept AS SELECT Last_Name, First_Name, Dept_ID FROM Employee; 
B) UPDATE VIEW Emp_Dept AS SELECT * FROM 
C) UPDATE VIEW Emp_Dept AS SELECT 
D) CREATE VIEW Emp_Dept Employee WHERE ID = 0001 AND ID = 0002 AND ID = 0003 AND ID = 0004;

Quizplus · Accepted Answer

The Answer of 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? 
A) CREATE VIEW Emp_Dept AS SELECT Last_Name, First_Name, Dept_ID FROM Employee; 
B) UPDATE VIEW Emp_Dept AS SELECT * FROM 
C) UPDATE VIEW Emp_Dept AS SELECT 
D) CREATE VIEW Emp_Dept Employee WHERE ID = 0001 AND ID = 0002 AND ID = 0003 AND ID = 0004;

Consider the Employee Relation Shown in the Exhibit