Databases

Question 1

What is a foreign key in a relational database?

A) A field that always holds text values

B) A unique field within a table

C) A field in a child table that links to a primary key in the parent table

D) A reserved SQL keyword

Answer 1

C) A field in a child table that links to a primary key in the parent table

Question 2

Which of the following are standard objects found in a database? (Multiple Response)

A) Tables

B) Forms

C) Graphs

D) Stylesheets

E) Queries

F) Reports

Answer 2

A) Tables

B) Forms

E) Queries

F) Reports

Question 3

What is a primary key, and can you give one example?

Answer 3

A unique identifier in a table that ensures each record is distinct

Example: Student ID or Employee Number

Question 4

What do cascade updates and deletes do in a relational database?

A) They sort the data in ascending order

B) They remove duplicates across all tables

C) They automatically update or delete related records in a child table

D) They encrypt sensitive fields

Answer 4

C) They automatically update or delete related records in a child table

Question 5

What are the advantages of using lookup lists and default values in a database? (Multiple Response)

A) Slows system performance

B) Faster data entry

C) Ensures access to cloud storage

D) Reduces input errors

Answer 5

B) Faster data entry

D) Reduces input errors

Question 6

What is a major disadvantage of a flat file database compared to a relational database?

A) It uses too many tables

B) Data is often duplicated and harder to update/manipulate

C) It supports multiple users more effectively

D) It cannot be printed

Answer 6

B) Data is often duplicated and harder to update/manipulate