Introduction to SQL The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs FLASE TRUE Nothing Hi FLASE TRUE Nothing Hi ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve a maximum value? MOST TOP UPPER MAX MOST TOP UPPER MAX ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The wildcard in a WHERE clause is useful when? An exact match is not possible in a CREATE statement. An exact match is necessary in a CREATE statement. An exact match is not possible in a SELECT statement. An exact match is necessary in a SELECT statement. An exact match is not possible in a CREATE statement. An exact match is necessary in a CREATE statement. An exact match is not possible in a SELECT statement. An exact match is necessary in a SELECT statement. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? EXISTS operator BETWEEN operator LIKE operator None of these EXISTS operator BETWEEN operator LIKE operator None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the name of all cities with their temperature, humidity and countries. 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; 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; ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS