What is a view? Why use it?
Answers were Sorted based on User's Feedback
Answer / aditya
view is used to create another representation of data where
we can protect the important data from public view.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / purushothr
view is a logical table that can be created by one or more
base table
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / srinivasa yadav
VIEW IS A VIRTUAL MEMEORY SPACE WHICH DOES'NT HOLD ANY DATA.
MAINLY VIEW IS USED TO RESTRICT AUTHORIZATION FOR THE
USERS. SO USER CAN ACCESS ONLY PARTICULAR COLUMNS.
| Is This Answer Correct ? | 0 Yes | 3 No |
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
What is precompiler in db2?
can any one expalin check point with an example?
What is rct?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
What are some characteristics of columns that benefit from indexes?
Is the primary key a clustered index?
How to resolve deadlock issue
Is db2 a mainframe?
How to resolve -407 sql code in DB2?
Are view updateable?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)