NEW
Font size
WorksheetsDBMS Introductory Quiz
Total questions: 15
Worksheet time: 8mins
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
What is the role of designers in a DBMS?
Back up data
Work on the designing part of the database
Maintain the DBMS
Retrieve data
What are the different types of databases available in the market?
Centralized, Personal, Distributed, End-user, Commercial, Operational, Cloud, Relational
Centralized, Personal, Distributed, End-user, Commercial, Operational, Cloud, Relational, Object-oriented, Graph
Operational, Cloud, Relational, Object-oriented, Graph
Centralized, Personal, Distributed, End-user, Commercial
What is the purpose of a centralized database?
To complicate data retrieval
To increase data redundancy
To store data in multiple locations
To store data in a single location
What is the purpose of a cloud database?
To store data locally
To limit data access
To store data in a cloud environment
To decrease data consistency
What is the purpose of a relational database?
To store data in a relational format
To store data in a non-relational format
To decrease data consistency
To increase data redundancy
