Introduction to SQL The FROM SQL clause is used to... None of these specify range for search condition specify search condition specify what table we are selecting or deleting data FROM None of these specify range for search condition specify search condition specify what table we are selecting or deleting data FROM ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the name of cities with all entries whose temperature is in the range of 71 and 89 SELECT * FROM weather WHERE temperature NOT IN (71 and 89); SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89; SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89; SELECT * FROM weather WHERE temperature NOT IN (71 to 89); SELECT * FROM weather WHERE temperature NOT IN (71 and 89); SELECT * FROM weather WHERE temperature BETWEEN 71 AND 89; SELECT * FROM weather WHERE temperature NOT BETWEEN 71 to 89; SELECT * FROM weather WHERE temperature NOT IN (71 to 89); ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities whose humidity is 89 SELECT city FROM weather WHERE humidity = 89; SELECT city FROM weather; SELECT humidity = 89 FROM weather; SELECT city WHERE humidity = 89; SELECT city FROM weather WHERE humidity = 89; SELECT city FROM weather; SELECT humidity = 89 FROM weather; SELECT city WHERE humidity = 89; 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 SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query is correct for using comparison operators in SQL? SELECT name, course_name FROM student WHERE age>50 and WHERE age<80; None of these SELECT name, course_name FROM student WHERE age>50 and age <80; SELECT name, course_name FROM student WHERE age>50 and <80; SELECT name, course_name FROM student WHERE age>50 and WHERE age<80; None of these SELECT name, course_name FROM student WHERE age>50 and age <80; SELECT name, course_name FROM student WHERE age>50 and <80; ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS