ERM Types Constraints Multiple Choice Questions with Answers – PDF Download

MCQ 1: Considering the binary relationships, the possible cardinality ratios are:

1. one : one
2. 1 : N
3. M : N
4. all of above

MCQ 2: The types of partial constraints are:

1. total and partial
2. intensive and extensive
3. minimum and maximum
4. floating and string

MCQ 3: The relationship type in which one attribute is migrated to the N-side of relationship is classified as:

1. 4:N
2. 3:N
3. 1:N
4. 2:N

MCQ 4: For a relationship type, the participation constraints and cardinality ratio are considered together to make:

1. intensive constraints
2. recursive constraints
3. composite constraints
4. structural constraints

MCQ 5: The constraint which specifies the minimum number of relationship instances is classified as:

1. participation constraint
2. non-participation constraint
3. extensive constraint
4. intensive constraint