Introduction to SQL Which of the following must be enclosed in double quotes? Strings Column Alias All of these Dates Strings Column Alias All of these Dates ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the temperature in increasing order of all cities SELECT city, temperature FROM weather ORDER BY temperature; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city, temperature FROM weather ORDER BY city; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city, temperature FROM weather ORDER BY city; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A view is which of the following? A base table that can be accessed via SQL commands A base table that cannot be accessed via SQL commands A virtual table that cannot be accessed via SQL commands A virtual table that can be accessed via SQL commands A base table that can be accessed via SQL commands A base table that cannot be accessed via SQL commands A virtual table that cannot be accessed via SQL commands A virtual table that can be accessed via SQL commands 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 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); SELECT * FROM weather WHERE temperature NOT IN (71 to 89); ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To sort the results of a query use: ORDER BY. None of these SORT BY. GROUP BY. ORDER BY. None of these SORT BY. GROUP BY. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The HAVING clause does which of the following? Acts like a WHERE clause but is used for columns rather than groups. Acts like a WHERE clause but is used for rows rather than columns. Acts EXACTLY like a WHERE clause. Acts like a WHERE clause but is used for groups rather than rows. Acts like a WHERE clause but is used for columns rather than groups. Acts like a WHERE clause but is used for rows rather than columns. Acts EXACTLY like a WHERE clause. Acts like a WHERE clause but is used for groups rather than rows. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS