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?

Question

Accepted Answer

A. CREATE VIEW Emp_Dept

Answer

B. UPDATE VIEW Emp_Dept

Answer

C. UPDATE VIEW Emp_Dept

Answer

D. CREATE VIEW Emp_Dept

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…

Question

Exhibit

Options

How the community answered

Community Discussion