Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Chapter: 20
Q321:
Fill in the blank: The goal of normalization is to create a set of relational tables that are free of _______ and can be consistently and correctly modified.
A. Redundant data
B. Primary keys
C. Composite keys
D. Foreign keys
Correct Answer:
A
Chapter: 21
Q322:
What is the primary goal of normalization in database design?
A. Increase redundancy
B. Improve efficiency and consistency
C. Add more attributes
D. Simplify physical design
Correct Answer:
B
Chapter: 21
Q323:
Which normal form is typically sufficient for most situations according to the lecture?
A. 1NF
B. 2NF
C. 3NF
D. 6NF
Correct Answer:
C
Chapter: 21
Q324:
What is the process used to transform logical database design into technical specifications?
A. Physical DB design
B. Logical DB design
C. Data normalization
D. Data redundancy
Correct Answer:
A
Chapter: 21
Q325:
In normalization, what does a partial dependency violate?
A. First Normal Form (1NF)
B. Second Normal Form (2NF)
C. Third Normal Form (3NF)
D. Fourth Normal Form (4NF)
Correct Answer:
B
Chapter: 21
Q326:
What is the primary focus of physical database design compared to logical database design?
A. Storage efficiency
B. Database consistency
C. Execution efficiency
D. Normalization accuracy
Correct Answer:
C
Chapter: 21
Q327:
In the given example, which attribute is used as the primary key for the WORK table?
A. empId, projName
B. empId
C. projName
D. empDept
Correct Answer:
A
Chapter: 21
Q328:
Which table was not found to have a transitive dependency in the normalization example?
A. PROJECT
B. WORK
C. EMPLOYEE
D. DEPT
Correct Answer:
B
Chapter: 21
Q329:
What should be considered when making decisions about physical database design?
A. Only data types
B. Tool-specific decisions
C. Data usage and requirements
D. Normalized relations only
Correct Answer:
C
Chapter: 21
Q330:
Normalization helps to maintain the __________ of the database.
A. efficiency
B. redundancy
C. consistency
D. complexity
Correct Answer:
C
Chapter: 21
Q331:
The process of _________ is performed after the logical database design phase.
A. normalization
B. physical DB design
C. data entry
D. indexing
Correct Answer:
A
Chapter: 21
Q332:
The example table WORK consists of attributes like projName, empId, and __________.
A. empName
B. startDate
C. budget
D. salary
Correct Answer:
A
Chapter: 21
Q333:
In the given example, the normalization process started with a single large _________.
A. table
B. database
C. attribute
D. query
Correct Answer:
A
Chapter: 21
Q334:
A table is in the First Normal Form (1NF) if it contains __________ values.
A. atomic
B. non-atomic
C. composite
D. complex
Correct Answer:
A
Chapter: 21
Q335:
The normalization process involves checking tables for __________ against normal forms.
A. consistency
B. dependencies
C. attributes
D. functionality
Correct Answer:
B
Chapter: 22
Q336:
What is the primary objective of physical database design?
A. Storage efficiency
B. Data integrity
C. Execution efficiency
D. Data accuracy
Correct Answer:
C
Chapter: 22
Q337:
What does normalization help to maintain in a database?
A. Uniqueness of attributes
B. Consistency
C. Speed of queries
D. Data integrity
Correct Answer:
B
Chapter: 22
Q338:
What is a key benefit of using data types in database design?
A. Increased data redundancy
B. Minimized storage space usage
C. Reduced query performance
D. Complex data retrieval
Correct Answer:
B
Chapter: 22
Q339:
Which of the following is NOT a common data type in PL/SQL?
A. VARCHAR2
B. CHAR
C. RAW
D. BOOLEAN
Correct Answer:
D
Chapter: 22
Q340:
What does the VARCHAR2 data type represent?
A. Fixed length character data
B. Variable length character string
C. Raw binary data
D. Date values
Correct Answer:
B