Introduction to SQL Which of the following is a SQL aggregate function? LEFT LEN AVG JOIN LEFT LEN AVG JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The rows of the result relation produced by a SELECT statement can be sorted, but only by one column. True False True False 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 cannot be accessed via SQL commands A base table that can be accessed via SQL commands A virtual table that can be accessed via SQL commands A base table that cannot be accessed via SQL commands A virtual table that cannot be accessed via SQL commands A base table that can be accessed via SQL commands A virtual table that can be accessed via SQL commands ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To sort the results of a query use: ORDER BY. None of these SORT BY. GROUP BY. ORDER BY. None of these SORT BY. GROUP BY. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which one of the following sorts rows in SQL? GROUP BY ALIGN BY ORDER BY SORT BY GROUP BY ALIGN BY ORDER BY SORT BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value. True False True False ANSWER DOWNLOAD EXAMIANS APP