Introduction to SQL The SQL statement that queries or reads data from a table is ________ . SELECT READ None of these QUERY SELECT READ None of these QUERY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command is used to change a table's storage characteristics? None of these CHANGE TABLE MODIFY TABLE ALTER TABLE None of these CHANGE TABLE MODIFY TABLE ALTER TABLE 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 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 None of These 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 Find the sailor Ids of atmost one sailor who have reserved red boats but not green boats None of These ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL You can add a row using SQL in a database with which of the following? INSERT ADD CREATE MAKE INSERT ADD CREATE MAKE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword BETWEEN is used: to limit the columns displayed. for ranges. None of these as a wildcard. to limit the columns displayed. for ranges. None of these as a wildcard. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS