Which of the following is not a limitation of view?
(a) ORDER BY Does Not Work
(b) Index Created on View Used Often
(c) Cross Database Queries Not Allowed in Indexed View
(d) Adding Column is Expensive by Joining Table Outside View
The question was asked in an online interview.
The origin of the question is Views in portion Laying the Foundation of SQL Server