DBMS Quiz 1 for DSE

Which of the following is a key characteristic of a database?

• Redundancy

• Data independence

• Data duplication

• Data isolation

Which of the following is not a type of database model?

• Relational

• Hierarchical

• NoSQL

• File-based

Which of the following is not a valid attribute type in ER modeling?

• Composite attribute

• Derived attribute

• Subtype attribute

• Simple attribute

Which of the following is not a common role of a DBA?

• Database design

• Data backup and recovery

• User interface development

• Performance tuning

What is the primary purpose of the storage manager in a DBMS?

• To manage memory resources

• To manage disk storage

• To optimize query performance

• To enforce data constraints

In a relational database, what is an index used for?

• To store data

• To enforce data integrity constraints

• To speed up data retrieval

• To define the data structure

Data abstraction in a database system refers to:

• Hiding the complexity of the hardware

• Hiding the complexity of the software

• Hiding the complexity of the data structure

• Hiding the complexity of the user interface

Which component of a DBMS system architecture is responsible for managing database transactions?

• Query processor

• Storage manager

• Transaction manager

• User interface

The term "ACID" in the context of database systems stands for:

• Atomicity, Consistency, Isolation, Durability

• Access, Control, Isolation, Data

• Availability, Consistency, Isolation, Durability

• All Columns In Database

In an ER diagram, what is an attribute?

• A relationship between entities

• A property or characteristic of an entity

• An instance of an entity

• A category of entities