Introduction to SQL Which one of the following sorts rows in SQL? GROUP BY ALIGN BY SORT BY ORDER BY GROUP BY ALIGN BY SORT BY ORDER BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is valid SQL for an Index? ADD INDEX ID; CHANGE INDEX ID; CREATE INDEX ID; REMOVE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; CREATE INDEX ID; REMOVE INDEX ID; 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 The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs Nothing Hi TRUE FLASE Nothing Hi TRUE FLASE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The benefits of a standard relational language include which of the following? Applications are not needed Reduced training costs All of these Increased dependence on a single vendor Applications are not needed Reduced training costs All of these Increased dependence on a single vendor ANSWER DOWNLOAD EXAMIANS APP
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, MIN, MAX, MULT 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 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS