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 a Schema ?
How to convert characters to dates in oracle?
When do you get a .pll extension in oracle? Explain its importance
write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
what is insert all statement in sql
What is a proxy class?
When do we use group by clause in a sql query?
How do we get field detail of a table?
Explain the use of online redo log files in oracle.
What is system global area (sga) in oracle?
6. Display the client name and order date for all orders using the traditional method.
What is an oracle database?