Introduction to Databases Quiz

What is a database?

• A random assortment of files

• A temporary storage of information

• A structured, persistent collection of data

• A collection of unstructured data

Which type of database is covered in the IGCC syllabus?

• Relational databases

• Network databases

• Hierarchical databases

• Flat file databases

What does a flat file database consist of?

• Multiple related tables

• A single table with no records

• One or more tables with separate records

• A collection of unrelated files

How are tables in a relational database connected?

• By using common fields

• By using unique identifiers

• By using foreign keys

• By using primary keys

What is the main difference between flat file and relational databases?

• Flat file databases have multiple related tables

• Relational databases do not use primary keys

• Relational databases have a single table

• Flat file databases consist of one or more tables without relations

What is a primary key?

• A field that stores date and time

• A field that can be duplicated

• A field that is guaranteed to be unique

• A field that stores text data

Which of the following is NOT a field type in databases?

• Text

• Array

• Integer

• Boolean

What is the purpose of validation rules in a database?

• To create primary keys

• To store data temporarily

• To link tables together

• To ensure data is entered correctly

Which validation rule checks if a field is not empty?

• Length check

• Format check

• Presence check

• Range check

Which field type would be suitable for storing a car registration number?

• Date/Time

• Boolean

• Integer

• Text