Database Essentials

When is a database used? 

• To perform searches for information on the Internet 
• To create and format text documents for sharing information 
• To display information in a picture form instead of using 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 numbers to analyze 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 an infinite number of records.
• Spreadsheet files can contain only a limited number of records.
• Spreadsheet applications are generally complex, difficult and time-consuming to design.
• Spreadsheet tables can be related through common fields, thereby eliminating redundant data. 

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 
• Google 

Search engines consist of ___________________ that contain information about webpages.

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