WorksheetsDatabase Management Systems Quiz
Total questions: 30
Worksheet time: 15mins
What is a Database Management System (DBMS)?
A type of hardware
A network protocol
A software for managing databases
A programming language
Which of the following is a characteristic of a database?
Data redundancy
Data inconsistency
Data integrity
Data isolation
What does SQL stand for?
Structured Query Language
Simple Query Language
Standard Query Language
Sequential Query Language
Which of the following is an example of a Relational DBMS?
MongoDB
MySQL
Cassandra
Neo4j
What is the primary purpose of metadata?
To store user data
To perform data analysis
To describe data properties
To manage database security
Which architecture separates the user interface from the database?
2-tier architecture
4-tier architecture
1-tier architecture
3-tier architecture
What is the main advantage of using a DBMS?
Increased data redundancy
Centralized data management
Manual data processing
Limited user access
What type of relationship is represented by a diamond shape in an ER diagram?
Attribute
Entity
Weak entity
Relationship
Which of the following is NOT a type of database model?
Linear Model
Hierarchical Model
Relational Model
Object-oriented Model
What does data independence refer to?
Data redundancy
Data stored in multiple locations
Data security measures
Separation of data from applications
Which of the following is a disadvantage of using a DBMS?
Centralized data access
Increased data security
Improved data integrity
High overhead costs
What is a weak entity in an ER model?
An entity with multiple attributes
An entity that cannot be uniquely identified
An entity that has no relationships
An entity with a primary key
Which of the following describes a one-to-many relationship?
One entity is associated with one entity
No entities are associated
One entity is associated with multiple entities
Multiple entities are associated with one entity
What is the role of a Database Administrator (DBA)?
To perform data entry
To design hardware
To manage database security and integrity
To develop applications
Which of the following is a benefit of using a relational database?
Data is stored in a flat file
Data can be easily queried using SQL
Data cannot be related to other data
Data is always unstructured
What does normalization in a database refer to?
Reducing data redundancy
Enhancing data security
Increasing data duplication
Creating backup copies
Which of the following is a common use of a database index?
To increase data redundancy
To manage user permissions
To speed up data retrieval
To store large amounts of data
What is the purpose of a foreign key in a relational database?
To store large amounts of data
To establish a relationship between two tables
To uniquely identify a record
To improve data retrieval speed
Which of the following is a feature of a NoSQL database?
ACID transactions
Support for unstructured data
Table-based structure
Fixed schema
What does the term 'data integrity' refer to in a database?
Ensuring data is accurate and consistent
Storing data in multiple formats
Increasing data redundancy
Limiting data access to authorized users
Which SQL command is used to remove a table from a database?
DROP
DELETE
REMOVE
TRUNCATE
What is the purpose of a primary key in a database?
To establish relationships between tables
To uniquely identify each record in a table
To store large amounts of data
To improve data retrieval speed
What is the purpose of a data model in a database?
To create backups
To define the structure of data
To perform data entry
To manage user permissions
Which SQL command is used to update existing records in a table?
UPDATE
MODIFY
CHANGE
ALTER
Which of the following best describes a many-to-many relationship?
Multiple entities are associated with multiple entities
Multiple entities are associated with one entity
One entity is associated with multiple entities
One entity is associated with one entity
Which SQL command is used to create a new table in a database?
CREATE
INSERT
ADD
NEW
What does the term 'schema' refer to in a database context?
The process of data normalization
The method of data encryption
The structure that defines the organization of data
The physical storage of data
Which SQL command is used to retrieve data from a database?
SELECT
GET
FETCH
RETRIEVE
What is a characteristic of a relational database?
Data cannot be related
Data is stored in tables
Data is unstructured
Data is stored in key-value pairs
Which SQL command is used to delete records from a table?
REMOVE
ERASE
DROP
DELETE
