Introduction to SQL Find all the cities whose humidity is 89 SELECT city FROM weather WHERE humidity = 89; SELECT city WHERE humidity = 89; SELECT city FROM weather; SELECT humidity = 89 FROM weather; SELECT city FROM weather WHERE humidity = 89; SELECT city WHERE humidity = 89; SELECT city FROM weather; SELECT humidity = 89 FROM weather; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL NULL is the same as 0 for integer the same as blank for character the same as 0 for integer and blank for character not a value the same as 0 for integer the same as blank for character the same as 0 for integer and blank for character not a value ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? ALTER DELETE REMOVE COLLAPSE ALTER DELETE REMOVE COLLAPSE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a SQL aggregate function? AVG LEFT LEN JOIN AVG LEFT LEN JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000? None of these Both A and B SELECT name FROM staffinfo WHERE salary IN (10000, 25000); SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; None of these Both A and B SELECT name FROM staffinfo WHERE salary IN (10000, 25000); SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS