Database Management System Classification Notes Questions with Answers PDF Download – Test 23

MCQ 111: The DBMS in which the systems involved are coupled together while having local autonomy is classified as:

1. single usage DBMS
2. non-classical DBMS
3. classical DBMS
4. federated DBMS

MCQ 112: The type of data organization which does not allow cross block boundaries is called:

1. unspanned organization
2. spanned organization
3. factor organization
4. indexed organization

MCQ 113: The property of normalization of relations which guarantees that functional dependencies are represented in separate relations after decomposition is classified as:

1. nonadditive join property
2. independency reservation property
3. dependency preservation property
4. additive join property

MCQ 114: The operations which are used to enhance the power of expression of relational algebra includes:

1. generalized projection
2. recursive closure operations
3. outer JOIN operations
4. all of above

MCQ 115: The first step in designing high level conceptual data model is:

1. logical design analysis
2. conceptual design analysis
3. functional requirement analysis
4. requirement analysis