9.1 Databases Cambridge IGCSE 0478

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.