1) VOTE

Name	Vote1	Vote2
Bill	20	15
Mary	10	25
Jill	15	0
Bob	30	null

SELECT * FROM VOTE WHERE Vote1>10 AND VOTE2 >10 The execution of this query produces the following number of rows:

2

4

3

1

2)

VOTE

Name	Vote1	Vote2
Bill	20	15
Mary	10	25
Jill	15	0
Bob	30	null

SELECT * FROM VOTE WHERE Vote2 >=10 UNION SELECT * FROM VOTE WHERE Vote2 <10 The execution of this query produces the following number of rows:

1

4

3

2

3)

When using the SUM function with two columns, a row containing a null value for either column would produce a null value for that row.

True

False