Database Management System Quiz

Avani is trying to understand what a database management system (DBMS) is. She learns that it is essential for managing data effectively. What is a database management system (DBMS)?

• A programming language

• Software to create, update, and retrieve data

• A type of hardware

• A system for managing books

Which of the following is an example of a DBMS?

• LibreOffice Base

• MS Word

• Adobe Photoshop

• Notepad

What does a primary key do in a database?

• It is used for data backup

• It stores images

• It uniquely identifies a record in a table

• It allows duplicate entries

Which data model organizes data in a tree-like structure?

• Hierarchical Data Model

• Relational Data Model

• Network Data Model

• Flat File Model

What is the purpose of a foreign key in a database?

• To uniquely identify a record

• To create a relationship between two tables

• To store images

• To delete records

Which of the following is NOT a type of data model?

• Hierarchical Data Model

• Network Data Model

• Relational Data Model

• Linear Data Model

What is data redundancy?

• The organization of data

• The process of deleting data

• The accuracy of data

• Storing the same data in multiple places

Which of the following describes a one-to-many relationship?

• One record in a master table corresponds to multiple records in a transaction table

• Multiple records in a master table correspond to one record in a transaction table

• One record corresponds to one record

• No relationship exists

Which of the following options allows a user to delete or update a referenced field along with related records in a transaction table?

• Update cascade

• Set NULL

• No action

• Set default

What is the primary purpose of a form in a database?

• To store data

• To create queries

• To present data in a user-friendly format

• To delete records