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

Question

Quizplus · Accepted Answer

The maximum number of columns that can be specified in the SELECT statement when retrieving data from a view instance is determined by the number of columns defined in the VIEW specification itself. The view acts as a virtual table composed of the columns specified when the view was created.

When an SQL SELECT Statement Is Used to Retrieve Data