Question: 1. For the following table A, which rows will be returned by this query: SELECT * FROM A WHERE X = 0 X Y 0
1. For the following table A, which rows will be returned by this query: SELECT * FROM A WHERE X = 0
| X | Y |
| 0 | 5 |
| 10 |
a) -- no rows in result
b) (0,5)
c) (null, 10)
d) (0,5)
(null,10)
2. As you should know, it is against the law to discriminate on the basis of race when hiring. Pick which of the following is true:
a. The rule can be enforced by using a FOREIGN KEY constraint
b. The rule can be enforced by using a CHECK constraint
c. The rule can be enforced by using a PRIMARY KEY constraint
d. In general, this is not a rule that a database can enforce
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
