CS403P Quiz 3 2025

Q1. A specific record of a relation is accessed through:

1. Arbitrary Key
2. Secondary Key
3. Primary Key
4. Random key

Correct answer: Random key

Q2. In many to many relationship, a third table is created for the relationship. It is known as _______.

1. Naming entity type
2. Associative entity type
3. Strong entity type
4. Regular entity type

Correct answer: Associative entity type

Q3. If there are two relations X and Y then the difference of these two relations (i.e. X-Y) will be set of tuples that

1. Appear in Y but not in X
2. Appear in both X and Y
3. Appear in X but do not appear in Y
4. Do not appear in both X and Y

Correct answer: Appear in X but do not appear in Y

Q4. In relational data model, composite attributes need to be represented as:

1. Separate relation
2. Objects
3. Entity type
4. Recursive relationship

Correct answer: Separate relation

Q5. In intersection operation, which of the following is selected?

1. Tuples common in both relations
2. Tuples of single relation only
3. Tuples of second relationD. Tuples of first relation

Correct answer: Tuples common in both relations

Q6. If a teacher teaches multiple courses in a university then the relationship between teacher and course is:

1. Many to one
2. One to many
3. Recursive relationshipD. One to one

Correct answer: One to many

Q7. Suppose a relation named EMPLOYEE contains attributes Emp_name, Emp_designation, Emp_address and Emp_salary. Which of the following query will be used to SELECT all those employees whose designation is Admin officer?

1. α designation = ‘Admin officer’ (EMPLOYEE)
2. ϕ designation = ‘Admin officer’(EMPLOYEE)
3. ռ designation = ‘Admin officer’ (EMPLOYEE)
4. σ designation = ‘Admin officer’ (EMPLOYEE)

Correct answer: σ designation = ‘Admin officer’ (EMPLOYEE)

Q8. Consider the following functional dependency: A → B In above functional dependency, attribute B is_______ on A.

1. Dependent
2. Projected
3. Reflected
4. Terminated

Correct answer: Dependent

Q9. A table is in the 2nd Normal Form if there is no___________.

1. Functional dependency
2. Partial dependency
3. Transitive dependency
4. Reflexive dependency

Correct answer: Partial dependency

Q10. Which of the following are unary operators?

1. SELECT and CARTESIAN
2. UNION and PROJECT
3. SELECT and PROJECT
4. PROJECT and CARTESIAN

Correct answer: SELECT and PROJECT