INTRODUCTION TO SQL QUIZ

True

False

Applications are not needed

Reduced training costs

Increased dependence on a single vendor

All of these

report

file

table

form

None of these

SORT BY.

ORDER BY.

GROUP BY.

question mark (?); asterisk (*)

asterisk (*); percent sign (%)

percent sign (%); underscore (_)

underscore(_); question mark (?)

SORT BY

ORDER BY

SORT

ORDER

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' OR temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' OR temperature > 70;

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' AND temperature > 70;

False

True

SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid;

SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

None of These

SELECT * FROM student WHERE name LIKE 'r%';

SELECT * FROM student WHERE name LIKE '_r%';

SELECT * FROM student WHERE name LIKE '%r';

SELECT * FROM student WHERE name LIKE '%r%';