Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between base table and view?
- 7 Answers
- 32713 Views
- I also Faced
- E-Mail Answers
Answer Posted / ankit
base tables have physical table which does havefacility to
select any condition and save but view is part of a base
table but diffrence is in view we can select columns and
rows using conditions in view creating
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
How do I import a csv file into db2?
What is the difference between plan and package in db2?
Explain the contention situations caused by locks?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Explain in brief how does db2 determine what lock-size to use?
What is meant by union and union all?
How to rename a table in DB2 ?
What is the difference between cursor and select statement?
How does coalesce work?
Explain about cursor stability?
Give a brief description of db2 isolation levels?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
How can you do the explain of a dynamic sql statement?
On which levels locks can be applied?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
