IC3 Database Applications 2

Question 1

What is a 'flat file' database?

Accepted Answer

A single table database with no relationships to other tables

Answer

A flat file database contains all data in a single table with no links or relationships to other tables, making it simple but limited for complex data.

Question 2

In a relational database, what connects two related tables?

Accepted Answer

A foreign key

Answer

A foreign key is a field in one table that references the primary key of another table, creating the relationship between the two tables.

Question 3

Which of the following is an example of a database management system (DBMS)?

Accepted Answer

Microsoft Access

Answer

Microsoft Access is a DBMS that provides tools for creating, organizing, querying, and managing databases.

Question 4

When sorting database records in ascending order on a 'Last Name' field, which entry appears first?

Accepted Answer

Anderson

Answer

Ascending alphabetical order starts from A; 'Anderson' begins with 'A', placing it before names starting with later letters.

Question 5

What does 'filtering' records in a database mean?

Accepted Answer

Displaying only records that meet specific criteria

Answer

Filtering temporarily hides records that do not meet the specified criteria, showing only the relevant subset of data without deleting anything.

IC3 - Digital Literacy Certification Practice Test

IC3 - Digital Literacy Certification Practice Test

IC3 Database Applications 2