Introduction to SQL The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79 SELECT * FROM weather WHERE humidity IN (63 to 79) SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79 SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79 SELECT * FROM weather WHERE humidity NOT IN (63 AND 79) SELECT * FROM weather WHERE humidity IN (63 to 79) SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79 SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79 SELECT * FROM weather WHERE humidity NOT IN (63 AND 79) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities whose humidity is 89 SELECT city FROM weather WHERE humidity = 89; SELECT humidity = 89 FROM weather; SELECT city WHERE humidity = 89; SELECT city FROM weather; SELECT city FROM weather WHERE humidity = 89; SELECT humidity = 89 FROM weather; SELECT city WHERE humidity = 89; SELECT city FROM weather; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? LIKE operator None of these EXISTS operator BETWEEN operator LIKE operator None of these EXISTS operator BETWEEN operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following do you need to consider when you make a table in SQL? Primary keys Data types Default values All of these Primary keys Data types Default values All of these 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
EXAMIANS