Interested to Buy Any Domain ? << Click Here >> for more details...
Define 'view' advantage ?
- 2 Answers
- 11652 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 |
How to apply filtering criteria at group level in oracle?
What is not equal to in oracle?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3
Can a field be used in a report without it appearing in any data group ?
Who developed oracle & when?
Give the various exception types.
how to get count of tables in particular database in Oracle?
What is a cursor and what are the steps need to be taken?
types of indexes and the rationale behind choosing a particular index for a situation.
What are the ansi data types supported in oracle?
Oracle General 
