Database Management System (DBMS) Quiz

What is a Database Management System (DBMS)?

• A hardware component for data storage

• A software tool for creating and managing databases

• A programming language for database queries

• A type of network protocol

Which of the following is NOT a function of a DBMS?

• Data backup and recovery

• Data integrity and security

• Data visualization and reporting

• Data storage, retrieval, and management

What does ACID stand for in the context of transaction management?

• Analysis, Consistency, Isolation, Design

• Application, Connection, Input, Data

• Atomicity, Consistency, Isolation, Durability

• Access, Control, Integrity, Data

Which type of lock allows multiple transactions to read the same data but not modify it?

• Exclusive Lock

• Shared Lock

• Row-level Lock

• Table-level Lock

What is the purpose of serialization in a DBMS?

• To ensure data is stored in a compressed format

• To provide user authentication

• To manage concurrent transactions correctly

• To optimize query performance