ICT 2 Database Review

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