S3 Databases HW1

What is a database?

• A system that makes it easy to search, select, and store information.

• A system that only stores information.

• A system that only selects information.

• A system that only searches information.

In a database, what are rows referred to as?

• Fields

• Records

• Columns

• Tables

In a database, what are columns referred to as?

• Records

• Tables

• Fields

• Rows

Which of the following best describes the structure of a database?

• Rows as Fields and Columns as Records

• Rows as Records and Columns as Fields

• Rows as Tables and Columns as Records

• Rows as Fields and Columns as Tables

Which of the following is a data type that holds one of two values, such as true or false?

• Text

• Number

• Boolean

• Currency

Mr Smith is creating a database to track pupil progress. Which data type should he use to store test scores?

• Text

• Number

• Date/Time

• Picture

Which data type is used to store dates and times?

• Text

• Number

• Date/Time

• Currency

Which data type would you use to store a National Insurance Number?

• Text

• Number

• Date/Time

• Boolean

Rohan is creating a financial application. Which data type should he use to Net Pay?

• Text

• Number

• Date/Time

• Currency

What is a query?

• A specific request for information from a database

• A type of database

• A programming language

• A data storage method