Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q221: In RDM, what does the term "tuple" refer to?
- A: A row in a table
- B: A column in a table
- C: A database schema
- D: A type of query
View Answer
A
Q222: The Cartesian product of sets A = {x, y} and B = {2, 4, 6} results in which of the following?
- A: {(x,2), (x,4), (x,6)}
- B: {(x,2), (y,2), (x,6), (y,4)}
- C: {(x,2), (y,2), (x,6), (y,6)}
- D: {(x,4), (y,4), (x,6), (y,6)}
View Answer
B
Q223: Fill in the blank: In a relational database, each row is called a _______.
- A: Tuple
- B: Column
- C: Domain
- D: Attribute
View Answer
A
Q224: The relational data model was proposed by which IBM scientist?
- A: E.F. Codd
- B: C.J. Date
- C: H. Garcia
- D: S. Ramaswamy
View Answer
A
Q225: Fill in the blank: In a relational database, the term “domain” refers to the set of _______ that an attribute can take.
- A: Operations
- B: Values
- C: Tables
- D: Queries
View Answer
B
Q226: The main purpose of transforming a conceptual database design into a logical database design is to:
- A: Define the physical schema
- B: Design the database structure
- C: Implement the database
- D: Analyze the data
View Answer
B
Q227: In the example provided, the table with columns stID, stName, clName, doB, and sex represents which of the following?
- A: A relation
- B: A function
- C: A domain
- D: An attribute
View Answer
A
Q228: The relational data model’s mathematical foundation provides advantages such as:
- A: Unlimited data storage
- B: Precise meaning and testability
- C: Complex data manipulation
- D: Free-form data entry
View Answer
B
Q229: Fill in the blank: A relation scheme specifies the attributes and their _______ in the context of a relation.
- A: Domains
- B: Values
- C: Queries
- D: Relationships
View Answer
A
Q230: What is the primary difference between mathematical and database relations?
- A: Order of columns affects mathematical relations but not database relations
- B: Order of rows affects database relations but not mathematical relations
- C: Column names are different in mathematical and database relations
- D: Database relations have more columns than mathematical relations
View Answer
A