Introduction to SQL Which SQL statement is used to update data in a database? SAVE AS SAVE MODIFY UPDATE SAVE AS SAVE MODIFY UPDATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A dynamic view is one whose contents materialize when referenced. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement is enclosed in: CAPITAL LETTERS. braces -- {...}. brackets -- [...]. parenthesis -- (...) . CAPITAL LETTERS. braces -- {...}. brackets -- [...]. parenthesis -- (...) . 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, temperature FROM weather; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY city; SELECT city, temperature FROM weather; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city FROM weather ORDER BY temperature; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL WHERE clause: limits the row data are returned. Both A and B are correct. Neither A nor B are correct. limits the column data that are returned. limits the row data are returned. Both A and B are correct. Neither A nor B are correct. limits the column data that are returned. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command(s) is(are) used to change a table's storage characteristics? CHANGE TABLE MODIFY TABLE All of these ALTER TABLE CHANGE TABLE MODIFY TABLE All of these ALTER TABLE ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS