Introduction to SQL Which SQL statement is used to delete data FROM a database? ALTER DELETE COLLAPSE REMOVE ALTER DELETE COLLAPSE REMOVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The rows of the result relation produced by a SELECT statement can be sorted, but only by one column. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the temperature in increasing order of all cities SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city, temperature FROM weather ORDER BY city; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city, temperature FROM weather ORDER BY city; SELECT city, temperature FROM weather ORDER BY temperature; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What operator tests column for the absence of data? None of these EXISTS operator IS NULL operator NOT operator None of these EXISTS operator IS NULL operator NOT operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query finds colors of boats reserved by "Dustin"? SELECT DISTINCT b.color FROM boats b, sailors s WHERE s.sname = 'Dustin' AND s.sid = b.sid SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND r.bid = b.bid SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid AND r.bid = b.bid; SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid SELECT DISTINCT b.color FROM boats b, sailors s WHERE s.sname = 'Dustin' AND s.sid = b.sid SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND r.bid = b.bid SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid AND r.bid = b.bid; SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS