Understanding Database Management Systems

What is a Database Management System (DBMS)?

• A DBMS is a cloud service for file sharing.

• A Database Management System (DBMS) is software that manages databases.

• A DBMS is a programming language for data analysis.

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

Name three types of DBMS.

• Document DBMS

• Hierarchical DBMS, Network DBMS, Relational DBMS

• Key-value DBMS

• Object-oriented DBMS

What is the primary purpose of a DBMS?

• To perform complex calculations on data.

• To create user interfaces for applications.

• To store, retrieve, and manage data in databases.

• To ensure data is visually appealing.

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

• Relational databases do not support transactions.

• Relational databases use structured tables and SQL, while non-relational databases use flexible formats and do not require fixed schemas.

• Non-relational databases require SQL for data manipulation.

• Relational databases are only used for large datasets.

What is SQL and how is it used in DBMS?

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

• SQL is a type of hardware used for data storage.

• SQL is a markup language for web development.

• SQL is a database management system itself.

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

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

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

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

• Data integrity refers to the speed of data retrieval.

What are primary keys and foreign keys in a database?

• Primary keys can be duplicated across tables.

• Primary keys uniquely identify records in a table; foreign keys link records between tables.

• Foreign keys are used to store images in a database.

• Primary keys are used for indexing data only.

What is normalization and why is it important in database design?

• Normalization is important in database design because it minimizes data redundancy, ensures data integrity, and simplifies data management.

• Normalization is only for large databases

• Normalization increases data redundancy

• Normalization complicates data management

Describe what a database schema is.

• A database schema is a type of software application.

• A database schema is a blueprint that outlines the structure of a database, including tables, fields, data types, and relationships.

• A database schema is a collection of user accounts and permissions.

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

What are some common examples of DBMS software?

• Apache Hadoop

• Microsoft Excel

• MySQL, PostgreSQL, Oracle Database, Microsoft SQL Server, MongoDB, SQLite

• FileMaker Pro