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 database manager in db2?
What is clone table?
How to resolve deadlock issue
What is the maximum length of sqlca?
What is a db2 table?
How to take backup of table in db2?
What is syscat in db2?
Mention the downsides of page level lock.
How can deadlocks be resolved?
What is the advantage in De-normalizing tables in DB2?
What is buffer pool and list some of them?
What is performance tuning db2?
What is buffer pool in the db2 database?
How can you do the explain of a dynamic sql statement?
Is db2 relational database?
