DBMS Keys Multiple Choice Questions (MCQ) PDF Download

MCQ 1: A property of the entire relation, rather than of the individual tuples, is known as

1. Attribute
2. Constant
3. Variable
4. Key

MCQ 2: The address field of a person should not be part of the primary key, since it is likely to

1. Dependent
2. Changed
3. Not changed
4. Too long

MCQ 3: The primary key should be chosen such that its attribute values are

1. Updated
2. Dependent
3. Changed
4. Never changed

MCQ 4: We are often interested in superkeys for which no proper subset is a

1. Superset key
2. Superkey
3. Primary key
4. Unique key

MCQ 5: Minimal superkeys are called

1. Unique key
2. Superset key
3. Candidate key
4. Primary key