Introduction to SQL Which one of the following sorts rows in SQL? GROUP BY ALIGN BY SORT BY ORDER BY GROUP BY ALIGN BY SORT BY ORDER BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? TRUNCATE ROLLBACK DELETE COMMIT TRUNCATE ROLLBACK DELETE COMMIT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL query and modification commands make up a(n) ________ . XML DDL HTML DML XML DDL HTML DML ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes can usually be created for both primary and secondary keys. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement that queries or reads data from a table is ________ . None of these SELECT READ QUERY None of these SELECT READ QUERY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the name of all cities with their temperature, humidity and countries. SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city; SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city; SELECT weather.city, temperature, humidity, country FROM weather, location; SELECT city, temperature, humidity, country FROM location; SELECT weather.city, temperature, humidity FROM weather SELECT country FROM location WHERE weather.city = location.city; SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city; SELECT weather.city, temperature, humidity, country FROM weather, location; SELECT city, temperature, humidity, country FROM location; ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS