Introduction to SQL The keyword LIKE can be used in a WHERE clause to refer to a range of values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement that queries or reads data from a table is ________ . QUERY SELECT None of these READ QUERY SELECT None of these READ ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following must be enclosed in double quotes? Strings Dates All of these Column Alias Strings Dates All of these Column Alias ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes can usually be created for both primary and secondary keys. 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, country FROM weather, location; 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 FROM weather SELECT country FROM location WHERE weather.city = location.city; SELECT weather.city, temperature, humidity, country FROM weather, location; 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 FROM weather SELECT country FROM location WHERE weather.city = location.city; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL -92 wildcards are ____ and ____ . asterisk (*); percent sign (%) question mark (?); asterisk (*) underscore(_); question mark (?) percent sign (%); underscore (_) asterisk (*); percent sign (%) question mark (?); asterisk (*) underscore(_); question mark (?) percent sign (%); underscore (_) ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS