Solved

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.  I BILLING HOURS  Employee No  Clieat No  Date  Hours  Ballizug Rate  B122  F26768 200108238150 A632  F11555 200108237100 B122  F26768 200108248150 A632  F11555 200108246100 B122  F26768 200108259150 A632  F11555 2001082510100\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

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions