Consider the relations shown in the exhibit. Due to restructuring, the sales department has
been eliminated and the employees working in that department have been dismissed. All ID
information is stored as integers. Which SQL statement would be used to return a relation with all
information for the employees who have been dismissed?
Which of the following best describes the ON DELETE NO ACTION referential integrity
constraint?
Consider the table shown in the exhibit. Which relational algebraic operation would return
Row 3?
A large enterprise uses a two-tier database architecture and runs complex database processing
on the client. Which term best describes the client in this system?
A relation for a construction company is shown in the exhibit. Which of the following best
defines the relationship between Cust_ID and Cust_Name?