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.?

Answer Posted / narayana reddy

c

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you tell me how can you find out the # of rows updated after an update statement?

612


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1241


What is a bind card?

681


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

755


When reorg is used?

680






Explain how can you do the explain of a dynamic sql statement?

657


What is the result of open cursor statement?

640


How do I copy a table in db2?

577


How to check table size in db2 sap?

584


Mention data types used in db2 ?

683


How do I delete a table in db2?

651


What are the uses of db2 optimizer?

819


What language is db2 written in?

598


Why do we bind in db2?

634


What is query_cache_limit?

549