Database Design Quiz

What is the primary purpose of a database?

• To replace the need for data analysis.

• To store information in a physical format.

• To store and retrieve information easily and efficiently.

• To create complex data structures only.

Which software is considered the best program to create a database?

• PowerPoint

• Microsoft Access

• Word

• Excel

What type of data does Big Data refer to?

• Only numerical data collected from users.

• Small datasets that can be easily managed.

• Very large and diverse sets of structured and unstructured data.

• Data that remains static over time.

What is a primary key in a database?

• A type of software used for database creation.

• A field that uniquely identifies each record in a table.

• A form of data analysis.

• A field that is repeated throughout the table.

In Microsoft Access, what do you click to create a new database?

• Home and then Create

• File and then New

• File and then Open

• Create and then Save

What allows users to enter, modify or delete information in a database?

• Tables

• Reports

• Forms

• Queries

Which view in Microsoft Access is used for entering and displaying table data?

• Design View

• Datasheet View

• Form View

• Report View

What are queries used for in a database?

• To store data in a compressed format.

• To obtain data according to specific criteria or conditions.

• To permanently delete data from the database.

• To backup database files.

What is an advantage of using databases?

• Ease of storing and retrieving data.

• Higher costs for data management.

• Increased complexity in data handling.

• Limitation on the amount of data stored.

What is required to create relationships between data in a database?

• Paint

• Internet Explorer

• Notepad

• Microsoft Access