L2 ICT U1 Database Quiz

What is a database?

• A tool for data analysis.

• A collection of data that is organised in a way that makes it easily accessed and maintained.

• A type of software for creating websites.

• A digital version of a library's index system.

What is a flat-file database?

• A database with no tables.

• A database with several tables.

• A database with only one table.

• A database with more than one table.

What is a relational database?

• A database with no tables.

• A database with several tables.

• A database with only one table.

• A database with more than one table.

What is a record in the context of a database?

• A tool to manage data.

• A single entry in a database table.

• The structure that organizes tables within a database.

• A collection of related databases.

What would a record in a book store's database table typically store?

• The store's employee details.

• The details of a single book, such as ISBN, title, and price.

• The entire inventory of the store.

• The customer's purchase history.

What is a field in the context of a database table?

• A collection of related records

• A database management system

• An individual piece of data in a record

• The primary key of a table

Which of the following is NOT an example of a field in a database table?

• ISBN

• Book Title

• Genre

• Table of Contents

What type of data does the 'Text' data type store in a database?

• Alphanumeric values

• Numerical values only

• Date and time values

• Image and multimedia files

Which data type would be most appropriate for storing a book's price in a database?

• Text

• Number

• Data/Time

• Boolean

What can the 'Number' data type store?

• Only positive whole numbers

• Only text and symbols

• Whole numbers, floating point numbers, and negative values

• Only date and time values