Introduction to SQL Which of the following is a SQL aggregate function? LEFT JOIN LEN AVG LEFT JOIN LEN AVG ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The keyword BETWEEN can be used in a WHERE clause to refer to a range of values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The condition in a WHERE clause can refer to only one value. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? SUM COUNT MAX All of these SUM COUNT MAX All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is illegal? SELECT SYSDATE - SYSDATE FROM DUAL; None of these SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL; None of these SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS