Introduction to SQL Most companies keep at least two versions of any database they are using. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators. 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 city, temperature, humidity, country FROM location; SELECT weather.city, temperature, humidity, country FROM weather, 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 city, temperature, humidity, country FROM location; SELECT weather.city, temperature, humidity, country FROM weather, location; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ON UPDATE CASCADE ensures which of the following? Materialized Views Normalization Data Integrity All of these Materialized Views Normalization Data Integrity All of these 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 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; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? SUM MAX COUNT All of these SUM MAX COUNT All of these ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS