ICT Database Essentials - Lesson 2 (from Clozed Notes)

What is a group of fields in a table related to a single entity called?

• Record

• Field

• Column

• Cell

What is the purpose of a primary key in a database?

• To uniquely identify each record in a table

• To allow duplicate records in a table

• To create a backup of the database

• To encrypt the data in the database

In a one-to-one table relationship, each record in Table A can have how many matching records in Table B?

• One

• Two

• Many

• None

What is a junction table used for in a database?

• A junction table is used in a database to establish a many-to-many relationship between two tables.

• A junction table is used to store temporary data during database transactions.

• A junction table is used to create a backup of the database.

• A junction table is used to index the database for faster search results.

What is the range of characters that a Text data type can hold?

• 1-255

• 256+

• 1-9

• Unlimited

Fill in the blank: Integer data type is used for ______ values, such as calculations and distance.

• integer

• string

• boolean

• float

What is the precision of a Float data type?

• Unlimited

• 10

• 16

• 5

True or False: Currency data type describes numeric values that describe money.

• True

• False

What type of values does the Yes/No data type hold?

• True / False
• Data/Time

• Short Text

• Numbers

Fill in the blank: Memo data type is used for long formatted text fields more than ______ characters.