Introduction to SQL Which one of the following sorts rows in SQL? ALIGN BY GROUP BY SORT BY ORDER BY ALIGN BY GROUP BY SORT BY ORDER BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT ROUND(45.926, -1) FROM DUAL; prints garbage is illegal prints 50 prints 045.926 prints garbage is illegal prints 50 prints 045.926 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The HAVING clause does which of the following? Acts like a WHERE clause but is used for columns rather than groups. Acts like a WHERE clause but is used for groups rather than rows. Acts like a WHERE clause but is used for rows rather than columns. Acts EXACTLY like a WHERE clause. Acts like a WHERE clause but is used for columns rather than groups. Acts like a WHERE clause but is used for groups rather than rows. Acts like a WHERE clause but is used for rows rather than columns. Acts EXACTLY like a WHERE clause. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following join is also called as an 'inner-join'? Self-Join None of these Equijoin Non-Equijoin Self-Join None of these Equijoin Non-Equijoin 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. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS