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:

1980

A year notable for various significant global and national events, including economic changes, political decisions, and cultural shifts.

Economy

An economy encompasses all activities related to production, consumption, and trade of goods and services in an area or country.

Balance of Trade

The variation in worth between what a country buys from and sells to other countries during a specific time frame.

Electricity

A form of energy resulting from the existence of charged particles, widely used for lighting, heating, and powering machines and devices.