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

question 103

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 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

---

Definitions:

Gross Method

Gross Method in accounting is a method for recording purchases at the full invoice price without deducting any cash discounts offered.

Periodic Inventory Method

An accounting approach that updates inventory and cost of goods sold at the end of an accounting period based on a physical count.

Merchandise

Goods or products that are bought and sold by businesses in the market.

Purchase Order

A document issued by a buyer to a seller indicating types, quantities, and agreed prices for products or services.