NEW
Font size
WorksheetsIntroduction to Databases
Total questions: 12
Worksheet time: 4mins
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
What SQL command would you use to arrange query results in alphabetical order?
ORDER BY
SUM
FROM
SELECT
Which command is used to calculate the total quantity of a specific item from an "Orders" table?
COUNT(*)
SUM(Quantity)
SELECT Quantity
FROM Orders
