Database Fundamentals Quiz

What is a database?

• A type of computer

• A collection of books

• An organized collection of data

• A type of software

What is a record in a database?

• A row that stores information about a particular item

• A column that stores the same type of data

• A table of metadata

• A report

What is a field in a database?

• A row in the database

• A column that stores the same type of data

• A type of report

• A type of query

What is a DBMS?

• A device for storing physical data

• A software for managing and protecting data

• A programming language

• A library system

Which of the following is an example of a DBMS?

• Excel

• MySQL

• Photoshop

• PowerPoint

Which data type should you use for storing names?

• Number

• Text

• Date/Time

• Currency

Which data type should be used for storing birthdates?

• Text

• Number

• Date/Time

• Currency

Which data type is best for storing the price of an item?

• Text

• Number

• Currency

• Date/Time

What is the purpose of a query in a database?

• To create tables

• To perform operations like search, sort, and filter

• To protect data

• To manage user access

What does a report in a database do?

• Organizes tables

• Shows requested information in a specific format

• Deletes unwanted records

• Adds metadata