Introduction to SQL Which SQL keyword is used to sort the result-set? ORDER SORT ORDER BY SORT BY ORDER SORT ORDER BY SORT BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? ROLLBACK DELETE COMMIT TRUNCATE ROLLBACK DELETE COMMIT TRUNCATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. False True False True 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
Introduction to SQL To establish a range of values, < and > can be used. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What operator tests column for the absence of data? NOT operator EXISTS operator IS NULL operator None of these NOT operator EXISTS operator IS NULL operator None of these ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS