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 relations shown in the exhibit. Which of the following SQL statements would enter data from the Customers relation into the Atlanta_Customers relation?

Consider the following four database design activities:

1 - Design user views.

2 - Select a DBMS.

3 - Apply normalization.

4 - Determine entities.

Which choice shows the correct ordering of these activities, from first to last, by assigned numbers?