Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q341: Which data type can store binary large objects up to 4 Gigabytes?
- A: LONG
- B: BLOB
- C: RAW
- D: CHAR
View Answer
B
Q342: In the normalization process, what is the purpose of splitting a table?
- A: To reduce the size of the table
- B: To remove redundancy and partial dependencies
- C: To increase data integrity
- D: To simplify the schema
View Answer
B
Q343: Which field type is used for storing fixed-length character data?
- A: VARCHAR2
- B: CHAR
- C: NUMBER
- D: DATE
View Answer
B
Q344: What is the purpose of coding techniques in database design?
- A: To increase the data size
- B: To compress and efficiently represent data
- C: To encrypt data
- D: To validate data integrity
View Answer
B
Q345: What does referential integrity ensure in a database?
- A: Data is stored in encrypted format
- B: Consistent and accurate data relationships
- C: Data is normalized
- D: Data is backed up regularly
View Answer
B
Q346: Normalization is a process to make DB design more _______.
- A: efficient
- B: redundant
- C: complex
- D: inefficient
View Answer
A
Q347: The VARCHAR2 data type can store a variable length character string with a maximum size of _______ bytes.
- A: 10000
- B: 32767
- C: 50000
- D: 1024
View Answer
B
Q348: In the physical database design, grouping attributes helps in _______ of the relation.
- A: increasing redundancy
- B: removing unnecessary information
- C: enhancing data integrity
- D: compressing data
View Answer
B
Q349: The _______ data type is used for fixed length character data.
- A: CHAR
- B: VARCHAR2
- C: NUMBER
- D: LONG
View Answer
A
Q350: Referential integrity is maintained by ensuring that values of a specific attribute are in specific _______ compared to other attributes.
- A: formats
- B: sizes
- C: ranges
- D: tables
View Answer
C