Define 'view' advantage ?
- 2 Answers
- 10789 Views
- AZTEC, TCS, I also Faced
- E-Mail Answers
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 |
Write a simple Store procedure and pass parameter to it ?
What happens if you use a wrong connect identifier?
When do I need to use a semicolon vs a slash in oracle sql?
How to define an external table with a text file?
How to find no of saturdays in a month using single sql ?
what is the syntax of INSERT command?
What is the difference between Delete, Truncate and Drop in Oracle?
which language is used to develop the oracle........?
Explain the use of indexes option in imp command.
Compare and contrast between sql and sql server and explain its various functions?
How to loop through data rows in the implicit cursor?
Explain the use of ignore option in imp command.
Oracle General 
