Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q651: To create a view that filters records from a table, you use _______. The ORDER BY clause
- A: Aggregation functions
- B: The WHERE clause
- C: A JOIN operation
- D:
View Answer
C
Q652: A materialized view is updated through _______.
- A: Batch updates from multiple master sites
- B: Continuous updates from other master sites
- C: Real-time updates only
- D: Manual refresh only
View Answer
A
Q653: In the context of views, the term "nesting" refers to _______.
- A: Creating a view within another view
- B: Updating a view on a periodic basis
- C: Creating multiple views at once
- D: Deleting a view
View Answer
A
Q654: What is a materialized view primarily used for?
- A: To summarize, compute, replicate, and distribute data
- B: To replace indexes
- C: To create new tables
- D: To update data in real-time
View Answer
A
Q655: Which SQL command is used to create a materialized view?
- A: CREATE MATERIALIZED VIEW
- B: CREATE VIEW
- C: CREATE TABLE
- D: CREATE INDEX
View Answer
A
Q656: A transaction in a database must ensure _______.
- A: Atomicity, Consistency, Isolation, Durability
- B: Speed, Efficiency, Scalability, Simplicity
- C: Availability, Redundancy, Integrity, Security
- D: Complexity, Flexibility, Performance, Scalability
View Answer
A
Q657: In which scenario are materialized views especially useful?
- A: For complex queries with large joins and aggregates
- B: For simple data retrieval operations
- C: For quick updates to a base table
- D: For dynamic view generation
View Answer
A
Q658: The property of a transaction that ensures all steps are completed or none at all is known as _______.
- A: Consistency
- B: Isolation
- C: Atomicity
- D: Durability
View Answer
C
Q659: Which of the following is NOT a characteristic of a materialized view?
- A: It improves SQL execution performance
- B: It is updated when the master table changes
- C: It is transparent to SQL applications
- D: It can be used to create indexes
View Answer
D
Q660: In the context of transactions, "atomicity" refers to _______.
- A: The indivisibility of operations within a transaction
- B: The ability to handle multiple transactions simultaneously
- C: The ability to restore data to its original state
- D: The ability to update data without locking
View Answer
A