Retest Lesson 1 Database 1st period

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

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

• header rows

• common fields

• ID columns

• big data

If I want to crunch relatively small amounts of numbers which do I use?

• Database

• Presentation

• Word Processor

• Spreadsheets

Which should you use to store large amounts of data in an organized format that you can perform a query on

• Spreadsheets

• Databases

• Presentations

• Graphics

What is true about spreadsheets?

• They can contain an infinite number of records

• Spreadsheets are complex

• Spreadsheet files can contain only a limited number of records.

• Spreadsheet tables can be related through common fields

Which is true about databases?

• Database applications are used to "crunch" numbers for numeric analysis.

• Database files can contain only a limited number of records.

• Multiple people can use the same database data simultaneously.

• Easy to learn

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

• Excel

• Bing

• Google

• Access

Search engines consist of ___________________ that contain information about webpages.

• Spreadsheets

• Pre-defined queries

• Big Data documents

• Databases

You have a large collection of related data. You want to use a relational database but your partner wants to use a spreadsheet. Which of the following would you share with your partner as an advantage of using databases instead of spreadsheets?

• Databases is only made up of worksheets

• Only 1 person can use a database at a time

• Databases remove the need for redundant data

• Databases are easy yo learn

Louis will be using his database to support his new web-based trading card shop. The database will need to insert, update and delete information about his customers, the trading cards he buys and sells and orders for the cards themselves. What language will he use to access and modify the information in his database through his website?

• SQL

• Jave

• HTML

• C++