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
Define db2.
Discuss about db2 bind?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is temporal table in db2?
How to find the number of rows in db2 tables?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How can we retrieve the total number of records in RPG & CLLE?
How to connect to db2 database from windows command line?
How to find primary key of a table in db2?
How will you return the number of records in table?
What is a db2 table?
How to execute stored procedure in db2 command editor?
What is clone table?
Which component is responsible for processing sql statements and selecting access paths?
