WorksheetsDatabase Management System Quiz
Total questions: 20
Worksheet time: 10mins
A Database Management System (DBMS) is primarily used to:
Store data in files
Manage and retrieve data efficiently
Process programming logic
Perform only arithmetic operations
Which of the following is the oldest database model?
Relational model
Hierarchical model
Network model
Object-oriented model
One major advantage of a DBMS over a file system is:
Reduced data redundancy
Higher storage requirements
Increased manual processing
Faster data access in all cases
In a file-based system, data inconsistency occurs due to:
Lack of redundancy
Use of a structured format
Multiple copies of the same data
The presence of a DBMS
Which of the following is not a data model?
Relational model
Hierarchical model
Spreadsheet model
Network model
In the relational model, data is organized in:
Trees
Graphs
Tables
Records
The external level in a DBMS is also called:
Logical level
User view level
Physical level
Storage level
The physical level of abstraction describes:
How data is stored in the database
The structure of tables and relationships
User interactions with the database
The logical representation of data
Logical data independence refers to:
Changing the physical schema without modifying logical schema
Changing the logical schema without modifying the external schema
Changing the external schema without modifying the logical schema
The ability to store redundant data
Which type of data independence protects applications from changes in physical storage structures?
Logical data independence
Conceptual data independence
Physical data independence
None of the above
The query processor in a DBMS is responsible for:
Managing transactions
Optimizing and executing queries
Handling user authentication
Data storage and retrieval
The DBMS component that ensures consistency and handles transaction failures is called:
Query Processor
Storage Manager
Transaction Manager
Data Dictionary
What is the purpose of an ER diagram?
To write SQL queries
To visually represent database structure
To execute database transactions
To store data directly
An attribute that can have multiple values is called a:
Simple attribute
Composite attribute
Multivalued attribute
Derived attribute
A weak entity is one that:
Has a primary key
Cannot exist without a related entity
Is independent of other entities
Contains only multivalued attributes
In the ER model, a relationship represents:
A physical storage mechanism
A connection between two or more entities
A type of query execution plan
A file storage system
Generalization in an ER model refers to:
Combining multiple entities into a higher-level entity
Splitting an entity into multiple sub-entities
Creating duplicate data
Eliminating foreign keys
Specialization is the process of:
Creating a general entity from multiple sub-entities
Creating a subclass from a higher-level entity
Eliminating attributes from an entity
Merging two tables in a relational database
In relational algebra, the projection operator is used to:
Select specific columns from a relation
Retrieve rows that satisfy a condition
Combine two relations
Remove duplicate rows
The Cartesian product in relational algebra results in:
The union of two tables
The difference of two tables
A combination of all rows from two tables
The division of one table by another
