Introduction to SQL Which of the following is a SQL aggregate function? LEFT JOIN LEN AVG LEFT JOIN LEN AVG ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is the full form of SQL? Simple Query Language Structured Query List None of these Structured Query Language Simple Query Language Structured Query List None of these Structured Query Language ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve only unique values? UNIQUE DIFFERENT DISTINCT DISTINCTIVE UNIQUE DIFFERENT DISTINCT DISTINCTIVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following join is also called as an 'inner-join'? None of these Equijoin Self-Join Non-Equijoin None of these Equijoin Self-Join Non-Equijoin ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ............. joins two or more tables based on a specified column value not equaling a specified column value in another table. NATURAL JOIN EQUIJOIN OUTER JOIN NON-EQUIJOIN NATURAL JOIN EQUIJOIN OUTER JOIN NON-EQUIJOIN 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 city, temperature, humidity, country FROM location; SELECT weather.city, temperature, humidity, country FROM weather, location WHERE weather.city = location.city; 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 city, temperature, humidity, country FROM location; 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