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

question 85

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

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

---

Definitions:

COLA

Cost Of Living Adjustment, an increase in income or benefits to offset inflation, ensuring that purchasing power is maintained despite rising prices.

Inflation Protection

Strategies or financial products designed to safeguard the purchasing power of assets or income in the face of rising inflation.

Contractual Agreements

Legally binding documents outlining terms and conditions agreed upon by parties engaging in a business or personal relationship.

Analytic HR

The application of statistical methods and technologies in human resources to improve employee performance and organizational efficiency.