1⟩ Explain What are three advantages of fragmentation? A. higher availability B. reduced disk space requirements C. parallel scans are possible with PDQ D. finer granularity of archives and resources
“IBM Certification Exams Frequently Asked Questions in various IBM Certification Exams Interviews asked by the interviewer. So learn IBM Certification Exams with the help of this IBM Certification Exams Interview questions and answers guide and feel free to comment as your suggestions, questions and answers on any IBM Certification Exams Interview Question or answer by the comment feature available on the page.”
D.Define a dependent table where TAB1 is the parent.
C.Each module is responsible for caching the data in that module
C.FRAGMENT BY ROUND ROBIN IN dbspace1, dbspace 2
C.Stored procedure processes after they are run.
A.Hash joins may require more resources to run.
B.B mkfs.ext2 <path to device>
D.DB2 Spatial Extender
A. When all fragments must be second
B,E:Extent size/Table space name
A.a contiguous unit of disk space
B:a row/a page