IBM Certification Question:
Download Questions PDF

In which two situations would you use a round robin fragmentation strategy?

A. When all fragments must be second
B. To create uneven data distributions
C. When queries perform sequential scans and you have little information about the data being stored.
D. When tables are accessed with a high degree of selectivity

Answer:

A. When all fragments must be second

Download IBM Certification Interview Questions And Answers PDF

Previous QuestionNext Question
Explain Which isolation level does a database without logging default to?

A. committed read
B. dirty read
C. mode ANSI
D. repeatable read
Explain If there is a lock on an adjacent key, an insert will fail if the isolation level is set to what?

A. committed read
B. repeatable read
C. share read
D. indexed read