Introduction to SQL Find all the cities whose humidity is 89 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; SELECT city WHERE humidity = 89; SELECT city FROM weather; SELECT humidity = 89 FROM weather; 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 virtual table that can be accessed via SQL commands A virtual table that cannot be accessed via SQL commands A base table that cannot be accessed via SQL commands A base table that can be accessed via SQL commands A virtual table that can be accessed via SQL commands A virtual table that cannot be accessed via SQL commands A base table that cannot be accessed via SQL commands ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return exactly 10 rows more than 10 rows None of these less than 10 rows exactly 10 rows more than 10 rows None of these less than 10 rows ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The keyword LIKE can be used in a WHERE clause to refer to a range of values. True False True False ANSWER DOWNLOAD EXAMIANS APP
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 Count function in SQL returns the number of columns. values. groups. distinct values. columns. values. groups. distinct values. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS