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 |
What is the purpose of using commit?
How do I delete a table in database?
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
What is a host variable?
What is a Resource Control Table(RCT)? Describe its characteristics.
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
How would one remove old reorg information from the DB2 catalog?
What is reorg in database?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
What are the Isolation levels possible ?
How to resolve deadlock issue
Which isolation level provides highest data integrity?