Database Concepts Quiz

What is a record in a database?

• A column in a table

• A row in a table

• A type of query

• A user interface

What is the smallest piece of information for an entity in a database?

• Record

• Field

• Query

• Form

What is the purpose of action queries in a database?

• To retrieve data

• To change data like adding, updating, and deleting

• To create reports

• To automate tasks

What is the main function of reports in a database?

• To automate tasks

• To present data in different views and formats

• To change data

• To retrieve data

Which of the following is a guideline for naming tables?

• Use only numbers

• Use spaces

• Use letters, numbers, and underscores

• Use lowercase letters only

How many types of relationships are there in databases?

• 1

• 2

• 3

• 4

Which type of relationship is the most common in databases?

• One to one

• One to many

• Many to many

• None of the above

What is the role of queries in a database?

• To create tables

• To ask questions about data

• To automate tasks

• To present data

In a "One to Many" relationship, which table is considered the parent?

• The table with fewer records.

• The table on the right.

• The table on the left.

• The table with more records.

What is one benefit of using forms in databases?

• They make it harder to work with individual records.

• They offer less flexibility in organizing fields.

• They allow updating parent and child records simultaneously.

• They prevent any updates to records.