Introduction to SQL Which SQL keyword is used to sort the result-set? ORDER SORT ORDER BY SORT BY ORDER SORT ORDER BY SORT BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement that queries or reads data from a table is ________ . None of these READ SELECT QUERY None of these READ SELECT QUERY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The HAVING clause does which of the following? Acts like a WHERE clause but is used for rows rather than columns. Acts like a WHERE clause but is used for groups rather than rows. Acts like a WHERE clause but is used for columns rather than groups. Acts EXACTLY like a WHERE clause. Acts like a WHERE clause but is used for rows rather than columns. Acts like a WHERE clause but is used for groups rather than rows. Acts like a WHERE clause but is used for columns rather than groups. Acts EXACTLY like a WHERE clause. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? None of these BETWEEN operator LIKE operator EXISTS operator None of these BETWEEN operator LIKE operator EXISTS operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a SQL aggregate function? LEN LEFT AVG JOIN LEN LEFT AVG JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A view is which of the following? A base table that cannot be accessed via SQL commands A virtual table that can be accessed via SQL commands A base table that can be accessed via SQL commands A virtual table that cannot be accessed via SQL commands A base table that cannot be accessed via SQL commands A virtual table that can be accessed via SQL commands A base table that can be accessed via SQL commands A virtual table that cannot be accessed via SQL commands ANSWER DOWNLOAD EXAMIANS APP