Introduction to SQL
The SQL WHERE clause:

Both A and B are correct.
limits the column data that are returned.
Neither A nor B are correct.
limits the row data are returned.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following query finds the names of the sailors who have reserved at least one boat?

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 DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Find all the tuples having temperature greater than 'Paris'.

SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = 'Paris')
SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = 'Paris')
SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = 'Paris')
SELECT * FROM weather WHERE temperature > 'Paris' temperature

ANSWER DOWNLOAD EXAMIANS APP