Database Management System Quiz

What is the purpose of a DBMS?

• Managing databases and their contents

• Storing physical hardware components

• Creating network protocols

• Generating programming languages

What is the purpose of a data dictionary in a database system?

• To manage user access permissions

• To store the database schema

• To optimize query execution plans

• To provide a description of data elements

Define the concept of data consistency in a database.

• Ensuring data uniqueness across tables

• Guaranteeing data accuracy and validity

• Maintaining data in alphabetical order

• Minimizing data redundancy

Describe the difference between a logical and a physical database model.

• Logical model focuses on data storage, while physical model focuses on data representation

• Logical model defines the structure, while physical model deals with implementation details

• Logical model emphasizes query optimization, while physical model emphasizes data retrieval

• Logical model simplifies data access, while physical model ensures data integrity

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

• Atomicity, Control, Isolation, Durability

• Accuracy, Consistency, Isolation, Durability

• Atomicity, Consistency, Isolation, Durability

• Accuracy, Control, Isolation, Durability

What is a schema in a database?

• A specific SQL query

• A collection of related tables

• A visual representation of data

• A logical structure of the database

What is the purpose of data normalization?

• To increase data redundancy

• To minimize data duplication and dependency

• To maximize data storage capacity

• To simplify data retrieval operations

What does CRUD stand for in the context of databases?

• Create, Read, Update, Destroy

• Create, Register, Update, Delete

• Copy, Retrieve, Update, Delete

• Collect, Retrieve, Update, Destroy

What is a primary key in a relational database?

• A key used for encryption purposes

• A unique identifier for each record in a table

• A key that identifies foreign tables

• A common field in multiple tables

What is the purpose of a candidate key in a relational database?

• It is an alternate key used for encryption purposes

• It is a potential primary key within a table

• It represents a foreign key from another table

• It is a composite key made up of multiple attributes