INTRODUCTION TO SQL QUIZ

report

form

file

table

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';

FROM, WHERE, SELECT

SELECT, FROM, WHERE

SELECT,WHERE,FROM

WHERE, FROM,SELECT

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

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

None of These

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

10

0

9

5

True

False

True

False

Join operation.

Projection operation.

Selection operation.

Rename operation.

False

True

True

False