Introduction to SQL The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement is enclosed in: braces -- {...}. parenthesis -- (...) . CAPITAL LETTERS. brackets -- [...]. braces -- {...}. parenthesis -- (...) . CAPITAL LETTERS. brackets -- [...]. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL can be used to: All of these create database structures only. query database data only. modify database data only. All of these create database structures only. query database data only. modify database data only. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve a maximum value? TOP MOST MAX UPPER TOP MOST MAX UPPER 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, temperature FROM weather; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY city; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY city; ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS