Introduction to SQL Which of the following group functions ignore NULL values? All of these MAX SUM COUNT All of these MAX SUM COUNT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? TRUNCATE DELETE ROLLBACK COMMIT TRUNCATE DELETE ROLLBACK COMMIT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy'); SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy'); SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy'); SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy'); SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy'); SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy'); SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy'); SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy'); ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? SAVE UPDATE MODIFY SAVE AS SAVE UPDATE MODIFY SAVE AS ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The ADD command is used to enter one row of data or to add multiple rows as a result of a query. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve a maximum value? MAX MOST TOP UPPER MAX MOST TOP UPPER ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS