Introduction to SQL The condition in a WHERE clause can refer to only one value. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command is used to change a table's storage characteristics? ALTER TABLE None of these MODIFY TABLE CHANGE TABLE ALTER TABLE None of these MODIFY TABLE CHANGE TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL can be used to: All of these modify database data only. create database structures only. query database data only. All of these modify database data only. create database structures only. query database data only. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which one of the following sorts rows in SQL? GROUP BY SORT BY ALIGN BY ORDER BY GROUP BY SORT BY ALIGN BY ORDER BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL data definition commands make up a(n) ________ . DDL XML DML HTML DDL XML DML HTML 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 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 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 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 None of These Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS