which is the most efficient tablespace??
a.simple tablespace.
b.partitioned tablespace.
c.segmented tablespace.
d.none of the above.
please post answer with the reason.?

Answers were Sorted based on User's Feedback



which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segment..

Answer / jaydeep c

C. Segmented tablespace.
Because the sequential access to a particular table is more
efficient and the mass delete is much more efficient than any
other tablespace.

Is This Answer Correct ?    1 Yes 0 No

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segment..

Answer / narayana reddy

c

Is This Answer Correct ?    1 Yes 1 No

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segment..

Answer / jaydeep c

C. Segmented tablespace.
Because the sequential access to a particular table is more
efficient and the mass delete is much more efficient than any
other tablespace.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

How to select the duplicate rows from a table?

4 Answers  


What is db2 optimizer?

0 Answers  


What is a host variable?

3 Answers  


How can deadlocks be resolved?

0 Answers  


When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?

2 Answers  


What do you mean by NOT NULL WITH DEFAULT? When will you use it?

3 Answers  


What techniques are used to retrieve data from more than one table in a single SQL statement?

2 Answers  


what is the use of cursors?

3 Answers   iGate,


wt is view ? wht r the restrictions for view ?

3 Answers   Verizon,


how can u nderstand the sql stmts executed successfully or not ?

1 Answers   TCS,


What types of tables are there in the db2 database?

0 Answers  


What information can you find in SYSIBM.SYSLINKS table?

1 Answers   TCS,


Categories