Introduction to SQL There is an equivalent join expression that can be substituted for all subquery expressions. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a(n) ________ . file table form report file table form report ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. ONLY SINGLE UNIQUE DISTINCT ONLY SINGLE UNIQUE DISTINCT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which one of the following sorts rows in SQL? GROUP BY ORDER BY ALIGN BY SORT BY GROUP BY ORDER BY ALIGN BY SORT BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A view is which of the following? 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 A base table that cannot be accessed via SQL commands ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. False True False True ANSWER DOWNLOAD EXAMIANS APP