DEVFYI - Developer Resource - FYI

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