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
What is data manager?
What is db2 optimizer?
What is clone table?
What are the bind parameters ibm db2?
What is the syntax for creating a table in the db2 database?
What is explain in db2?
Define buffer pool.
What is db2 command?
What r the comman abends in db2, jcl and cobol???????
What is declare cursor?
What is the use of db2 optimizer?
What is dbrm?
How to view db2 table structure?
What is syscat in db2?
How do I add a column to an existing table in db2?
