Introduction to SQL The SQL WHERE clause: limits the row data are returned. limits the column data that are returned. Both A and B are correct. Neither A nor B are correct. limits the row data are returned. limits the column data that are returned. Both A and B are correct. Neither A nor B are correct. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query finds the names of the sailors who have reserved at least one boat? SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; None of These SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid; None of These SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword BETWEEN is used: to limit the columns displayed. None of these for ranges. as a wildcard. to limit the columns displayed. None of these for ranges. as a wildcard. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL -92 wildcards are ____ and ____ . asterisk (*); percent sign (%) percent sign (%); underscore (_) underscore(_); question mark (?) question mark (?); asterisk (*) asterisk (*); percent sign (%) percent sign (%); underscore (_) underscore(_); question mark (?) question mark (?); asterisk (*) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a(n) ________ . file form table report file form table report ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL is a programming language. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS