Introduction to SQL SUM, AVG, MIN, and MAX can only be used with numeric columns. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? All of these SUM MAX COUNT All of these SUM MAX COUNT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL can be used to: modify database data only. All of these create database structures only. query database data only. modify database data only. All of these create database structures only. query database data only. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the name of cities with all entries whose temperature is in the range of 71 and 89 SELECT * FROM weather WHERE temperature NOT IN (71 to 89); SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89; SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89; SELECT * FROM weather WHERE temperature NOT IN (71 and 89); SELECT * FROM weather WHERE temperature NOT IN (71 to 89); SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89; SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89; SELECT * FROM weather WHERE temperature NOT IN (71 and 89); ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS