Introduction to SQL The SQL keyword(s) ________ is used with wildcards. IN only NOT IN only LIKE only IN and NOT IN IN only NOT IN only LIKE only IN and NOT IN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return exactly 10 rows less than 10 rows more than 10 rows None of these exactly 10 rows less than 10 rows more than 10 rows None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL -92 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 A view is which of the following? A base table that cannot be accessed via SQL commands A virtual table that can be accessed via SQL commands A base table that can be accessed via SQL commands A virtual table that cannot be accessed via SQL commands A base table that cannot be accessed via SQL commands A virtual table that can be accessed via SQL commands A base table that can be accessed via SQL commands A virtual table that cannot be accessed via SQL commands ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to sort the result-set? SORT ORDER ORDER BY SORT BY SORT ORDER ORDER BY SORT BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a ________ . report form table file report form table file ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS