Data & Databases (Beginner level)

Question 1

What is “data”?

Answer 1

Information that can be stored, processed, and analyzed by computers.

Question 2

What are common types of data?

Answer 2

Text, numbers, images, audio, video, and sensor readings.

Question 3

What does a database do?

Answer 3

It stores data in an organized way so it can be easily searched, updated, and managed.

Question 4

What’s the difference between data and a database?

Answer 4

Data is the raw information; a database is the system that organizes and manages it.

Question 5

What are tables in a database?

Answer 5

Structured collections of data arranged in rows and columns.

Question 6

What are rows in a database table?

Answer 6

Individual records — each row represents one entry (like one user or one product).

Question 7

What are columns in a database table?

Answer 7

Attributes or fields — each column stores one type of data (like “Name,” “Email,” or “Price”).

Question 8

What’s a record in database terms?

Answer 8

A single complete set of information stored in one row of a table.

Question 9

What does “relational database” mean?

Answer 9

A database that organizes data into related tables that can connect through shared information.

Question 10

What’s an example of a relational database?

Answer 10

MySQL, PostgreSQL, SQLite, or Microsoft SQL Server.

Question 11

What is SQL short for?

Answer 11

Structured Query Language.

Question 12

What is SQL used for?

Answer 12

Communicating with a database to create, read, update, or delete data.

Question 13

What does “query” mean in databases?

Answer 13

A request to retrieve or manipulate data stored in the database.

Question 14

What does CRUD stand for?

Answer 14

Create, Read, Update, Delete — the four main operations you can perform on data.

Question 15

What is a primary key?

Answer 15

A unique identifier for each record in a table.

Question 16

What is a foreign key?

Answer 16

A field in one table that links to the primary key in another, connecting related data.

Question 17

What is a “relationship” between tables?

Answer 17

A link showing how data in one table relates to data in another (like “Customers” and “Orders”).

Question 18

What’s the difference between a database and a spreadsheet?

Answer 18

A spreadsheet is simpler and manual; a database is designed for larger, structured, and automated data management.

Question 19

What’s a “database management system” (DBMS)?

Answer 19

Software that helps create, maintain, and interact with databases.

Question 20

Give an example of how databases are used daily.

Answer 20

Saving your login info, tracking your online purchases, or storing messages in an app.

Question 21

What’s a NoSQL database?

Answer 21

A non-relational database that stores data in flexible formats like documents or key-value pairs.

Question 22

When are NoSQL databases used?

Answer 22

When data is unstructured or constantly changing (like social media feeds or user activity logs).

Question 23

What’s the key difference between SQL and NoSQL?

Answer 23

SQL databases use structured tables; NoSQL databases use flexible, non-tabular structures.