What are the advantages of views?
ORACLE Interview Questions and Answers (Part 1)
(Continued from previous question...)
32. What are the advantages of views?
- Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table.
- Hide data complexity.
- Simplify commands for the user.
- Present the data in a different perspective from that of the base table.
- Store complex queries.
(Continued on next question...)
Other Interview Questions