Oracle Interview Questions and Answers
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. |
Is it helpful?
Yes
No
Most helpful rated by users:
- What are the components of physical database structure of Oracle database?
- What are the components of logical database structure of Oracle database?
- What is a tablespace?
- What is SYSTEM tablespace and when is it created?
- Explain the relationship among database, tablespace and data file?