Databases and Search Engines Quiz

Show all answers     Hide all answers

Completion

1. QBE stands for _____________   _____________   _____________. Answer Query by Example
2. SQL stands for _____________   _____________   _____________. Answer Structured Query Language
3. ODBC stands for _____________   _____________   _____________. Answer Open Database Connectivity
4. JDBC stands for _____________   _____________   _____________. Answer Java Database Connectivity
5. CGI stands for _____________   _____________   _____________. Answer Common Gateway Interface
6. DBA stands for _____________   _____________. Answer Database Administrator
7. DBMS stands for _____________   _____________   _____________. Answer Database Management System

Short answer

8. Explain what a database is. Answer A database is a collection of data that can be searched and sorted.
9. Explain what a record is. Answer A record is a collection of information about a specific entity, such as an employee or a transaction.
10. Explain what a field is. Answer A record is composed of fields, with each field being a particular type of information, such as a last name, date of birth, room number.
11. Explain what a table is. Answer Records of the same type are grouped into tables.
12. Explain what a relational database is. Answer A relational database is a database with multiple tables where tables are related to each other through the use of common fields.
13. Explain what a key field is. Answer Key fields are used to identify individual records in a table and to relate records between tables.
14. Explain what a primary key is. Answer A primary key is a field which contains values that uniquely identify each record in a table.
15. Explain what a foreign key is. Answer A foreign key is a field in a table which is used to hold values the same as a primary key in another table. This is how tables are related in a relational database.
16. Explain what a query is. Answer A query is a request for specific data from a database.
17. Explain what a junction table is. Answer A junction table is used to break an unsupported many-to-many relationship into two one-to-many relationships.
18. Describe at least five criteria you would use to evaluate the credibility of a web page. Answer
    1. Is the information current?
    2. Is the source an expert in the field?
    3. Is the material peer-reviewed by experts?
    4. Is the material presented in a professional and organized manner?
    5. Does the material have a bias or an agenda?
    6. How does the material compare to other sources that both agree and disagree?
    7. Is the material relevant?

Matching

Identify the letter of the choice that best matches the phrase or definition.

1. search engine
2. web directory
3. metasearch engine
4. web bibliography
5. spider
6. hit
7. query
8. meta tag
19. used to search for specific information Answer A (search engine)
20. submits queries to many search engines at once Answer C (metasearch engine)
21. a program that automatically follows links and catalogs the Web Answer E (spider)
22. used to browse categories for information in general Answer B (web directory)
23. used to specify information about a web page such as keywords Answer H (meta tag)
24. a page that matches search criteria Answer F (hit)
25. a request for information Answer G (query)
26. contains lists of resources on specific topics Answer D (web bibliography)