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 the use of commit in db2?
What is the advantage in De-normalizing tables in DB2?
What is ibm db2 database?
How does coalesce work?
Name the lockable units in DB2?
Explain package in db2 and its advantages?
Which command is used to connect to a database in DB2 ? Give the Syntax.
How to take backup of table in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
How and when does the db2 enforces the unique key?
If I have a view which is a join of two or more tables, can this view be updateable?
What is a system catalog table in db2?
How to fetch the last row from the table in SQL (db2)?
What is the physical storage length of date data type?
