Relational Model Constraints Multiple Choice Questions with Answers – PDF Download

MCQ 1: In the data model, the inherent constraints are classified as:

1. flat constraints
2. parallel constraints
3. explicit constraints
4. implicit constraints

MCQ 2: The type of constraint in which value of each attribute (X) must be an indivisible value from domain (X) is classified as:

1. explicit constraint
2. implicit constraint
3. domain constraint
4. range constraint

MCQ 3: In the data model schemas, the constraints that are expressed directly are classified as:

1. explicit constraints
2. implicit constraints
3. flat constraints
4. parallel constraints

MCQ 4: The constraint which is used to specify the consistency in two or more relations among tuples is classified as:

1. primary integrity constraint
2. entity integrity constraint
3. referential integrity constraint
4. null integrity constraint

MCQ 5: The type of constraint which states that not even a single value with primary key can be a null value is classified as:

1. null integrity constraint
2. primary integrity constraint
3. secondary integrity constraint
4. entity integrity constraint