Name the different types of Table spaces.

Answer Posted / obularaju

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

Is This Answer Correct ?    27 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

2765


What is a db2 package?

605


Why do we use cursor?

602


Are view updateable?

634


Mention the definition of cobol in varchar field.

704






What is the default page size of buffer pools?

654


What does runstats do in db2?

612


How to take backup of table in db2?

607


What is meant by union and union all?

595


What is a cursor in programming?

605


List out the data types available.

712


What is runstats and reorg in db2?

808


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

637


Give the name of some fields form sqlca.

620


How to find the number of rows in a db2 table?

652