Understanding Database Management Systems

What is a Database Management System (DBMS)?

• A Database Management System (DBMS) is a programming language for web development.

• A Database Management System (DBMS) is a type of hardware used for data storage.

• A Database Management System (DBMS) is software that facilitates the creation, management, and manipulation of databases.

• A Database Management System (DBMS) is a cloud service for file sharing.

Name three types of DBMS.

• Hierarchical DBMS, Network DBMS, Relational DBMS

• Columnar DBMS

• Object-oriented DBMS

• Document DBMS

What is the primary purpose of a DBMS?

• The primary purpose of a DBMS is to manage and facilitate the storage, retrieval, and manipulation of data in databases.

• To provide a user interface for web development.

• To ensure data is stored in physical files only.

• To create and design new programming languages.

Explain the difference between a relational and a non-relational database.

• Relational databases store data in JSON format.

• Relational databases are only used for large datasets.

• Relational databases use structured tables and SQL, while non-relational databases use flexible formats and various query methods.

• Non-relational databases require SQL for data manipulation.

What is SQL and how is it used in databases?

• SQL is a programming language used to manage and manipulate relational databases.

• SQL is a type of database software.

• SQL is used for creating web applications.

• SQL is a markup language for designing web pages.

Define the term 'data integrity' in the context of databases.

• Data integrity refers to the speed of data retrieval in a database.

• Data integrity is the process of backing up data regularly.

• Data integrity is the accuracy, consistency, and reliability of data in a database.

• Data integrity means the amount of data stored in a database.

What are primary keys and foreign keys?

• Primary keys uniquely identify records in a table, while foreign keys create relationships between tables by referencing primary keys.

• Primary keys can be duplicated across tables.

• Primary keys are used for indexing data only.

• Foreign keys are always numeric values.

What is normalization in database design?

• Normalization in database design is the process of structuring a database to minimize redundancy and dependency by organizing fields and tables.

• A technique for encrypting database information.

• A method to increase data redundancy in databases.

• A way to combine multiple databases into one.

Describe the ACID properties in database transactions.

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

• Atomicity, Consistency, Isolation, Accessibility

• Accuracy, Clarity, Integrity, Reliability

• Atomicity, Concurrency, Isolation, Timeliness

What is a database schema?

• A database schema is the organizational blueprint of a database that outlines how data is structured and related.

• A database schema is a physical storage location for data.

• A database schema is a programming language used for data manipulation.

• A database schema is a type of software application.