Solved

Consider the Employee Relation Shown in the Exhibit

Question 72

Multiple Choice

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? 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;


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;

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q65: Which mechanism provides database users with controlled

Q66: Which database architecture is best suited to

Q67: What is the highest normal form of

Q68: Which type of relational integrity is violated

Q69: What improvement can be made to file-based

Q70: Consider the Project relation shown in the

Q71: Which of the following definitions best describes

Q73: Your enterprise is developing a database system

Q74: The database manager wants to give Rubio

Q75: Which of the following is a characteristic