Database Fundamentals

What software should we use to create a database?
Select the best answer.

• Excel
• Access
• OneNote
• Word

A ________ in a database is used to hold a single item of data, such as "pupilName".

• Table
• Record
• Cell
• Field

A row of fields in a database is known as:

• A column
• A cell reference
• A record
• A table

A row of fields in a database is known as:

• A column
• A cell reference
• A record
• A table

A ________ in a database is used to hold a single item of data, such as "pupilName".

• Table
• Record
• Cell
• Field

To search a database, we create a

• Sort
• Query
• Report
• Table

Which query could be used to find all pupils who are at least 13 years old in a pupil database?

• age >13
• age<13
• age>=13
• age<=13

A database management system (DBMS) is a:

• Software system used to create, maintain, and provide controlled access to a database
• Hardware system used to create, maintain, and provide controlled access to a database
• Hardware system used to create, maintain, and provide uncontrolled access to a database
• Software system used to create, maintain, and provide uncontrolled access to a database

A unique identifying field.

• Primary Key
• Integer
• Verification
• Boolean

The four main objects of a database consist of:

• form, table, query, report

• filter, table, database, query

• form, data type, record, query

• form, record, field, report