Interested to Buy Any Domain ? << Click Here >> for more details...
Define 'view' advantage ?
- 2 Answers
- 11659 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 |
What are the components of physical database structure in the Oracle database?
Explain the difference between a procedure and a function?
Give the advantages and disadvantages of clusters.
Explain the use of inctype option in exp command.
How to list all indexes in your schema?
what is the output of select * from emp where null=null & select * from emp where 1=1
What is a Redo Log ?
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
What are the numeric comparison operations?
What are the predefined tablespaces in a database?
does the query needs a hint to access a materialized view?
What is the minimum client footprint required to connect c# to an oracle database?
Oracle General 
