What are the advantages of Views ?
- 3 Answers
- 9426 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
The advantages of views are
1)Data abstraction
2)Simple retrieving of data.
| Is This Answer Correct ? | 16 Yes | 3 No |
Answer / nishi
- 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 This Answer Correct ? | 0 Yes | 0 No |
Answer / ven
secutiry of the data for ex: in bank domain some of the
columns data don't want to see others then we can restrict
the columns and create views and share the columns
whichever others can see.
| Is This Answer Correct ? | 2 Yes | 3 No |
What are transaction isolation levels supported by oracle?
What is different types of joins?
19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.
Explain the concept of the DUAL table.
What is an Index Segment ?
how to create a new database in oracle?
What are advantages fo Stored Procedures?
How to turn on or off recycle bin for the instance?
How to create a new table by selecting rows from another table?
what is the exact diiference between DBMS and RDBMS
What is raw datatype?
State the various uses of dbcc command?
Oracle General 
