Database Concepts-IGCSE Chap-9

What are the components of a single-table database?

• Fields

• Records

• Validation rules

• All of the above

Tags

LO1

Which term refers to a single piece of data in a database table?

• Fields

• Records

• Validation

• Primary Key

Tags

LO1

Which of the following is an example of a validation rule in a database field?

• Employee Name

• Customer ID

• Maximum allowed salary

• Sales Date

Tags

LO2

What is the purpose of defining validation rules for fields in a database?

• To limit the number of records

• To ensure data accuracy and integrity

• To make the database visually appealing

• To define primary keys

Tags

LO2

Suggest Suitable Basic Data Types: Which data type is suitable for storing names, addresses, or product descriptions in a database?

• Integer

• Text/alphanumeric

• Boolean

• Real

Tags

LO2

Which data type is used to store numerical values without decimals in a database?

• Integer

• Real

• Text/alphanumeric

• Date/time

Tags

LO2

When would you use the "Boolean" data type in a database?

• To store employee names

• To indicate whether an item is in stock (Yes/No)

• To store customer addresses

• To calculate total sales

Tags

LO2

Which data type is appropriate for storing dates and times in a database?

• Character

• Real

• Date/time

• Integer

Tags

LO2

What is the primary purpose of a primary key in a database table?

• To sort records in alphabetical order

• To provide a unique identifier for each record

• To allow multiple records with the same values

• To define data types for fields

Tags

LO3

In a database of students, which of the following could be a suitable primary key?

• Student name

• Student ID number

• Student's favorite subject

• Student's birthdate

Tags

LO3