Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Chapter: 22
Q341:
Which data type can store binary large objects up to 4 Gigabytes?
A. LONG
B. BLOB
C. RAW
D. CHAR
Correct Answer:
B
Chapter: 22
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
Correct Answer:
B
Chapter: 22
Q343:
Which field type is used for storing fixed-length character data?
A. VARCHAR2
B. CHAR
C. NUMBER
D. DATE
Correct Answer:
B
Chapter: 22
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
Correct Answer:
B
Chapter: 22
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
Correct Answer:
B
Chapter: 22
Q346:
Normalization is a process to make DB design more _______.
A. efficient
B. redundant
C. complex
D. inefficient
Correct Answer:
A
Chapter: 22
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
Correct Answer:
B
Chapter: 22
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
Correct Answer:
B
Chapter: 22
Q349:
The _______ data type is used for fixed length character data.
A. CHAR
B. VARCHAR2
C. NUMBER
D. LONG
Correct Answer:
A
Chapter: 22
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
Correct Answer:
C
Chapter: 23
Q351:
What is the main purpose of denormalization in database design?
A. To increase redundancy
B. To simplify the schema
C. To enhance performance
D. To enforce data integrity
Correct Answer:
C
Chapter: 23
Q352:
Which situation indicates a potential candidate for denormalization?
A. High frequency of queries involving multiple tables
B. Low volume of data transactions
C. Minimal calculation on columns
D. Rarely accessed tables
Correct Answer:
A
Chapter: 23
Q353:
What is the effect of merging two entity types with a one-to-one relationship?
A. Increased redundancy and storage wastage
B. Improved performance by reducing join operations
C. More complex queries
D. Increased data normalization
Correct Answer:
B
Chapter: 23
Q354:
In which situation would you consider partitioning a database table?
A. When data access is infrequent
B. When the table is small and simple
C. To reduce workload and improve performance
D. To merge two tables with the same schema
Correct Answer:
C
Chapter: 23
Q355:
What type of partitioning divides a table based on rows?
A. Vertical Partitioning
B. Horizontal Partitioning
C. Range Partitioning
D. List Partitioning
Correct Answer:
B
Chapter: 23
Q356:
What is the advantage of horizontal partitioning using range partitioning?
A. Reduces unbalanced partitions
B. Splits a table based on columns
C. Maintains fixed-length records
D. Specifies list values for partitions
Correct Answer:
A
Chapter: 23
Q357:
Which partitioning method uses an algorithm to distribute data evenly across partitions?
A. Range Partitioning
B. List Partitioning
C. Hash Partitioning
D. Vertical Partitioning
Correct Answer:
C
Chapter: 23
Q358:
How does list partitioning differ from range partitioning?
A. List partitioning uses specific values for partitions, while range partitioning uses a range of values
B. List partitioning applies an algorithm, while range partitioning specifies ranges
C. List partitioning splits based on columns, while range partitioning splits rows
D. List partitioning ensures even distribution, while range partitioning does not
Correct Answer:
A
Chapter: 23
Q359:
What should be analyzed before performing partitioning of a table?
A. The frequency of data access
B. The table’s schema and relationships
C. The number of columns
D. The data size alone
Correct Answer:
B
Chapter: 23
Q360:
Denormalization is applied to improve _______ of a database.
A. data integrity
B. performance
C. normalization
D. redundancy
Correct Answer:
B