Introduction to SQL The Microsoft Access wildcards are ____ and ____ . question mark (?); asterisk (*) percent sign (%); underscore (_) underscore(_); question mark (?) asterisk (*); percent sign (%) question mark (?); asterisk (*) percent sign (%); underscore (_) underscore(_); question mark (?) asterisk (*); percent sign (%) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the temperature in increasing order of all cities SELECT city, temperature FROM weather ORDER BY city; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY city; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city FROM weather ORDER BY temperature; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement is enclosed in: CAPITAL LETTERS. parenthesis -- (...) . braces -- {...}. brackets -- [...]. CAPITAL LETTERS. parenthesis -- (...) . braces -- {...}. brackets -- [...]. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a ________ . table file report form table file report form ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To establish a range of values, < and > can be used. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS