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 had a billing rate of $150?
A) SELECT Employee_No, Date
FROM BILLING_HOURS
WHERE Rate=150
B) QUERY Employee_No, Date
FROM BILLING_HOURS
WHERE Rate=150
C) SELECT Employee_No, Date
WHERE Rate=150
D) QUERY BILLING_HOURS
SELECT Employee_No, Date
WHERE Hours>8
Correct Answer:
Verified
Q57: Which of the following is an attribute
Q58: Which of the following statements about the
Q59: SQL
A) has become the de facto standard
Q60: The constraint that is specifies the degree
Q61: Which is not an SQL command in
Q63: A situation in which a particular supplier
Q64: The following E-R diagram shows a M:N
Q65: _ map and define the way in
Q66: Which of the following commands allow us
Q67: A(n) _ attribute is the attribute whose
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents