Introduction to SQL In SQL, which command is used to change a table's storage characteristics? MODIFY TABLE None of these ALTER TABLE CHANGE TABLE MODIFY TABLE None of these ALTER TABLE CHANGE TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes may be created or dropped at any time. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities whose humidity is 89 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; SELECT city FROM weather WHERE humidity = 89; SELECT city WHERE humidity = 89; SELECT city FROM weather; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The FROM SQL clause is used to... specify range for search condition specify search condition None of these specify what table we are selecting or deleting data FROM specify range for search condition specify search condition None of these specify what table we are selecting or deleting data FROM ANSWER DOWNLOAD EXAMIANS APP