Introduction to SQL Which of the following group functions ignore NULL values? MAX COUNT All of these SUM MAX COUNT All of these SUM ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve only unique values? UNIQUE DIFFERENT DISTINCT DISTINCTIVE UNIQUE DIFFERENT DISTINCT DISTINCTIVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following do you need to consider when you make a table in SQL? All of these Primary keys Default values Data types All of these Primary keys Default values Data types ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL WHERE clause: Neither A nor B are correct. Both A and B are correct. limits the column data that are returned. limits the row data are returned. Neither A nor B are correct. Both A and B are correct. limits the column data that are returned. limits the row data are returned. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement. False True False True ANSWER DOWNLOAD EXAMIANS APP