DBMS Introductory Quiz

What does DBMS stand for?

• Data Business Management System

• Digital Business Management System

• Data Backup Management System

• Database Management System

Why was DBMS introduced?

• To reduce data consistency

• To complicate data retrieval

• To overcome deficiencies in traditional data management

• To increase data redundancy

What is the purpose of using real-world entities in a modern DBMS?

• To confuse users

• To design a more realistic architecture

• To increase data isolation

• To decrease data consistency

What is the benefit of normalization in DBMS?

• Increases data redundancy

• Decreases data consistency

• Splits a relation to reduce redundancy

• Combines attributes to increase redundancy

What is the role of query language in DBMS?

• Increases data redundancy

• Slows down data processing

• Decreases data isolation

• Makes data retrieval and manipulation more efficient

What are the ACID properties in DBMS?

• Atomicity, Consistency, Isolation, Dependency

• Accuracy, Consistency, Isolation, Durability

• Atomicity, Consistency, Isolation, Delay

• Atomicity, Consistency, Isolation, Durability

What does multiuser and concurrent access support in DBMS?

• Allows only one user at a time

• Does not allow data manipulation

• Limits data access to one user

• Supports multiple users accessing data in parallel

What is the purpose of multiple views in DBMS?

• To confuse users

• To provide different views for different users

• To limit data access

• To decrease data consistency

What is the significance of security features in DBMS?

• To decrease data consistency

• To increase data redundancy

• To impose constraints on data access

• To allow unrestricted access to all users

Who are the administrators in a DBMS?

• Users who retrieve data

• Users who back up data

• Users who maintain and administrate the database

• Users who design the database