Exhibit 6-1
the Following Table Is a View of BILLING_HOURS

question 85

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. $\begin{array}{|c|c|c|c|c|c|}\hline\text { I BILLING HOURS }& \text { Employee No } & \text { Clieat No } & \text { Date } & \text { Hours } & \text { Ballizug Rate } \\\hline &\text { B122 } & \text { F26768 } & 20010823 & 8 & 150 \\\hline &\text { A632 } & \text { F11555 } & 20010823 & 7 & 100 \\\hline& \text { B122 } & \text { F26768 } & 20010824 & 8 & 150 \\\hline& \text { A632 } & \text { F11555 } & 20010824 & 6 & 100 \\\hline& \text { B122 } & \text { F26768 } & 20010825 & 9 & 150 \\\hline &\text { A632 } & \text { F11555 } & 20010825 & 10 & 100 \\\hline\end{array}$


-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