What is the difference between base table and view?
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
What is database reorganization?
B37 abend during spufi?
What are packages in db2?
What is catalog database in db2?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is the physical storage length of time data type?
Explain about cursor stability?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is a bind card?
Is it possible using max on a char column?
How can deadlocks be resolved?
What is alias in db2?
What is a trigger in the db2 database?
Which component is responsible for db2 startup and shutdown?
Mention the definition of cobol in varchar field.