Database Essentials L1 Review

When is a database used?

• To perform searches for info on the internet
• To create and format text documents for sharing info
• To display information in a picture form instead of words
• To store and organize large amounts of information for quick searching

Databases store information in __________, which are made up of columns and rows.

• tabs
• tables
• ribbons
• image files

Relational databases consist of multiple tables of information that are related through:

• big data
• ID columns
• header rows
• common fields

Which type of application should you use if you need to "crunch" relatively small volumes of numeric data?

• Database
• Presentation
• Spreadsheet
• Word Processor

Which type of application should you use if you need to store a large quantity of data in an organized format that you can easily query?

• Database
• Presentation
• Spreadsheet
• Word Processor

Which statement about spreadsheets is true?

• Spreadsheet files can contain only a limited number of records.
• Spreadsheet files can contain an infinite number of records.
• Spreadsheet applications are generally complex, difficult and time-consuming to design.
• Database applications are used to "crunch" numbers for numeric analysis.

Which statement about databases is true?

• Database files are prone to inadvertent data corruption.
• Database files can contain only a limited number of records.
• Multiple people can use the same database data simultaneously.
• Database applications are used to "crunch" numbers for numeric analysis.

What is the term for a collection of data so large and complex that it is difficult to store and process using traditional database software?

• Big data
• Relational data
• Unrelated data
• Spreadsheet data

Which Microsoft Office application should you use for database creation and manipulation?

• Bing
• Excel
• Access
• Googl

Search engines consist of ________________ that contain information about webpages. 

• databases
• spreadsheets
• pre-defined queries
• big-data documents