Database Management System

Front

What is a database?

Back

A database is an organized collection of data that can be easily accessed, managed, and updated.

Front

What is the purpose of a DBMS?

Back

The purpose of a DBMS is to manage and organize data in a database.

Front

What are the different types of databases?

Back

Relational, NoSQL, In-memory, Time-series

Front

What is a relational database?

Back

A relational database is a database that organizes data into tables with defined relationships.

Front

What is a primary key?

Back

A primary key is a unique identifier for a record in a database.

Front

What is a foreign key?

Back

A foreign key is a field that links two tables by referencing the primary key of another table.

Front

What is normalization?

Back

Normalization is a database design technique that minimizes data redundancy and dependency.

Front

What is SQL?

Back

SQL is a programming language for managing relational databases.

Front

What does SQL stand for?

Back

Structured Query Language

Front

What is a SELECT statement used for?

Back

To retrieve data from a database.