1D0-541 Exam Dumps : CIW v5 Database Design Specialist

Consider the following SQL statement and the Orders relation shown in the exhibit:

What is the output of this SQL statement?

SELECT *

FROM Orders

WHERE NOT (Amount < 1000

AND Sales_Rep_No = 210);

Consider the entity-relationship (ER) diagram shown in the exhibit. What do the characters at the ends of the connecting line indicate?

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?