Introduction to SQL The SQL -92 wildcards are ____ and ____ . asterisk (*); percent sign (%) underscore(_); question mark (?) percent sign (%); underscore (_) question mark (?); asterisk (*) asterisk (*); percent sign (%) underscore(_); question mark (?) percent sign (%); underscore (_) question mark (?); asterisk (*) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a valid SQL type? FLOAT All of these CHARACTER NUMERIC FLOAT All of these CHARACTER NUMERIC ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword(s) ________ is used with wildcards. LIKE only IN only IN and NOT IN NOT IN only LIKE only IN only IN and NOT IN NOT IN only ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement is enclosed in: parenthesis -- (...) . brackets -- [...]. CAPITAL LETTERS. braces -- {...}. parenthesis -- (...) . brackets -- [...]. CAPITAL LETTERS. braces -- {...}. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL WHERE clause: limits the column data that are returned. limits the row data are returned. Neither A nor B are correct. Both A and B are correct. limits the column data that are returned. limits the row data are returned. Neither A nor B are correct. Both A and B are correct. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS