Introduction to SQL Which of the following group functions ignore NULL values? All of these MAX SUM COUNT All of these MAX SUM COUNT 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
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
Introduction to SQL Which of the following must be enclosed in double quotes? Dates Column Alias Strings All of these Dates Column Alias Strings All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000? Both A and B None of these SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; SELECT name FROM staffinfo WHERE salary IN (10000, 25000); Both A and B None of these SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; SELECT name FROM staffinfo WHERE salary IN (10000, 25000); ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS