Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Chapter: 14
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
Correct Answer:
A
Chapter: 14
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)}
Correct Answer:
B
Chapter: 14
Q223:
Fill in the blank: In a relational database, each row is called a _______.
A. Tuple
B. Column
C. Domain
D. Attribute
Correct Answer:
A
Chapter: 14
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
Correct Answer:
A
Chapter: 14
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
Correct Answer:
B
Chapter: 14
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
Correct Answer:
B
Chapter: 14
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
Correct Answer:
A
Chapter: 14
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
Correct Answer:
B
Chapter: 14
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
Correct Answer:
A
Chapter: 15
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
Correct Answer:
A
Chapter: 15
Q231:
The degree of a relation is defined as the number of _______ in that relation.
A. rows
B. tuples
C. columns
D. attributes
Correct Answer:
C
Chapter: 15
Q232:
In the STUDENT table example, what is the degree of the relation?
A. Three
B. Four
C. Five
D. Six
Correct Answer:
B
Chapter: 15
Q233:
The cardinality of a relation refers to the number of _______ present in the relation.
A. columns
B. tuples
C. rows
D. attributes
Correct Answer:
C
Chapter: 15
Q234:
In the given example, which attribute in the EMP table is a foreign key?
A. empId
B. empName
C. qual
D. depId
Correct Answer:
D
Chapter: 15
Q235:
What must match or be null for a foreign key to comply with referential integrity constraints?
A. The primary key value in the home relation
B. The domain value of the foreign key
C. The primary key in the foreign relation
D. The data type of the foreign key
Correct Answer:
A
Chapter: 15
Q236:
Which constraint ensures that no attribute of a primary key can have a null value?
A. Entity Integrity Constraint
B. Referential Integrity Constraint
C. Null Constraint
D. Default Value Constraint
Correct Answer:
A
Chapter: 15
Q237:
In a relational database, which constraint applies to attributes to ensure they are defined and have a value?
A. Entity Integrity Constraint
B. Referential Integrity Constraint
C. Null Constraint
D. Default Value Constraint
Correct Answer:
C
Chapter: 15
Q238:
What does a default value constraint do in a database?
A. Ensures an attribute cannot be null
B. Specifies a value for an attribute if none is provided
C. Forces an attribute to have a unique value
D. Limits the possible values of an attribute
Correct Answer:
B
Chapter: 15
Q239:
Domain constraints in databases specify the _______ of an attribute.
A. possible set of values
B. default value
C. primary key value
D. foreign key value
Correct Answer:
A
Chapter: 15
Q240:
Composite attributes in a relational database are treated as _______.
A. simple attributes
B. separate relations
C. multi-valued attributes
D. foreign keys
Correct Answer:
B