Introduction to SQL Find the temperature in increasing order of all cities SELECT city, temperature FROM weather ORDER BY city; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY city; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city FROM weather ORDER BY temperature; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL NULL is not a value the same as 0 for integer the same as blank for character the same as 0 for integer and blank for character not a value the same as 0 for integer the same as blank for character the same as 0 for integer and blank for character ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The condition in a WHERE clause can refer to only one value. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a ________ . form table file report form table file report 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 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 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve only unique values? DISTINCTIVE UNIQUE DIFFERENT DISTINCT DISTINCTIVE UNIQUE DIFFERENT DISTINCT ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS