Introduction to SQL Which SQL keyword is used to sort the result-set? ORDER ORDER BY SORT SORT BY ORDER ORDER BY SORT SORT BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query finds the total rating of the sailors who have reserved boat "103"? SELECT s.rating FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103 SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103 c) SELECT COUNT(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103 SELECT SUM(s.rating) FROM sailors s, reserves r AND r.bid = 103; SELECT s.rating FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103 SELECT SUM(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103 c) SELECT COUNT(s.rating) FROM sailors s, reserves r WHERE s.sid = r.sid AND r.bid = 103 SELECT SUM(s.rating) FROM sailors s, reserves r AND r.bid = 103; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Most companies keep at least two versions of any database they are using. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement: can only be used with two tables. has a distinct form that cannot be duplicated by a join. cannot have its results sorted using ORDER BY. can always be duplicated by a join. can only be used with two tables. has a distinct form that cannot be duplicated by a join. cannot have its results sorted using ORDER BY. can always be duplicated by a join. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? UPDATE SAVE SAVE AS MODIFY UPDATE SAVE SAVE AS MODIFY ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS