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:

Available-For-Sale Securities

Financial assets that are intended to be sold before their maturity date but are not actively traded or held to maturity, subject to changes in fair value recorded in other comprehensive income.

Trading Securities

Financial instruments like stocks or bonds that are bought and sold for the purpose of generating profits on short-term fluctuations in price.

Trading Gains

Profits realized from buying and selling financial instruments within a short period, aiming to benefit from market price movements.

Minority Passive Investments

Investments in which the investor holds a non-controlling stake and does not actively participate in management.