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
What is dclgen (declaration generator)?
What is the difference between drop table and delete table?
Define data page.
What is db2?
Which is faster delete or truncate?
What is with ur in db2?
What is db2 plan table?
How to find the number of rows in a db2 table?
What do you mean by rollback?
What is release/acquire in bind?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
Explain the benefits you can get from mainframe connect?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is runstats db2?
How to find primary key of a table in db2?
