Introduction to SQL The SQL statement that queries or reads data from a table is ________ . QUERY SELECT None of these READ QUERY SELECT None of these READ ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? ALTER DELETE REMOVE COLLAPSE ALTER DELETE REMOVE COLLAPSE 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 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 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 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 atmost one sailor who have reserved red boats but not green boats ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a ________ . report table form file report table form file ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve only unique values? DISTINCT UNIQUE DISTINCTIVE DIFFERENT DISTINCT UNIQUE DISTINCTIVE DIFFERENT ANSWER DOWNLOAD EXAMIANS APP