Exploring Database Management Concepts

What is a database management system (DBMS)?

• A database management system (DBMS) is software that facilitates the creation, management, and manipulation of databases.

• A DBMS is a type of hardware used for data storage.

• A DBMS is a cloud service for file sharing.

• A DBMS is a programming language for web development.

Name three types of database models.

• Object-oriented model

• Relational model, Document model, Key-value model

• Hierarchical model

• Graph model

What is the purpose of SQL in database management?

• To create and design non-relational databases.

• To visualize data in graphical formats.

• The purpose of SQL in database management is to manage and manipulate relational databases.

• To perform statistical analysis on data sets.

Explain the difference between primary key and foreign key.

• A primary key can be duplicated across tables, while a foreign key cannot.

• A primary key uniquely identifies a record in a table, while a foreign key links to a primary key in another table.

• A primary key is used for indexing, while a foreign key is used for sorting records.

• A primary key is always a string, while a foreign key is always an integer.

What is normalization in the context of databases?

• Normalization refers to the encryption of sensitive data in databases.

• Normalization is the process of increasing data redundancy.

• Normalization in databases is the process of structuring data to minimize redundancy and dependency.

• Normalization is a method for backing up database files.

Describe the ACID properties in database transactions.

• ACID properties: Atomicity, Consistency, Isolation, Durability.

• Atomicity, Consistency, Isolation, Accessibility

• Atomicity, Clarity, Isolation, Reliability

• Accuracy, Clarity, Integrity, Stability

What is a relational database?

• A relational database is a collection of unstructured data.

• A relational database is a type of cloud storage service.

• A relational database is a software application for managing emails.

• A relational database is a database that organizes data into tables with defined relationships between them.

How do indexes improve database performance?

• Indexes slow down data retrieval by increasing the amount of data processed.

• Indexes eliminate the need for any data retrieval operations.

• Indexes enhance performance by speeding up data retrieval and reducing the need for full table scans.

• Indexes are only useful for small databases with few records.

What is the difference between a clustered and a non-clustered index?

• A clustered index sorts and stores the data rows in the table based on the index, while a non-clustered index creates a separate structure that references the data rows.

• Both clustered and non-clustered indexes store data in the same structure.

• A clustered index is always faster than a non-clustered index.

• A non-clustered index stores data rows in the same order as the index.

What are stored procedures and how are they used in databases?

• Stored procedures are used in databases to execute complex operations, manage transactions, and enforce business logic efficiently.

• Stored procedures are not related to transaction management.

• Stored procedures can only be executed manually by users.

• Stored procedures are only used for data retrieval.