Introduction to SQL In SQL, which command is used to change a table's storage characteristics? ALTER TABLE None of these CHANGE TABLE MODIFY TABLE ALTER TABLE None of these CHANGE TABLE MODIFY TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes can usually be created for both primary and secondary keys. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL COUNT(field_name) tallies only those rows that contain a value; it ignores all null values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities whose humidity is 89 SELECT humidity = 89 FROM weather; SELECT city WHERE humidity = 89; SELECT city FROM weather; SELECT city FROM weather WHERE humidity = 89; SELECT humidity = 89 FROM weather; SELECT city WHERE humidity = 89; SELECT city FROM weather; SELECT city FROM weather WHERE humidity = 89; 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 Which SQL statement is used to update data in a database? UPDATE SAVE MODIFY SAVE AS UPDATE SAVE MODIFY SAVE AS ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS