What is the procedure for assigning new names for the columns that are displayed by a view?
A) The new column names can be listed after the VIEW keyword, enclosed in parentheses.
B) Column aliases can be used in the subquery, and Oracle11g will use the aliases as column names in the view that is created.
C) all of the above
D) none of the above

Question

Quizplus · Accepted Answer

Both options A and B are correct. You can assign new column names by listing them after the VIEW keyword or by using column aliases in the subquery.

What Is the Procedure for Assigning New Names for the Columns