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

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
NULL is

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

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
A view is which of the following?

A base table that cannot be accessed via SQL commands
A virtual table that cannot be accessed via SQL commands
A base table that can be accessed via SQL commands
A virtual table that can be accessed via SQL commands

ANSWER DOWNLOAD EXAMIANS APP