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 in the table underlying the view.

Question

Quizplus · Accepted Answer

This statement is false. The maximum number of columns that can be specified in the SELECT statement is not limited by the number of columns in the underlying table. The SELECT statement can retrieve a subset of the columns from the view, or it can include additional columns that are derived from expressions or functions. However, the view must include all of the columns that are referenced in the SELECT statement.

When an SQL SELECT Statement Is Used to Retrieve Data