Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q121: Which of the following is an example of a single-valued attribute?
- A: Hobbies
- B: Skills
- C: Employee Name
- D: Address
View Answer
C
Q122: What is the purpose of associating a domain with an attribute?
- A: To define the operations on the attribute
- B: To ensure values are within a specific set or range
- C: To give the attribute a unique name
- D: To determine the attribute's type
View Answer
B
Q123: An example of a multi-valued attribute is:
- A: Employee Name
- B: Address
- C: Skills
- D: Hobby
View Answer
C
Q124: The notation for attribute names generally includes:
- A: A full description of the attribute
- B: An abbreviation of the entity type and a description of the attribute
- C: A unique identifier and a description
- D: A random sequence of letters
View Answer
B
Q125: What is an attribute in the context of database systems?
- A: A detail that describes the state of an entity
- B: A set of keys used to identify an entity
- C: A type of entity instance
- D: None of the above
View Answer
A
Q126: What is a super key?
- A: A set of one or more attributes that can uniquely identify an entity instance
- B: A key that is used to access secondary attributes
- C: A key that consists of a single attribute only
- D: A composite key with multiple attributes
View Answer
A
Q127: Which of the following keys can be used to uniquely identify an entity instance?
- A: Candidate Key
- B: Secondary Key
- C: Foreign Key
- D: Alternate Key
View Answer
A
Q128: What is a candidate key?
- A: A super key for which no subset is a super key
- B: A key that is used to access secondary attributes
- C: A key with a single attribute only
- D: A key that is defined by the database designer
View Answer
B
Q129: What distinguishes a primary key from other keys?
- A: It is chosen by the database designer and cannot be NULL
- B: It is always a composite key
- C: It is used for secondary access
- D: It is a non-key attribute
View Answer
A
Q130: What does a secondary key allow you to do?
- A: Access instances based on non-unique attributes
- B: Access instances uniquely based on a single attribute
- C: Identify entities without using any attributes
- D: None of the above
View Answer
A