Define 'view' advantage ?
Answers were Sorted based on User's Feedback
Answer / o.nagamani
View is a virtual storage of the original table.It is the
one kind of data hiding.
Advantages of View:
1. Restrict Data Access and/or simplify data access.
2. Simplify Data manipulation.
3. Import and Export data.
4. Merge Data.
| Is This Answer Correct ? | 12 Yes | 3 No |
Answer / deva
view is the window for the data stored in the table(s). It
is the pointer to the data, will not store any data with in it.
more secure to the unauthorized data.
Time complexity reduces when we are accessing the data.
| Is This Answer Correct ? | 4 Yes | 1 No |
what is the syntax of DROP command?
What is currency type in database ?
Why do we need oracle client?
What is a materialised view?
What is a Shared SQL pool ?
Whether Oracle satisfy more codd rules or db2 satisfy more codd rules? How meny of each can satisfy ? Please answer me. Advance thanks
Point out the difference between user tables and data dictionary?
Can you drop an index associated with a unique or primary key constraint?
What is Undo Management Advisor in Oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are the restrictions on external table columns?
What is difference between a formal and an actual parameter?