DBMS Quiz

Which of the following is a characteristic of a relational database?

• Hierarchical data organization

• Flat data structure

• Uses tables to organize data

• Object-oriented data storage

What is the primary purpose of a database management system (DBMS)?

• To store data in a hierarchical format

• To create spreadsheets

• To enable data to be easily stored, retrieved, and manipulated

• To perform statistical analysis

Which of the following is a database query language?

• HTML

• SQL

• CSS

• XML

In a database, what is a primary key?

• A key that can have duplicate values

• A unique identifier for a record in a table

• A key that is always NULL

• A key that links different databases together

Which operation is used to retrieve data from a database?

• DELETE

• INSERT

• UPDATE

• SELECT

What is a foreign key in a database?

• A key that is always unique

• A key that is used to link two tables together

• A key that is never indexed

• A key that contains only numeric values

What is a data warehouse?

• A system used for operational transaction processing

• A centralized repository for integrated data from multiple sources

• c. A database used for storing multimedia content

• d. A software application for designing databases

What is the purpose of a database schema?

• To encrypt data stored in the database

• To define the structure and organization of data

• To backup data in the database

• To manage user access permissions

What is the ACID property in databases?

• A standard for data encryption

• A set of properties ensuring reliable transactions

• A method for increasing database speed

• A tool for data visualization

What is a data mart?

• A large-scale database for enterprise data

• A subset of a data warehouse focused on a specific area

• A database for storing unstructured data

• A system for data mining