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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!