Introduction to SQL Which SQL statement is used to delete data FROM a database? REMOVE DELETE ALTER COLLAPSE REMOVE DELETE ALTER COLLAPSE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL data definition commands make up a(n) ________ . HTML DML DDL XML HTML DML DDL XML ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve a maximum value? TOP MOST UPPER MAX TOP MOST UPPER MAX ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL WHERE clause: Both A and B are correct. limits the column data that are returned. limits the row data are returned. Neither A nor B are correct. Both A and B are correct. limits the column data that are returned. limits the row data are returned. Neither A nor B are correct. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following must be enclosed in double quotes? Dates Strings Column Alias All of these Dates Strings Column Alias All of these 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 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 Find the sailor IDs of at least one sailor who have reserved red boats but not green boats ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS