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 STOSPACE Utility used for?
What is commit in db2?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
What are the abend codes occour in ur latest PROJECT in DB2
What is the use of commit in db2?
Explain dclgen.
How to find the number of rows in db2 tables?
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
What techniques will be used to avoid deadlock??
What is a DB2 bind?