Introduction to SQL Which of the following is the correct order of keywords for SQL SELECT statements? FROM, WHERE, SELECT WHERE, FROM,SELECT SELECT, FROM, WHERE SELECT,WHERE,FROM FROM, WHERE, SELECT WHERE, FROM,SELECT SELECT, FROM, WHERE SELECT,WHERE,FROM ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is valid SQL for an Index? ADD INDEX ID; CHANGE INDEX ID; CREATE INDEX ID; REMOVE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; CREATE INDEX ID; REMOVE INDEX ID; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities whose humidity is 89 SELECT city WHERE humidity = 89; SELECT city FROM weather; SELECT humidity = 89 FROM weather; SELECT city FROM weather WHERE humidity = 89; SELECT city WHERE humidity = 89; SELECT city FROM weather; SELECT humidity = 89 FROM weather; SELECT city FROM weather WHERE humidity = 89; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following are the five built-in functions provided by SQL? SUM, AVG, MULT, DIV, MIN COUNT, SUM, AVG, MAX, MIN SUM, AVG, MIN, MAX, NAME SUM, AVG, MIN, MAX, MULT SUM, AVG, MULT, DIV, MIN COUNT, SUM, AVG, MAX, MIN SUM, AVG, MIN, MAX, NAME SUM, AVG, MIN, MAX, MULT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The ADD command is used to enter one row of data or to add multiple rows as a result of a query. 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 IN (71 and 89); SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 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 IN (71 and 89); SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89; ANSWER DOWNLOAD EXAMIANS APP