What are simple, segmented and partitioned table spaces ?
Answer / s
Simple tablespaces stores the rows for all the tables and
they are interleaved with one another.
Segmented tablespaces, tables are stored in equal sized
segments and a segment contains rows from one table.
Partitioned tablespace, only one table can be defined and
rows are spread across partitions.
Is This Answer Correct ? | 6 Yes | 1 No |
What is a synonym ?
What is dbrm? When it will be created?
How do you insert a record with a nullable column?
When do you use the IMAGECOPY?
What is pagespace?
What should be specified along with a cursor in order to continue updating process after commit?
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?
What is a db2 schema?
How can record locking be achieved in those DB2 versions which do not support it?
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
how can we find nth max salary from A table
Which transaction use a command thread ?