Database L3 Exit Ticket

Why might Samuel want to sort the customer records in a database table at his retail store?

• A) To make it more difficult for Hannah and Ava to find customer information

• B) To organize the records randomly

• C) To arrange the records in a specific order for easier access during sales analysis

• D) To delete unnecessary customer information

Answer explanation

Samuel might want to sort the customer records in a database table at his retail store to arrange the records in a specific order for easier access during sales analysis.

Imagine Ava is working on a customer database. Which of the following actions can she perform on a customer record?

• A) Paint

• B) Add, delete, or modify

• C) Sing

• D) Exercise

Answer explanation

Ava can add, delete, or modify a customer record, making option B the correct choice.

How should a database developed for James, Emma, and Avery's startup be according to the overview?

• Complicated and secure

• Easy for people to work with

• Inexpensive to maintain

• Difficult to access

Answer explanation

The database should be easy for people to work with according to the overview, making it user-friendly and accessible for James, Emma, and Avery's startup.

David is working on a school project and needs to add new student records to the project's database table. What is the term for this action?

• Delete record

• Sort record

• Insert record

• Update record

Answer explanation

Adding new student records to a database table is referred to as inserting a record, making 'Insert record' the correct term in this context.

Imagine Abigail is working on a school project to manage a library database. What is the purpose of the Design View in this database?

• To delete records

• To sort records

• To export records

• To create and modify the structure of a database table

Answer explanation

The Design View in a database is used to create and modify the structure of a database table, making it the correct choice for managing a library database.

Why is understanding how databases work beneficial for Nora as she develops her new website?

• It helps Nora in programming mobile applications for her website.

• It helps Nora in understanding how her website and online services she uses work.

• It is only necessary for IT professionals like Grace and Priya.

• It helps Nora in creating graphics for her website.

Answer explanation

Understanding how databases work is beneficial for Nora as it helps her in understanding how her website and online services she uses work.

In the Datasheet View of a database, what action can James perform?

• Create and edit a spreadsheet.

• Create and edit a presentation.

• Create and edit a field in a table.

• Create and edit a text document.

Answer explanation

James can create and edit a field in a table in the Datasheet View of a database, making this the correct choice.

Imagine Jackson is working on a database for his project. What does a Datasheet View display when Jackson views his database?

• A) A single record in a form layout

• B) Fields in a table similar to how it would look in a spreadsheet

• C) A graphical representation of data

• D) A detailed report with summaries

Answer explanation

The Datasheet View displays fields in a table similar to how it would look in a spreadsheet, allowing Jackson to view and interact with the data in a tabular format.

In a Datasheet View of a student database containing records of students like Daniel, Evelyn, and Aria, what are columns referred to as?

• A) Records

• B) Fields

• C) Values

• D) Entries

Answer explanation

In a Datasheet View, columns are referred to as Fields, which represent the different categories of information for each record.

In Evelyn's database for tracking book inventory, what are rows called in the Datasheet View?

• A) Fields

• B) Records

• C) Data points

• D) Headers

Answer explanation

In Evelyn's database for tracking book inventory, rows are called Records in the Datasheet View.