Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q331: The process of _________ is performed after the logical database design phase.
- A: normalization
- B: physical DB design
- C: data entry
- D: indexing
View Answer
A
Q332: The example table WORK consists of attributes like projName, empId, and __________.
- A: empName
- B: startDate
- C: budget
- D: salary
View Answer
A
Q333: In the given example, the normalization process started with a single large _________.
- A: table
- B: database
- C: attribute
- D: query
View Answer
A
Q334: A table is in the First Normal Form (1NF) if it contains __________ values.
- A: atomic
- B: non-atomic
- C: composite
- D: complex
View Answer
A
Q335: The normalization process involves checking tables for __________ against normal forms.
- A: consistency
- B: dependencies
- C: attributes
- D: functionality
View Answer
B
Q336: What is the primary objective of physical database design?
- A: Storage efficiency
- B: Data integrity
- C: Execution efficiency
- D: Data accuracy
View Answer
C
Q337: What does normalization help to maintain in a database?
- A: Uniqueness of attributes
- B: Consistency
- C: Speed of queries
- D: Data integrity
View Answer
B
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
View Answer
B
Q339: Which of the following is NOT a common data type in PL/SQL?
- A: VARCHAR2
- B: CHAR
- C: RAW
- D: BOOLEAN
View Answer
D
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
View Answer
B