Introduction to SQL Which of the following group functions ignore NULL values? All of these COUNT SUM MAX All of these COUNT SUM MAX ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ORDER BY can be combined with the SELECT statements. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL query and modification commands make up a(n) ________ . DDL DML HTML XML DDL DML HTML XML 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 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 Find the sailor IDs of all sailors who have reserved red boats but not green boats None of These 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 Find the sailor IDs of all sailors who have reserved red boats but not green boats None of These ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command(s) is(are) used to change a table's storage characteristics? MODIFY TABLE CHANGE TABLE ALTER TABLE All of these MODIFY TABLE CHANGE TABLE ALTER TABLE All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The rows of the result relation produced by a SELECT statement can be sorted, but only by one column. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS