QUIZZ 3 : DATABASE FUNDAMENTALS

Why does data inside a database need to be organized?

• “So the data can be found when needed”

• “So the data can be searched from the Internet”

• "So the data is neat and tidy”

• “So data integrity can be maintained”

Sorting from A-Z is also called a descending sort.

• “True”

• “False”

A query for a report can come from multiple tables.

• “True”

• “False”

What is it called when you want to see database records in a certain order?

• “Filter”

• “Search”

• “Sort”

• “Report”

Descending means sorting from:

• “Smallest to largest”

• “Largest to smallest”

Which of the following is used for data that will be sorted in alphabetical order or listed randomly, but will not be used in mathematical calculations.

• text
• number
• memo
• calculations

Which of the following is used for data that may be calculated, sorted, or filtered.

• text
• number
• memo
• field

What data type is used to format numbers as decimal values with a dollar sign?

• currency
• number
• text
• memo

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 database application can perform which of the following activities?

• Add records
• Display / read records
• Update records
• All of the above