Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q361: Horizontal partitioning divides a table based on _______.
- A: columns
- B: rows
- C: data types
- D: primary keys
View Answer
B
Q362: The technique of merging two entity types with a one-to-one relationship helps in _______ performance.
- A: degrading
- B: improving
- C: complicating
- D: reducing
View Answer
B
Q363: Hash partitioning helps in reducing the chances of _______ partitions.
- A: unbalanced
- B: fixed
- C: list
- D: range
View Answer
A
Q364: In vertical partitioning, a table is split based on _______.
- A: rows
- B: columns
- C: indexes
- D: data types
View Answer
B
Q365: What is vertical partitioning based on?
- A: Rows
- B: Attributes
- C: Tables
- D: Relations
View Answer
B
Q366: In vertical partitioning, what is repeated in all vertical partitions of a table?
- A: Primary Key
- B: Foreign Key
- C: Data Types
- D: Constraints
View Answer
A
Q367: What is the process of copying a portion of a database from one environment to another called?
- A: Replication
- B: Partitioning
- C: Clustering
- D: Denormalization
View Answer
A
Q368: What is clustering in a database?
- A: Placing records from the same table together
- B: Placing records from different tables adjacently
- C: Merging two databases into one
- D: Splitting tables vertically
View Answer
B
Q369: Which of the following is a benefit of SQL standardization?
- A: Reduced training cost
- B: Application complexity
- C: Vendor dependence
- D: System isolation
View Answer
A
Q370: What is the language used to access and manipulate databases?
- A: HTML
- B: SQL
- C: Python
- D: JavaScript
View Answer
B