why we create view.
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 |
Q3. How will you fetch duplicate values from a DB2 table?
What is a db2 package?
select 100 records from million records ?
What are catalog tables in db2?
What is load replace in db2?
what needs to be done if a table is in copy pending / check pending status?
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
what is a corelated subquerry?
Explain the function done by data manager?
What is the clustering index in the db2 database?
What is a db2 table?