Introduction to SQL Find all the cities whose humidity is 89 SELECT city FROM weather WHERE humidity = 89; SELECT city FROM weather; SELECT city WHERE humidity = 89; SELECT humidity = 89 FROM weather; SELECT city FROM weather WHERE humidity = 89; SELECT city FROM weather; SELECT city WHERE humidity = 89; SELECT humidity = 89 FROM weather; 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 A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? All of these MAX COUNT SUM All of these MAX COUNT SUM ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL There is an equivalent join expression that can be substituted for all subquery expressions. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL can be used to: All of these create database structures only. query database data only. modify database data only. All of these create database structures only. query database data only. modify database data only. ANSWER DOWNLOAD EXAMIANS APP