Databases up to Validation

What does GDPR stand for?

• General Data Processing Regulation

• General Data Protection Regulation

• Global Data Privacy Rules

• General Data Privacy Regulation

What is a record in a database?

• A single piece of data in a field

• A collection of related fields for one person or thing

• A column in a database

• A method to sort data

Which of the following is an example of a field type?

• Record

• Primary Key

• Text

• Validation

What is the difference between a simple and complex sort?

• Simple sorts use multiple fields, complex sorts use one

• Simple sorts use one field, complex sorts use multiple fields

• Simple sorts organise data in ascending order only

• Complex sorts organise data in descending order only

Which of these is a complex search?

• Find all customers with the last name Smith

• Find all orders over £1000 in Glasgow

• Sorting all customers by their surname

• Filtering all records with missing fields

What is the purpose of a Primary Key in a database?

• To link two tables together

• To store foreign keys

• To ensure every record is unique

• To validate data

Which of these is an example of validation?

• Sorting records by last name

• Ensuring the date of birth field contains a valid date

• Linking two tables together using foreign keys

• Making sure that all field names are spelled correctly

What is a Foreign Key used for in a database?

• To store text data

• To sort data in a table

• To identify unique records

• To link tables together

Which of the following best describes a simple sort?

• Sorting data alphabetically using a single field

• Sorting data alphabetically using multiple fields

• Searching for data using one field

• Filtering based on specific criteria