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:

Query Grid

A query grid is a visual tool in database software that allows users to construct and visualize SQL queries by arranging tables, fields, and conditions in a grid-like interface.

Discount Column

A column in invoices or financial documents indicating the amount of discount applied to the items or services listed.

Field List

A collection of fields available in a database or software application for generating reports or performing analyses.

Query Tools Design

The aspect of database management that involves creating, modifying, and managing queries to retrieve or manipulate data using specialized software tools.