Introduction to SQL In SQL, which of the following is not a data definition language commands? REVOKE UPDATE RENAME GRANT REVOKE UPDATE RENAME GRANT 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 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 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 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 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 Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy'); SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy'); SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy'); SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy'); SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy'); SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy'); SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy'); SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy'); ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ............. joins two or more tables based on a specified column value not equaling a specified column value in another table. NON-EQUIJOIN EQUIJOIN NATURAL JOIN OUTER JOIN NON-EQUIJOIN EQUIJOIN NATURAL JOIN OUTER JOIN 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 of the following is the correct order of keywords for SQL SELECT statements? WHERE, FROM,SELECT FROM, WHERE, SELECT SELECT,WHERE,FROM SELECT, FROM, WHERE WHERE, FROM,SELECT FROM, WHERE, SELECT SELECT,WHERE,FROM SELECT, FROM, WHERE ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS