CS403 Quiz 2 November 2025

Question:

We have two entities “Person” and “Doctor”. Which of the following is best suitable type of relationship between the mentioned entities?

1. Sub type
2. Super type
3. Unary
4. Inheritance

Copied: 11/24/2025, 10:37:12 AM

Question:

Which of the following is a true statement?

1. The super type entity and sub type entity are same.
2. The sub type entity does not contains the attributes of the super type entity.
3. The super type entity contains the attributes of the sub type entity.
4. The sub type entity contains the attributes of the super type entity.

Copied: 11/24/2025, 10:37:35 AM

Question:

A ________________ is used to combine rows from two or more tables, based on a related column between them.

A. Project operator

B. Delete operator C. Join operation D. Select operator Copied: 11/24/2025, 10:38:14 AM

Question:

Which of the following is a completeness constraint?

1. Partial completeness Constraint
2. Total generalization Constraint
3. Hybrid completeness Constraint
4. Partial generalization Constraint

Copied: 11/24/2025, 10:38:36 AM

Question:

In Relational Data Model, the ________ of a relation is the number of rows in that relation.

A. Constraint B. Cardinality C. Domain D. Degree Copied: 11/24/2025, 10:39:25 AM

Question:

The attribute EXPERIENCE is calculated from DATE_OF_JOINING attribute. The EXPERIENCE is a _______ attribute.

A. Multi-valued B. Derived C. Composite D. Stored Copied: 11/24/2025, 10:39:43 AM

Question:

Unary relationship involve a single entity it is also called____________________.

A. Recursive relationship B. Many to many relationship C. One to many relationship D. One to one relationship Copied: 11/24/2025, 10:40:06 AM

Question:

The relationship between department to employees is ____________.