Introduction to SQL Count function in SQL returns the number of distinct values. values. columns. groups. distinct values. values. columns. groups. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which one of the following sorts rows in SQL? ALIGN BY SORT BY GROUP BY ORDER BY ALIGN BY SORT BY GROUP BY ORDER BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the names of the countries whose condition is sunny. SELECT country FROM location WHERE condition = 'sunny'; SELECT country FROM location WHERE city UNION (SELECT city FROM weather WHERE condition = 'sunny'); SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny'); SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather WHERE condition = 'sunny'); SELECT country FROM location WHERE condition = 'sunny'; SELECT country FROM location WHERE city UNION (SELECT city FROM weather WHERE condition = 'sunny'); SELECT country FROM location WHERE city IN (SELECT city FROM weather WHERE condition = sunny'); SELECT country FROM location WHERE city NOT IN (SELECT city FROM weather WHERE condition = 'sunny'); ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? TRUNCATE COMMIT DELETE ROLLBACK TRUNCATE COMMIT DELETE ROLLBACK ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What does the following query find?(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'red')MINUS(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'green') Find the sailor IDs of at least one sailor who have reserved red boats but not green boats None of These Find the sailor IDs of all sailors who have reserved red boats but not green boats Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats Find the sailor IDs of at least one sailor who have reserved red boats but not green boats None of These Find the sailor IDs of all sailors who have reserved red boats but not green boats Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS