Introduction to Databases

What is the primary purpose of a database?

• To store and organise data efficiently

• To create visually appealing presentations

• To perform complex mathematical calculations

• To develop video games

What does each row in a single-table database represent?

• Record

• Table

• Field

• Database

Which term describes a column in a database table?

• Record

• Field

• Entity

• Query

Which data type would be most suitable for storing a student's date of birth?

• Integer

• Text/Alphanumeric

• Boolean

• Date/Time

What data type would you use to store whether a product is in stock (yes or no)?

• Real

• Character

• Boolean

• Integer

What is the main function of a primary key in a database table?

• To store the most important information

• To calculate values based on other fields

• To uniquely identify each record

• To sort the records in alphabetical order

Which of the following could be a suitable primary key for a table storing information about books?

• Title

• Author

• Publication Year

• ISBN

What is SQL primarily used for?

• Writing computer programs

• Interacting with databases

• Creating spreadsheets

• Designing web pages

What is the term for an instruction written in SQL to retrieve specific data from a database?

• Command

• Function

• Script

• Querry

Which SQL command is used to filter records based on specific criteria?

• SELECT

• FROM

• WHERE

• ORDER BY