Introduction to SQL The SQL keyword BETWEEN is used: as a wildcard. to limit the columns displayed. for ranges. None of these as a wildcard. to limit the columns displayed. for ranges. None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the original purpose of SQL? To specify the syntax and semantics of SQL data definition language To specify the syntax and semantics of SQL manipulation language To define the data structures All of these To specify the syntax and semantics of SQL data definition language To specify the syntax and semantics of SQL manipulation language To define the data structures All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL NULL is the same as 0 for integer and blank for character the same as 0 for integer the same as blank for character not a value the same as 0 for integer and blank for character the same as 0 for integer the same as blank for character not a value ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve a maximum value? UPPER TOP MAX MOST UPPER TOP MAX MOST ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query finds the name of the sailors who have reserved at least two boats? SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid <> r2.bid SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND COUNT(r1.bid) > r2.bid All of these SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid ≠ r2.bid SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid <> r2.bid SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND COUNT(r1.bid) > r2.bid All of these SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND r1.sid = r2.sid AND r1.bid ≠ r2.bid ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS