What are the primary functions of a Database Management System (DBMS)?

The primary functions of a DBMS include data definition, data updation, data retrieval, and user administration.

Fill in the blank: The three tiers of a 3-tier architecture include the ___ tier, ___ tier, and ___ tier.

Data, application, user

True or False: The Entity-Relationship Model is based on entities and their relationships, which help in understanding data structure.

True

Riddle: I am a model that defines how data is connected and stored, often visualized with entities and attributes. What am I?

Entity-Relationship Model

What is the role of database administrators in a DBMS?

Database administrators maintain the DBMS, manage user access, ensure data security, and oversee system resources.

Fill in the blank: In a relational model, each row in a table is known as a ___ and each column represents a ___ from the same domain.

Tuple, attribute

Multiple Choice: Which of the following is NOT a characteristic of a DBMS? A) Automatic backup B) Data redundancy C) Data security D) Data integrity

B) Data redundancy

What does ACID stand for in the context of database management?

ACID stands for Atomicity, Consistency, Isolation, and Durability.

True or False: A DBMS allows multiple users to access the database simultaneously without maintaining data consistency.

False: A DBMS maintains data consistency even with multiple users accessing it.

Riddle: I separate users from data management, ensuring they interact through an intermediary. What am I?

Application (Middle) Tier