G11-Flashcard-Semester 1 Exam review

Front

What is the purpose of a database?

Back

To store data in a structured way

Front

What does DBMS stand for?

Back

Database Management System

Front

Which scenario is best suited for a flat database instead of a relational database?

Back

A small contact list where all data can be stored in a single table without redundancy.

Front

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

Back

To link to the primary key of another table

Front

What is a query?

Back

A request for data from a database

Front

Which language is used to communicate with and manipulate databases?

Back

SQL

Front

Which key is shared in symmetric encryption?

Back

A single shared secret key

Front

What is the purpose of database validation?

Back

To ensure data is accurately recorded and meets specific criteria

Front

What does database verification involve?

Back

Checking and confirming the accuracy of stored data

Front

What is a data type in a database?

Back

A way to define the format of data that can be stored in a field