Introduction to SQL Which SQL statement is used to delete data FROM a database? REMOVE DELETE COLLAPSE ALTER REMOVE DELETE COLLAPSE ALTER ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? SUM All of these MAX COUNT SUM All of these MAX COUNT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Count function in SQL returns the number of groups. values. distinct values. columns. groups. values. distinct values. columns. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands can be used to add data to a database table? ADD UPDATE INSERT APPEND ADD UPDATE INSERT APPEND 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 Which SQL statement is used to update data in a database? SAVE AS MODIFY SAVE UPDATE SAVE AS MODIFY SAVE UPDATE ANSWER DOWNLOAD EXAMIANS APP