IBM Certification Question: Download IBM Certification PDF

Which statement fragments a table as round robin?

A. FRAGMENT AS ROUND ROBIN IN dbspace 1, dbspace 2
B. FRAGMENT TABLE BY ROUND ROBIN IN dbspace1, dbspace 2
C. FRAGMENT BY ROUND ROBIN IN dbspace1, dbspace 2
D. FRAGMENT BY ROUND ROBIN

C.FRAGMENT BY ROUND ROBIN IN dbspace1, dbspace 2

Previous Question	Next Question
What help ensure that the XIV Systems cache does not become a bottleneck? A. central cache locking mechanism B. use of industry standard chip technology C. each module is responsible for caching the data in that module D. having all modules understand what is held cache at all times	Which of the following can be kept in memory when the DB2 configuration parameter KEEPFENCED is enabled? A. SQLDAS after their cursor is closed. B. Referential integrity maps after a join. C. Stored procedure processes after they are run. D. Tables after they have been read into the buffer pool.