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 FREE command?
what is Runstats? Whem will u choose to runatats?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Explain the contents that are a part of dclgen.
What is sqlcode -922 ?
Compare a subselect to a join?
Mention and explain the contention situations caused by locks?
wht r the requirements for writing a cobol-db2 pgm ?
How do you Load a table ?? and what is Load replace ?
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
What is the meaning concurrency in the db2 database?