Worksheets9.1 Databases Cambridge IGCSE 0478
Total questions: 10
Worksheet time: 5mins
What is a single-table database?
A database with all data stored in one table.
A database that stores only one type of data.
A database that uses multiple tables for efficiency.
A database that cannot store numeric data.
What is a field in a database table?
A column in a database table that holds a specific type of data.
A row in a table representing a single record.
A unique identifier for each record in the table.
A validation rule applied to all records.
Which of the following is NOT a valid data type for a field in a database?
Fractional
Integer
Boolean
Text
Why is a primary key important in a database?
It ensures each record has a unique identifier.
It prevents duplicate field names.
It speeds up data retrieval in all cases.
It encrypts data in the database.
Which SQL statement is used to retrieve all records from a table named Students?
SELECT * FROM Students;
GET ALL FROM Students;
FIND * IN Students;
SHOW Students;
What does the following SQL query do? SELECT * FROM Employees WHERE Age > 30;
Retrieves all records from the Employees table where the Age field is greater than 30.
Deletes all employees older than 30 from the table.
Updates the Age column for all employees older than 30.
Sorts employees in ascending order based on age.
Which SQL statement would return the number of students in a table named Students?
SELECT COUNT(*) FROM Students;
SELECT SUM(*) FROM Students;
COUNT ALL FROM Students;
SELECT COUNT(Students);
What will the following SQL query return? SELECT Name FROM Customers ORDER BY Name ASC;
A list of customer names sorted in ascending order (A-Z).
A list of customer names sorted in descending order (Z-A).
All customer data, sorted by name.
A count of all customer names.
Which SQL keyword is used to filter records based on a specific condition?
WHERE
FILTER
CHECK
CONDITION
What does the OR operator do in an SQL WHERE clause?
It allows multiple conditions where at least one must be true.
It allows only one condition to be true.
It filters records based on a single condition.
It sorts records in ascending order.
