Introduction to SQL The SQL keyword(s) ________ is used with wildcards. IN and NOT IN NOT IN only IN only LIKE only IN and NOT IN NOT IN only IN only LIKE only ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The Microsoft Access wildcards are ____ and ____ . underscore(_); question mark (?) question mark (?); asterisk (*) percent sign (%); underscore (_) asterisk (*); percent sign (%) underscore(_); question mark (?) question mark (?); asterisk (*) percent sign (%); underscore (_) asterisk (*); percent sign (%) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. SINGLE ONLY DISTINCT UNIQUE SINGLE ONLY DISTINCT UNIQUE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword BETWEEN is used: for ranges. as a wildcard. None of these to limit the columns displayed. for ranges. as a wildcard. None of these to limit the columns displayed. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a valid SQL type? FLOAT All of these NUMERIC CHARACTER FLOAT All of these NUMERIC CHARACTER 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 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, reserves r, sailors s WHERE s.sname = 'Dustin' AND r.bid = b.bid 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 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, reserves r, sailors s WHERE s.sname = 'Dustin' AND r.bid = b.bid SELECT DISTINCT b.color FROM boats b, sailors s WHERE s.sname = 'Dustin' AND s.sid = b.sid ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS