Introduction to SQL The command to remove rows from a table 'CUSTOMER' is: UPDATE FROM CUSTOMER ... REMOVE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... DROP FROM CUSTOMER ... UPDATE FROM CUSTOMER ... REMOVE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... DROP FROM CUSTOMER ... ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the cities whose humidity is 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; SELECT city FROM weather WHERE humidity = 89; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL NULL is the same as 0 for integer and blank for character the same as 0 for integer not a value the same as blank for character the same as 0 for integer and blank for character the same as 0 for integer not a value the same as blank for character ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command(s) is(are) used to change a table's storage characteristics? ALTER TABLE CHANGE TABLE MODIFY TABLE All of these ALTER TABLE CHANGE TABLE MODIFY TABLE All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a SQL aggregate function? AVG LEFT JOIN LEN AVG LEFT JOIN LEN ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS