DBMS Introduction and Architecture

What is a Database Management System (DBMS)?

• A collection of data

• Software to manage databases

• A data model

• None of the above

Which of the following is not a type of database model?

• Relational

• Hierarchical

• Network

• Binary

Which component of a DBMS is responsible for data storage and retrieval?

• Query Language

• Data Dictionary

• Storage Manager

• Transaction Manager

What is the purpose of a Data Dictionary in a DBMS?

• It contains data records.

• It stores metadata about the database.

• It manages user access to data.

• It executes queries.

Which of the following is a non-relational database management system?

• Oracle

• MySQL

• MongoDB

• PostgreSQL

In a relational database, what is a primary key used for?

• Sorting data

• Ensuring data integrity

• Creating foreign keys

• Storing metadata

What is SQL an abbreviation for?

• Structured Query Language

• Standard Query Language

• Simple Query Language

• System Query Language

Which of the following is not a SQL data type?

• Integer

• Boolean

• String

• Loop

What is normalization in the context of database design?

• Reducing data redundancy

• Adding more data to tables

• Improving query performance

• Creating backup copies

What is the purpose of the SQL SELECT statement?

• To insert data into a table

• To update records in a table

• To retrieve data from a table

• To delete data from a table