What is a Database?

What is a database?

• A structured set of data held in a computer, especially one that is accessible in various ways.

• A type of software that allows you to browse the internet.

• A programming language used for web development.

• A hardware device used to store data.

Answer explanation

A database is defined as a structured set of data stored in a computer, allowing for various access methods. This distinguishes it from software, programming languages, or hardware devices.

How can a database be compared to a physical object?

• A database can be compared to a filing cabinet where data is stored in an organized manner.

• A database can be compared to a random pile of papers.

• A database can be compared to a locked safe with no access.

• A database can be compared to a blank sheet of paper.

Answer explanation

A database is like a filing cabinet because it organizes data systematically, making it easy to retrieve and manage, unlike a random pile of papers or a locked safe that restricts access.

Which of the following is a common database program?

• Microsoft Word

• Microsoft Excel

• Microsoft Access

• Microsoft PowerPoint

Answer explanation

Microsoft Access is a database program designed for creating and managing databases, while Word, Excel, and PowerPoint are primarily word processing, spreadsheet, and presentation software, respectively.

How is information stored in a database?

• In tables with rows and columns

• In a single flat file

• In a hierarchical structure

• In a spreadsheet format

Answer explanation

Information in a database is stored in tables with rows and columns, allowing for structured data organization and easy retrieval. This format is fundamental to relational databases, making it the correct choice.

What are 'field headings' used for in a database?

• To label columns in a table

• To store data

• To perform calculations

• To create relationships between tables

Answer explanation

Field headings are used to label columns in a database table, providing clear identifiers for the data stored in each column. This helps users understand the type of data contained in each field.

What is the data type used for names and short pieces of writing?

• String

• Integer

• Boolean

• Float

Answer explanation

The correct data type for names and short pieces of writing is 'String'. Strings are used to represent text, while Integers, Booleans, and Floats are used for numerical and logical values.

What data type is used for values we might need to calculate?

• Integer

• String

• Boolean

• Float

Answer explanation

The correct data type for values we might need to calculate is Integer. Integers are whole numbers that can be used in mathematical operations, making them suitable for calculations.

Which data type is used for storing dates like birthdays?

• String

• Date

• Integer

• Boolean

Answer explanation

The 'Date' data type is specifically designed to store date values, such as birthdays. Unlike strings or integers, it provides built-in functionality for date manipulation and formatting, making it the correct choice for this purpose.

What is the data type used for money amounts?

• Integer

• Float

• Decimal

• String

Answer explanation

The correct data type for money amounts is Decimal. This type allows for precise representation of fractional values, which is essential for accurate financial calculations, unlike Float which can introduce rounding errors.

Which data type is used for simple true/false answers?

• Boolean

• Integer

• String

• Float

Answer explanation

The Boolean data type is specifically designed to represent true/false values, making it the correct choice for simple true/false answers. Other types like Integer, String, and Float do not serve this purpose.