Relational Model Constraints MCQ with Answers PDF – Download Test 46

MCQ 226: 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 227: The expression used in relational calculus to specify request of retrieval is classified as:

1. declarative expression
2. procedural expression
3. structural expression
4. functional expression

MCQ 228: In two-tier client ⁄ server architecture, the running of application programs and the user interface programs is in control of:

1. modulation side
2. client side
3. server side
4. host side

MCQ 229: The weak entities are represented in UML diagrams by using aggregations called:

1. qualified segregation
2. non-qualified segregation
3. non-qualified aggregation
4. qualified aggregation

MCQ 230: The compatibility condition which states that the relations for union and intersection operations must consist of same type of tuples is classified as:

1. union compatibility
2. intersect compatibility
3. row compatibility
4. column compatibility