Interested to Buy Any Domain ? << Click Here >> for more details...
why we create view.
- 5 Answers
- 10153 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / as
I know a senario in which views are created.
Suppose I have a field in my table which is secure and
should not be visible to everyone. In that case i can
create a view without that field and keep the table acces
(even browse) with a particular set of people.
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / wazid noor mohammed
sometimes u have to write complex queries.
for this query u can give one name.
For to give that name we use view concept.
after defining the view with the particular name to the
complex query.
Next time ,we can execute that query by simply calling the
view name of that query
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / om prakash yadav
Provide the Security and see the part of data.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / vinay
to ristrict the full access of table data... to users or
group of users
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / 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 |
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
What is blu acceleration in db2?
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
What is a trigger in the db2 database?
What is an intent lock?
pls tell me abt the normalization five types....
how to get duplicate records from tables?write qurey for this?
Why db2 is called db2?
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
What can the SET option of the Repair Utility accomplish?
What is the physical storage length of date data type?
how we will do null data selection in cobol-db2 program
COBOL 
