Multiple Choice
Exhibit 6-1
The following table is a view of BILLING_HOURS from the various data elements in High-Tech Corp.'s relational database.
-Refer to Exhibit 6-1. Which of the following SQL statements would extract the client number and date for every instance that an employee worked less than 8 hours any particular day?
A) QUERY BILLING_HOURS
SELECT Client_No, Date
WHERE Hours<8
B) QUERY Client_No, Date
FROM BILLING_HOURS
WHERE Hours>8
C) SELECT Client_No, Date
WHERE Hours<8
D) SELECT Client_No, Date
FROM BILLING_HOURS
WHERE Hours<8
Correct Answer:

Verified
Correct Answer:
Verified
Q7: The following table is a view of
Q8: Legacy systems do not usually have which
Q9: Which of the following is the entity
Q10: A collection of data representing multiple occurrences
Q11: A primary attribute is the attribute whose
Q13: The _ command demonstrates one of the
Q14: Attributes are often called fields.
Q15: SQL is a powerful database language that
Q16: Most DBMS available today that include SQL
Q17: The following table is a view of