Introduction to SQL A subquery in an SQL SELECT statement is enclosed in: brackets -- [...]. parenthesis -- (...) . braces -- {...}. CAPITAL LETTERS. brackets -- [...]. parenthesis -- (...) . braces -- {...}. CAPITAL LETTERS. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? ALTER COLLAPSE DELETE REMOVE ALTER COLLAPSE DELETE REMOVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities whose humidity is 89 SELECT city WHERE humidity = 89; SELECT humidity = 89 FROM weather; SELECT city FROM weather WHERE humidity = 89; SELECT city FROM weather; SELECT city WHERE humidity = 89; SELECT humidity = 89 FROM weather; SELECT city FROM weather WHERE humidity = 89; SELECT city FROM weather; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a ________ . file report form table file report form table ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions. False True False True ANSWER DOWNLOAD EXAMIANS APP