Answer Posted / shruthi
In DB2:
1) Simple Tablespace
2) Segmented Tablespace
3) Partitioned tablespace
In Oracle:
1)Permanent tablespaces
2)Undo tablespaces
3)Temporary tablespaces
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What is the function of logging in the db2 database?
What do you mean by rollback?
What is a plan and package in db2?
What is image copy in db2?
When do you specify the isolation level?
What does a deadlock mean in DB2?
What is db2 optimizer?
What does runstats do in db2?
Which isolation level provides maximum concurrency?
Explain in brief how does db2 determine what lock-size to use?
What types of tables are there in the db2 database?
What is netezza database?
What is query_cache_limit?
How do we specify index to include or not during bind process.
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference