1D0-541 Free Practice Test

Consider the relation shown in the exhibit. Which of the following SQL statements would return a relation that excludes all customers with a Satisfaction_Rate of less than or equal to 80 unless the Sales_Office is located in Atlanta?

1. A. SELECT *FROM CustomersWHERE Satisfaction_Rate > 80 OR Sales_Office = Atlanta;
2. B. SELECT *FROM CustomersWHERE Satisfaction_Rate <= 80 AND Sales_Office = Atlanta;
3. C. SELECT *FROM CustomersWHERE Satisfaction_Rate >= 80;
4. D. SELECT *FROM CustomersWHERE Satisfaction_Rate >= 80 AND NOT Sales_Office = Atlanta;

Correct Answer: A

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

What is the output of this SQL statement?

1. A. [MISSING]
2. B. [MISSING]
3. C. [MISSING]
4. D. [MISSING]

Correct Answer: C

Consider the Orders relation shown in the exhibit. Which of the following SQL statements would return all complete tuples for order dates in 2002, arranged by amount from lowest to highest?

1. A. SELECT *FROM OrdersWHERE Order_Date LIKE _02 ORDER BY Amount;
2. B. SELECT (Order_Date, Amount) FROM OrdersWHERE Order_Date LIKE ORDER BY Amount;
3. C. SELECT *FROM OrdersWHERE Order_Date LIKE _02 ORDER BY Order_No;
4. D. SELECT *FROM OrdersWHERE Order_Date LIKE ORDER BY Amount;

Correct Answer: D

Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return all tuples that have course codes beginning with the letter M?

1. A. SELECT *FROM RegistrationWHERE Course_Code = M#;
2. B. SELECT *FROM RegistrationWHERE Course_Code LIKE M_;
3. C. SELECT *FROM RegistrationWHERE Course_Code LIKE M%;
4. D. SELECT *FROM RegistrationWHERE Course_Code = M%;

Correct Answer: C

Your enterprise has created a database and database application. The testing phase for the project has started. Which of the following best describes white-box testing of the projects software?

1. A. The database designer tests the software because he or she is able to make necessary changes to the underlying code for the software.
2. B. A user who has no knowledge of the softwares underlying code tests the software.
3. C. Someone other than the database designer tests the softwar
4. D. This person has no access to the underlying code and attempts to use thesoftware only in ways not considered by the software designers.
5. E. A person tests the software and submits suggestions to the software's underlying code.This person is someone other than the databasedesigner, but has access to the softwares underlying code.

Correct Answer: D