Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started