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 are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is sqlca?
How is a typical db2 batch pgm executed?
What is phantom read in db2?
What is difference between isnull and coalesce?
List out the three types of page locks that can be held.
Is ibm db2 open source?
What are the 2 sqlcodes that are returned?
What is runstats and reorg in db2?
How does a cursor work?
What is a Foreign Key?
What is buffer pool in the db2 database?
Explain the contents that are a part of dclgen.
Define predicate?
