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:

Mental Representations

Internal cognitive symbols that represent external reality, allowing individuals to think about objects, events, and conditions not immediately present.

Stable Personality Patterns

Consistent behaviors and thoughts that persist over time, defining an individual's personality.

Mental Processes

Internal, subjective experiences and operations that underlie cognitive functions such as perception, thought, memory, and reasoning.

Collective Unconscious

A concept in Jungian psychology referring to the part of the unconscious mind that is shared by all humans, containing universal archetypes.