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.
-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
Correct Answer:

Verified
Correct Answer:
Verified
Q93: In a relational database, the entity is
Q94: _ specifies that for every attribute value
Q95: A simplified representation of a complex entity
Q96: _ systems have existed in an organization
Q97: The cardinality constraint is used to specify
Q98: The _ is specified to uniquely identity
Q99: The SELECT statement has all but one
Q100: _ values waste memory space and may
Q101: In a relational database, a relation is
Q102: A set of data that describes a