External Sorting Algorithms MCQs with Answers PDF Download – Test 114

MCQ 566: In sort merge strategy, the small sub files sorted are called:

1. runs
2. folders
3. blocks
4. indexes

MCQ 567: The possible actions of altering the tables in Standard Query Language includes:

1. adding or dropping constraints
2. adding or dropping attributes
3. change definition o columns
4. all of above

MCQ 568: The strategy in which resulting schema from the integration of the pairs of schemas are further integrated by pairing is classified as:

1. mixed pairing strategy
2. schema pairing strategy
3. ternary balanced strategy
4. binary balanced strategy

MCQ 569: The procedure of building composite objects from components of objects is classified as:

1. aggregation
2. segregation
3. aggregate synthesis
4. aggregate refinement

MCQ 570: The type of data independence in which the internal schema can be modified without modifying the conceptual schema is classified as:

1. logical data independence
2. physical data independence
3. conceptual level independence
4. external level independence