Exhibit 6-1
?
The following table is a view of BILLING_HOURS from the various data elements in High-Tech Corp.'s relational database.
?
BILLING_HOURS
Employee_No
Client_No
Date
Hours
Billing_Rate
?
B122
F26768
20010823
8
150
?
A632
F11555
20010823
7
100
?
B122
F26768
20010824
8
150
?
A632
F11555
20010824
6
100
?
B122
F26768
20010825
9
150
?
A632
F11555
20010825
10
100
?
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, DateFROM BILLING_HOURSWHERE Hours>8
B. QUERY Employee_No, DateFROM BILLING_HOURSWHERE Hours>8
C. SELECT Employee_No, DateWHERE Hours>8
D. QUERY BILLING_HOURSSELECT Employee_No, DateWHERE Hours>8
Answer: A
You might also like to view...
“Digital technologies that allow people to connect, interact, produce and share content” is the definition of which of the following?
A. memes B. reinvention C. relative advantage D. social media
A component fails 100 times in 6,000 hr of operation. The MTBF of the system is ______.
A. 40 hr B. 60 hr C. 32 hr D. 55 hr
Feedback-based control systems measure outcomes and serve as a guide to corrective action.
Answer the following statement true (T) or false (F)
What are some answers to the question, “Who is the rater?”
What will be an ideal response?