Introduction to SQL
The command to remove rows from a table 'CUSTOMER' is:

DELETE FROM CUSTOMER WHERE ...
UPDATE FROM CUSTOMER ...
DROP FROM CUSTOMER ...
REMOVE FROM CUSTOMER ...

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

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
NULL is

not a value
the same as blank for character
the same as 0 for integer and blank for character
the same as 0 for integer

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following query finds the total rating of the sailors who have reserved boat "103"?

SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103
c) SELECT COUNT(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103
SELECT s.rating FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103
SELECT SUM(s.rating) FROM sailors s, reserves r AND r.bid = 103;

ANSWER DOWNLOAD EXAMIANS APP