Introduction to SQL What operator tests column for the absence of data? None of these IS NULL operator EXISTS operator NOT operator None of these IS NULL operator EXISTS operator NOT operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL WHERE clause: limits the column data that are returned. Neither A nor B are correct. Both A and B are correct. limits the row data are returned. limits the column data that are returned. Neither A nor B are correct. Both A and B are correct. limits the row data are returned. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query finds colors of boats reserved by "Dustin"? SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid SELECT DISTINCT b.color FROM boats b, sailors s WHERE s.sname = 'Dustin' AND s.sid = b.sid SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND r.bid = b.bid SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid AND r.bid = b.bid; SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid SELECT DISTINCT b.color FROM boats b, sailors s WHERE s.sname = 'Dustin' AND s.sid = b.sid SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND r.bid = b.bid SELECT DISTINCT b.color FROM boats b, reserves r, sailors s WHERE s.sname = 'Dustin' AND s.sid = r.sid AND r.bid = b.bid; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve only unique values? DISTINCTIVE DIFFERENT DISTINCT UNIQUE DISTINCTIVE DIFFERENT DISTINCT UNIQUE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to remove rows from a table 'CUSTOMER' is: DROP FROM CUSTOMER ... UPDATE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... REMOVE FROM CUSTOMER ... DROP FROM CUSTOMER ... UPDATE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... REMOVE FROM CUSTOMER ... ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS