Introduction to SQL Which of the following query finds the names of the sailors who have reserved at least one boat? None of These SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; 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; 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; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ............. joins two or more tables based on a specified column value not equaling a specified column value in another table. EQUIJOIN NATURAL JOIN NON-EQUIJOIN OUTER JOIN EQUIJOIN NATURAL JOIN NON-EQUIJOIN OUTER JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL NULL is the same as blank for character the same as 0 for integer and blank for character the same as 0 for integer 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 not a value ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following must be enclosed in double quotes? Column Alias Dates Strings All of these Column Alias Dates Strings All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL is a programming language. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The condition in a WHERE clause can refer to only one value. False True False True ANSWER DOWNLOAD EXAMIANS APP