Multiple Choice
When an SQL SELECT statement is used to retrieve data from a view instance,the maximum number of columns that can be specified in the SELECT is the same as the number of columns ________.
A) in the table underlying the view
B) in the VIEW specification
C) in the ORDER BY clause
D) in the HAVING clause
E) that have aliases
Correct Answer:

Verified
Correct Answer:
Verified
Q44: Stored procedures have the advantage of greater
Q48: SQL views can be used to hide
Q49: Microsoft Access queries _.<br>A) can use previously
Q50: Because SQL stored procedures allow and encourage
Q51: SQL views are constructed from SQL _
Q54: Correlated subqueries do exactly the same type
Q55: What is not a reason to use
Q57: The LEFT and RIGHT keywords can be
Q58: The SQL statement DROP VIEW ViewName is
Q87: Because SQL stored procedures allow and encourage