Introduction to SQL Which of the following are the five built-in functions provided by SQL? SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, NAME SUM, AVG, MIN, MAX, MULT COUNT, SUM, AVG, MAX, MIN SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, NAME SUM, AVG, MIN, MAX, MULT COUNT, SUM, AVG, MAX, MIN 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 of the following is the correct order of keywords for SQL SELECT statements? FROM, WHERE, SELECT SELECT, FROM, WHERE SELECT,WHERE,FROM WHERE, FROM,SELECT FROM, WHERE, SELECT SELECT, FROM, WHERE SELECT,WHERE,FROM WHERE, FROM,SELECT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword(s) ________ is used with wildcards. IN only LIKE only IN and NOT IN NOT IN only IN only LIKE only IN and NOT IN NOT IN only ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which one of the following sorts rows in SQL? SORT BY GROUP BY ALIGN BY ORDER BY SORT BY GROUP BY ALIGN BY ORDER BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement: has a distinct form that cannot be duplicated by a join. can always be duplicated by a join. cannot have its results sorted using ORDER BY. can only be used with two tables. has a distinct form that cannot be duplicated by a join. can always be duplicated by a join. cannot have its results sorted using ORDER BY. can only be used with two tables. ANSWER DOWNLOAD EXAMIANS APP