Introduction to SQL COUNT(field_name) tallies only those rows that contain a value; it ignores all null values. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? All of these COUNT MAX SUM All of these COUNT MAX SUM ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? MODIFY SAVE UPDATE SAVE AS MODIFY SAVE UPDATE SAVE AS ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To sort the results of a query use: GROUP BY. SORT BY. None of these ORDER BY. GROUP BY. SORT BY. None of these ORDER BY. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is valid SQL for an Index? REMOVE INDEX ID; CREATE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; REMOVE INDEX ID; CREATE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL is: an operating system. a programming language. a data sublanguage. a DBMS. an operating system. a programming language. a data sublanguage. a DBMS. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS