Consider the Employee relation shown in the exhibit. A database manager wants to set up a view called Emp_Dept that allo
Posted: Sat Jul 23, 2022 7:29 pm
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 Employee;
C. UPDATE VIEW Emp_Dept AS SELECT Last_Name, First_Name, Dept_ID FROM Employee;
D. CREATE VIEW Emp_Dept AS SELECT * FROM Employee WHERE ID = 0001 AND ID = 0002 AND ID = 0003 AND ID = 0004;
- Consider The Em 1 (160.19 KiB) Viewed 75 times
B. UPDATE VIEW Emp_Dept AS SELECT * FROM Employee;
C. UPDATE VIEW Emp_Dept AS SELECT Last_Name, First_Name, Dept_ID FROM Employee;
D. CREATE VIEW Emp_Dept AS SELECT * FROM Employee WHERE ID = 0001 AND ID = 0002 AND ID = 0003 AND ID = 0004;