Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / om yadav
after a table is created and populated with data, it may
become necessary to prevent all users from accessing all
column of a table, for data security reasons.
To reduce redundant data to the minimum possible, allows the
creation of an object called VIEW.
Define:= A VIEW is mapped , to a select sentence. The SELECT
clause consists of a sub-set of the columnb of the table.
thus a view , which is mapped to a table, will in effect
have a sub-set of the actual column of the table from which
it is bulit.
This technique offers a simple, effective way of hiding
column of the table.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain packages.
What is clone table?
what is the role of the cursor in db2?
What is consistency token in db2?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is the use of value function?
What is copy pending and check pending in db2?
What is db2 stogroup?
What is sqlca’s maximum length?
Give the name of some fields form sqlca.
How do you stop a db2 database in linux?
Define predicate?
How to test SQL -911 error while developing COB-DB2 program
What is dbrm? What it contains?
What is reorg and runstats in db2?
