DBMS Flashcard

Front

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

Back

Uses tables to organize data

Front

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

Back

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

Front

Which of the following is a database query language? HTML, SQL, CSS, XML

Back

SQL

Front

In a database, what is a primary key?

Back

A unique identifier for a record in a table

Front

Which operation is used to retrieve data from a database? Options: DELETE, INSERT, UPDATE, SELECT

Back

SELECT

Front

What is a foreign key in a database?

Back

A key that is used to link two tables together

Front

What is a data warehouse?

Back

A centralized repository for integrated data from multiple sources.

Front

What is the purpose of a database schema?

Back

To define the structure and organization of data

Front

What is the ACID property in databases?

Back

A set of properties ensuring reliable transactions

Front

What is a data mart?

Back

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