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 In SQL, which command(s) is(are) used to change a table's storage characteristics? ALTER TABLE MODIFY TABLE All of these CHANGE TABLE ALTER TABLE MODIFY TABLE All of these CHANGE TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To sort the results of a query use: GROUP BY. None of these ORDER BY. SORT BY. GROUP BY. None of these ORDER BY. SORT BY. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands is used to retrieve data? SELECT DELETE INSERT JOIN SELECT DELETE INSERT JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ON UPDATE CASCADE ensures which of the following? Data Integrity All of these Normalization Materialized Views Data Integrity All of these Normalization Materialized Views ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS