Name the different types of Table spaces.

Login | Sign Up


	Do you have a collection of Interview Questions and interested to share with us!! Please send that collection to along with your userid / name. ThanQ

Categories >> Software >> MainFrame >> IBM MainFrame >> DB2

Question

Name the different types of Table spaces.

Question Submitted By :: Guest

Rank

Answer Posted By

Re: Name the different types of Table spaces.

Answer
# 1

1) Simple Tablespace
2) Segmented Tablespace
3) Partitioned tablespace

Is This Answer Correct ?

2 Yes

0 No

Obularaju

Re: Name the different types of Table spaces.

Answer
# 2

System  Tablespace
Non-System Tablespace
Temporary Tablespace
Undo Tablespace

Is This Answer Correct ?

1 Yes

1 No

Shaikh Asif

Question	Asked @	Answers
Other DB2 Interview Questions


What is a host variable?		1
What is EXPLAIN?		1
What is the SQL Communications Area and what are some of its key fields?		1
How to define the data items to receive the fetch items for the SQL?		1
Why might full image copies be faster to implement than an incremental image copy?		1
What is a buffer pool?		1
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?		2
What is FREEPAGE and PCTFREE in TABLESPACE creation?		1
What does DSNDB07 database do?		1
How is a typical DB2 batch program executed ?		1
What does the REORG Utility do?		1
What is the function of the Data Manager?		1
What is filter factor?		2
DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language	Accenture	3
What is the cascade rule and how does it relate to deletions made with a subselect?		1
what is commit & rollback? When and where is used while compiling a cobol-db2 program?		2
What is the difference between TYPE 1 index & TYPE 2 index		1
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).	Wipro	5
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?		1
How do you Load a table ?? and what is Load replace ?	Xansa	2

For more DB2 Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com