Introduction to SQL Which of the following is valid SQL for an Index? CREATE INDEX ID; REMOVE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; CREATE INDEX ID; REMOVE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which one of the following sorts rows in SQL? ALIGN BY SORT BY ORDER BY GROUP BY ALIGN BY SORT BY ORDER BY GROUP BY ANSWER DOWNLOAD EXAMIANS APP
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 COUNT, SUM, AVG, MAX, MIN SUM, AVG, MIN, MAX, MULT SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, NAME COUNT, SUM, AVG, MAX, MIN SUM, AVG, MIN, MAX, MULT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL If a query involves NOT, AND, OR with no parenthesis NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. The order of occurrence determines the order of evaluation. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. The order of occurrence determines the order of evaluation. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. 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. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS