Introduction to SQL COUNT(field_name) tallies only those rows that contain a value; it ignores all null values. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement is enclosed in: parenthesis -- (...) . braces -- {...}. CAPITAL LETTERS. brackets -- [...]. parenthesis -- (...) . braces -- {...}. CAPITAL LETTERS. brackets -- [...]. 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 statementSELECT ROUND(45.926, -1) FROM DUAL; prints 50 prints 045.926 prints garbage is illegal prints 50 prints 045.926 prints garbage is illegal ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? All of these MAX COUNT SUM All of these MAX COUNT SUM ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ORDER BY can be combined with the SELECT statements. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS