Introduction to SQL Which SQL statement is used to delete data FROM a database? COLLAPSE REMOVE DELETE ALTER COLLAPSE REMOVE DELETE ALTER ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command is used to change a table's storage characteristics? MODIFY TABLE CHANGE TABLE ALTER TABLE None of these MODIFY TABLE CHANGE TABLE ALTER TABLE None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL You can add a row using SQL in a database with which of the following? INSERT ADD CREATE MAKE INSERT ADD CREATE MAKE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement is enclosed in: brackets -- [...]. parenthesis -- (...) . CAPITAL LETTERS. braces -- {...}. brackets -- [...]. parenthesis -- (...) . CAPITAL LETTERS. braces -- {...}. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the temperature in increasing order of all cities SELECT city, temperature FROM weather ORDER BY city; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city, temperature FROM weather ORDER BY city; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS