Oracle%20Interview%20Questions%20and%20Answers

Question: What are the advantages of views?

Answer: - 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.