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 employee number and date for every instance that an employee worked more than 8 hours any particular day?
A) SELECT Employee_No, Date
FROM BILLING_HOURS
WHERE Hours>8
B) QUERY Employee_No, Date
FROM BILLING_HOURS
WHERE Hours>8
C) SELECT Employee_No, Date
WHERE Hours>8
D) QUERY BILLING_HOURS
SELECT Employee_No, Date
WHERE Hours>8
Correct Answer:

Verified
Correct Answer:
Verified
Q80: A(n) _ in an accounting system can
Q81: An entity in an accounting system can
Q82: Queries of a database are driven by
Q83: A relation in an ER model is
Q84: The DELETE command is used when we
Q86: A set of data that describes a
Q87: A(n) _ attribute is the attribute whose
Q88: Exhibit 6-1<br>The following table is a
Q89: The DELETE command is the method used
Q90: A key attribute is the attribute whose