Introduction to SQL Which of the following is a SQL aggregate function? AVG LEN LEFT JOIN AVG LEN LEFT JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ORDER BY can be combined with the SELECT statements. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities whose humidity is 89 SELECT city FROM weather; SELECT city FROM weather WHERE humidity = 89; SELECT city WHERE humidity = 89; SELECT humidity = 89 FROM weather; SELECT city FROM weather; SELECT city FROM weather WHERE humidity = 89; SELECT city WHERE humidity = 89; SELECT humidity = 89 FROM weather; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? SUM All of these COUNT MAX SUM All of these COUNT MAX ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands can be used to add data to a database table? INSERT APPEND UPDATE ADD INSERT APPEND UPDATE ADD 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