Introduction to SQL SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN. False True False True ANSWER DOWNLOAD EXAMIANS APP
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 The benefits of a standard relational language include which of the following? Applications are not needed All of these Increased dependence on a single vendor Reduced training costs Applications are not needed All of these Increased dependence on a single vendor Reduced training costs ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions. False True False True 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 The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters." False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS