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

question 88

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 client number and date for every instance that had a billing rate of $150?

• A) QUERY BILLING_HOURS
• SELECT Client_No, Date
• WHERE Rate=150
• B) QUERY Client_No, Date
• FROM BILLING_HOURS
• WHERE Rate=150
• C) SELECT Client_No, Date
• WHERE Rate=150
• D) SELECT Client_No, Date
• FROM BILLING_HOURS
• WHERE Rate=150

---

Definitions:

Unasserted

Not confidently or forcefully stated or expressed.

Connective

A word or phrase in logic that connects propositions, such as "and," "or," and "not."

Asserted

To declare affirmatively; to state as a fact.

Connective

In logic and linguistics, a word or phrase that links sentences or clauses, such as and, or, but.