Multiple Choice
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:

Verified
Correct Answer:
Verified
Q2: The cardinality constraint:<br>A) specifies the degree of
Q8: Legacy systems do not usually have which
Q26: A set of data that describes a
Q28: The _ command is used to add
Q31: The notation 1:N is used to specify
Q33: In an REA diagram, the rectangle is
Q48: A recursive relationship is created when there
Q59: Relationships map and define the way in
Q98: The _ is specified to uniquely identity
Q172: Which of the following is not a