External Sorting Algorithms MCQs with Answers PDF Download – Test 114

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

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

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

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

The procedure of building composite objects from components of objects is classified as

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

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