Relational Model Constraints MCQ (Multiple Choice Questions) PDF Download

In the data model, the inherent constraints are classified as

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

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

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

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

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