Introduction to SQL Which SQL statement is used to delete data FROM a database? REMOVE COLLAPSE ALTER DELETE REMOVE COLLAPSE ALTER DELETE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a(n) ________ . table report file form table report file form 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. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ________ was adopted as a national standard by ANSI in 1992. DBase SQL Oracle Microsoft Access DBase SQL Oracle Microsoft Access ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the temperature in increasing order of all cities SELECT city, temperature FROM weather; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY city; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY city; SELECT city FROM weather ORDER BY temperature; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS