Name the different types of Table spaces.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / siva
A table space is a logical storage structure used to control where the data for a database physically is stored. Generally in db2 there are 3 types they are:
Catalog tablespace
User tablespace
Temporary tablespace
these are the default tablespaces
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / shaikh asif
System Tablespace
Non-System Tablespace
Temporary Tablespace
Undo Tablespace
Is This Answer Correct ? | 6 Yes | 8 No |
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
Mention the location where the output received from explain statement is stored.
Can we declare DB2 HOST variable in COBOL COPY book?
How does db2 sample database connect?
how do u update the faltfile into db2 table ?
Compare a subselect to a join?
How can deadlocks be resolved?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
Can you use max on a char column?
What is QUIESCE?