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
Define check constraint.
How do I import a csv file into db2?
Explain the function done by data manager?
What is a dbrm in db2?
What is load utility in db2?
What is the difference between nvl and coalesce?
What is a db2 table?
List down the data types in the db2 database.
Why do we bind in db2?
How to resolve deadlock issue
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
How to find primary key of a table in db2?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is dbrm in db2 database?
what is the role of the cursor in db2?
