Introduction to SQL Which SQL keyword is used to retrieve a maximum value? TOP UPPER MOST MAX TOP UPPER MOST MAX ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN. True False True False 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 To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. DISTINCT UNIQUE SINGLE ONLY DISTINCT UNIQUE SINGLE ONLY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of every SQL query is a table. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to sort the result-set? ORDER SORT BY ORDER BY SORT ORDER SORT BY ORDER BY SORT ANSWER DOWNLOAD EXAMIANS APP