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 SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA'; SELECT NAME IN CUSTOMER WHERE STATE = 'V'; SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE = 'VA'; SELECT NAME IN CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE = 'V'; SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE = 'VA'; SELECT NAME IN CUSTOMER WHERE STATE IN ('VA'); ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword(s) ________ is used with wildcards. IN and NOT IN IN only LIKE only NOT IN only IN and NOT IN IN only LIKE only NOT IN only ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A dynamic view is one whose contents materialize when referenced. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? REMOVE DELETE COLLAPSE ALTER REMOVE DELETE COLLAPSE ALTER 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 Find the sailor Ids of atmost 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 at least one sailor 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 None of These Find the sailor IDs of all sailors who have reserved red boats but not green boats ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS