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 node in db2?
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 ?
What is a plan and package in db2?
What is cursor in dbms?
What is dbrm? What it contains? When it will be created?
Which isolation level provides highest data integrity?
How to find the maximum value in a column in the db2 database?
What is a collection in db2?
What is consistency token in db2?
What does db2 stand for?
What is a db2 collection?
What is the maximum number of columns in a db2 table?
What is the information associated with sysibm.syslinks table?
Give the name of some fields form sqlca.
What is the syntax for seeing the columns and data types of a table in the db2 database?
