Introduction to Databases

What is a database?

• A database is a type of software used for web development.

• A database is a physical location where data is stored.

• A database is an organized collection of data stored electronically.

• A database is a programming language for data manipulation.

Why do we use databases?

• We use databases to store and manage data efficiently.

• To create complex algorithms

• To enhance user interface design

• To increase hardware performance

What type of information can be stored in a database?

• Only text and numbers

• Only structured records and dates

• Only images and videos

• Text, numbers, dates, images, binary data, and structured records.

What is a table in a database?

• A table is a collection of unrelated files in a database.

• A table is a structured collection of data in rows and columns.

• A table is a type of database software.

• A table is a single row of data in a database.

What is a record in a database?

• A record is a single data type in a database.

• A record is a type of database software.

• A record is a command used to query a database.

• A record is a collection of related data items stored together in a database.

What is a field in a database?

• A field is a command used to query a database for information.

• A field is a type of database that contains multiple tables.

• A field is a column in a database table that stores specific data attributes.

• A field is a row in a database that holds all data entries.

What does it mean to query a database?

• To query a database means to delete data from it.

• To query a database means to request data from it.

• To query a database means to store data in it.

• To query a database means to create a new database.

Can you name a popular database software?

• PostgreSQL

• MySQL

• Oracle

• SQLite

What is the difference between a database and a spreadsheet?

• A database is for managing large datasets and complex queries, while a spreadsheet is for individual data analysis and simpler calculations.

• A database is primarily for creating presentations, while a spreadsheet is for writing code.

• A database can only be used by one person at a time, while a spreadsheet can be shared by many.

• A database is only for storing text files, while a spreadsheet is for images.

Why is it important to keep data organized in a database?

• To allow for unlimited data storage without limits.

• It is important to keep data organized in a database to ensure efficient retrieval, reduce redundancy, maintain integrity, and enhance security.

• To ensure data is stored in multiple locations.

• To make data look more appealing visually.