Introduction to SQL The SQL -92 wildcards are ____ and ____ . question mark (?); asterisk (*) underscore(_); question mark (?) percent sign (%); underscore (_) asterisk (*); percent sign (%) question mark (?); asterisk (*) underscore(_); question mark (?) percent sign (%); underscore (_) asterisk (*); percent sign (%) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Count function in SQL returns the number of columns. groups. values. distinct values. columns. groups. values. distinct values. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL COUNT(field_name) tallies only those rows that contain a value; it ignores all null values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);prints 5 10 9 0 5 10 9 0 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following do you need to consider when you make a table in SQL? All of these Data types Primary keys Default values All of these Data types Primary keys Default values ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The keyword BETWEEN can be used in a WHERE clause to refer to a range of values. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS