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

question 12

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 an employee worked less than 8 hours any particular day?

• A) QUERY BILLING_HOURS
• SELECT Client_No, Date
• WHERE Hours<8
• B) QUERY Client_No, Date
• FROM BILLING_HOURS
• WHERE Hours>8
• C) SELECT Client_No, Date
• WHERE Hours<8
• D) SELECT Client_No, Date
• FROM BILLING_HOURS
• WHERE Hours<8

---

Definitions:

Pricing Strategy

A method or plan a company uses to determine the best price for its products or services to maximize profits and market share.

Customer Perceptions

The views and attitudes consumers have towards a product or service, influenced by their experiences and expectations.

Product Mix

The assortment of different products that a company offers for sale to meet market demands and maximize profitability.

Limited Floor Space

A situation where the available physical area for business operations or inventory storage is constrained.