Introduction to SQL Which of the following are the five built-in functions provided by SQL? SUM, AVG, MIN, MAX, NAME COUNT, SUM, AVG, MAX, MIN SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, MULT SUM, AVG, MIN, MAX, NAME COUNT, SUM, AVG, MAX, MIN SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, MULT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement is enclosed in: brackets -- [...]. parenthesis -- (...) . braces -- {...}. CAPITAL LETTERS. brackets -- [...]. parenthesis -- (...) . braces -- {...}. CAPITAL LETTERS. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve only unique values? DIFFERENT UNIQUE DISTINCTIVE DISTINCT DIFFERENT UNIQUE DISTINCTIVE DISTINCT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ORDER BY can be combined with the SELECT statements. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which of the following is not a data definition language commands? REVOKE RENAME UPDATE GRANT REVOKE RENAME UPDATE GRANT ANSWER DOWNLOAD EXAMIANS APP