Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages of Views ?
- 3 Answers
- 10299 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
The advantages of views are
1)Data abstraction
2)Simple retrieving of data.
| Is This Answer Correct ? | 16 Yes | 3 No |
Answer / nishi
- Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table.
- Hide data complexity.
- Simplify commands for the user.
- Present the data in a different perspective from that of the base table.
- Store complex queries.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ven
secutiry of the data for ex: in bank domain some of the
columns data don't want to see others then we can restrict
the columns and create views and share the columns
whichever others can see.
| Is This Answer Correct ? | 2 Yes | 3 No |
How to use subqueries with the exists operator in oracle?
Explain mutating triggers.
How do we get field detail of a table?
How many memory layers are in the oracle shared pool?
Explain the use of control file?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
Differentiate between pre-select and pre-query?
Explain an index segment?
What is system tablespace?
What is a trace file and how is it created in oracle?
Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)
what is RAID technology?which is better RAID 0+1 OR RAID 5?
Oracle General 
