Introduction to SQL Which of the following SQL commands can be used to add data to a database table? UPDATE INSERT APPEND ADD UPDATE INSERT APPEND ADD ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The keyword LIKE can be used in a WHERE clause to refer to a range of values. True False True False 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 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 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 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 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL WHERE clause: Neither A nor B are correct. limits the row data are returned. limits the column data that are returned. Both A and B are correct. Neither A nor B are correct. limits the row data are returned. limits the column data that are returned. Both A and B are correct. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL There is an equivalent join expression that can be substituted for all subquery expressions. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve only unique values? DISTINCT DISTINCTIVE UNIQUE DIFFERENT DISTINCT DISTINCTIVE UNIQUE DIFFERENT ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS