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 database stored on a USB flash drive

Answer

A database that uses compressed file formats

Answer

A database that only stores image files

Question 2

In a relational database, what connects two related tables?

Accepted Answer

A foreign key

Answer

A form

Answer

A report

Answer

A macro

Question 3

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

Accepted Answer

Microsoft Access

Answer

Microsoft PowerPoint

Answer

Adobe Photoshop

Answer

Mozilla Firefox

Question 4

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

Accepted Answer

Anderson

Answer

Williams

Answer

Martinez

Answer

Thompson

Question 5

What does 'filtering' records in a database mean?

Accepted Answer

Displaying only records that meet specific criteria

Answer

Deleting unwanted records permanently

Answer

Sorting records in a different order

Answer

Merging two tables into one

Question 6

Which type of query would you use to change the price field for all records where 'Category' equals 'Electronics'?

Accepted Answer

Update query

Answer

Select query

Answer

Append query

Answer

Crosstab query

Question 7

What is data validation in a database context?

Accepted Answer

Rules that control what data can be entered into a field

Answer

The process of encrypting sensitive data

Answer

A method of compressing the database file

Answer

A backup procedure for the database