Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q241: Multi-valued attributes in a relational database are represented by _______.
- A: A single relation containing all values
- B: Two relations: one for the entity type and one for the multi-valued attribute
- C: One relation with a composite attribute
- D: Attributes with default values
View Answer
B
Q242: What is the primary focus of mapping relationships in a database?
- A: Identifying primary keys
- B: Establishing relationships between entity types
- C: Defining attributes
- D: Normalizing data
View Answer
B
Q243: In a one-to-many relationship, how is the relationship implemented in the relational model?
- A: By placing the primary key of the many-side entity as a foreign key in the one-side entity
- B: By placing the foreign key of the one-side entity in the many-side entity
- C: By creating a new table for the relationship
- D: By combining the primary keys of both entities
View Answer
B
Q244: What does the cardinality of a relationship describe?
- A: The number of attributes in a relation
- B: The number of rows in a relation
- C: The number of instances in each participating entity type
- D: The number of relations in the database
View Answer
C
Q245: In a one-to-one relationship, what is typically included in the optional side?
- A: The primary key of the compulsory side as a foreign key
- B: The primary key of the optional side as a foreign key
- C: A composite key from both sides
- D: A unique constraint from both sides
View Answer
A
Q246: Which type of relationship involves creating a third table to manage the relationship between two entities?
- A: One-to-Many
- B: One-to-One
- C: Many-to-Many
- D: Unary
View Answer
C
Q247: In the given example of the BOOK and STD entities, what is the purpose of the TRANS table?
- A: To store details of book borrowers and return dates
- B: To store book details and student details
- C: To manage the relationship between books and students
- D: To keep track of book authors and titles
View Answer
C
Q248: What is the minimum cardinality of a foreign key if an entity can exist without being linked to another entity?
- A: Zero
- B: One
- C: Two
- D: Three
View Answer
A
Q249: What is the main difference between procedural and non-procedural data manipulation languages?
- A: Procedural languages require a method of how to perform operations, while non-procedural languages only specify what to do
- B: Both types of languages perform the same operations, but non-procedural languages are more efficient
- C: Procedural languages are used for defining data structures, while non-procedural languages are used for querying data
- D: Non-procedural languages do not support data manipulation operations
View Answer
A
Q250: Which of the following is NOT one of the basic operations in relational algebra?
- A: Selection
- B: Projection
- C: Join
- D: Cartesian Product
View Answer
C