why we create view.

Answer Posted / om yadav

the reasons why view are created are:
1. When data security is required.
2. When data redundancy is to be kept to the minimum while
maintaining data security.

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is schema the same as database?

627


Why cursor is used in db2?

572


What is an instance in db2?

563


Who uses db2?

573


Is db2 a database?

572






Why db2 is called db2?

589


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

1801


What is package in cobol db2?

700


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

1818


What is drop table?

582


If I have a view which is a join of two or more tables, can this view be updateable?

688


What is blu acceleration in db2?

603


What is difference between isnull and coalesce?

618


What is the information associated with sysibm.syslinks table?

657


Explain in detail about buffer manager and its functionalities?

562