Introduction to SQL Which SQL statement is used to delete data FROM a database? ALTER REMOVE DELETE COLLAPSE ALTER REMOVE DELETE COLLAPSE 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? All of these SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND COUNT(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 r1.sid = r2.sid AND r1.bid ≠ r2.bid All of these SELECT DISTINCT s.sname FROM sailors s, reserves r1, reserves r2 WHERE s.sid = r1.sid AND COUNT(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 r1.sid = r2.sid AND r1.bid ≠ r2.bid ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement is enclosed in: CAPITAL LETTERS. parenthesis -- (...) . braces -- {...}. brackets -- [...]. CAPITAL LETTERS. parenthesis -- (...) . braces -- {...}. brackets -- [...]. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command is used to change a table's storage characteristics? None of these ALTER TABLE MODIFY TABLE CHANGE TABLE None of these ALTER TABLE MODIFY TABLE CHANGE TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To sort the results of a query use: None of these ORDER BY. GROUP BY. SORT BY. None of these ORDER BY. GROUP BY. SORT BY. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS