Concepts and Architecture Question:
Download Job Interview Questions and Answers PDF
What are the advantages of Views in Oracle?
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.
Hide data complexity.
Simplify commands for the user.
Present the data in a different perspective from that of the base table.
Store complex queries.
Download Oracle Architecture and Concepts Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What are the type of Synonyms in Oracle? | What is a Public Synonyms in Oracle? |