Name the different types of Table spaces.

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


Please Help Members By Posting Answers For Below Questions

What is meant by explain?

660


What is db2 optimizer?

769


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

743


What is the difference between nvl and coalesce?

600


What is a collection in db2?

579






What are db2 tables?

641


Are views updateable?

638


How can you find out the # of rows updated after an update statement?

637


can all users have the privilage to use the sql statement select * (dml)?

638


Explain about rct.

644


What does sqlcabc has?

625


What does db2 blu stand for?

658


Is db2 free?

682


Why do we need reorg in db2?

558


What is dbrm? What it contains? When it will be created?

589