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 a Foreign Key?
What is the syntax for creating a table in the db2 database?
What happens in bind step in a db2 program?
What does db2 plan contain?
Are view updateable?
What is the physical storage length of date data type?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
what is a corelated subquerry?
Is db2 a mainframe?
Before you give the explain statement, what are the prerogatives?
How to find the maximum value in a column in the db2 database?
Who uses db2?
What is difference between alias and synonym in db2?
What is dbrm? What it contains?
What db2 400?