Home > Computers 101 > Quizzes > Computers 101 Practice Test: Databases and Database Management Systems
Computers 101 Practice Test: Databases and Database Management Systems
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 21% Most missed: “Database designers work with systems analysts and other individuals involved in …”
Computers 101 Practice Test: Databases and Database Management Systems
Time left 00:00
25 Questions

1. A record is also called a ____.
2. ____ are made up of related records.
3. If a new database is to be used with existing data, the data needs to be transferred from its existing form into the new system—a process called ____.
4. With a ____, a database is located in its entirety on a single computer, such as a server or mainframe computer.
5. The ____ contains all data definitions for a database, including table structures, security information, relationships between the tables in the database, and so on.
6. The key characteristics for an OODBMS (including objects, attributes, methods, ____, and inheritance) are similar to object-oriented programming principles.
7. In ____, the table field involved in the changes is locked until the changes to that field have been completed.
8. Middleware for Web database applications is commonly written as ____—short sections of code written in a programming or scripting language that are executed by another program.
9. The figure above illustrates a ____, created from data contained in a database.
10. The field in a table that is used to relate that table to other tables is called the ____.
11. Individual database tables are often referred to as ____.
12. The JL Group is in the process of creating dynamic Web pages to poll politically aware young adults. They are interested in creating scripts that are compatible with many types of databases, so they are using the ____ language.
13. ____ actually create the database, based on the design generated by the database designer, and get it ready for data entry.
14. The process of evaluating and correcting the structures of the tables in a database to minimize data redundancy is called ____.
15. Database designers work with systems analysts and other individuals involved in ____.
16. In ASPs, the code to tie the database to the Web site is typically written in JavaScript or ____.
17. One of the simplest hashing algorithms involves dividing the primary key field by a particular ____.
18. A ____ is a collection of related fields.
19. Most DBMSs come bundled with a set of tools to perform a variety of necessary tasks, such as building user interfaces, creating forms and reports, and interfacing with query languages and ____ for complex applications.
20. A(n) ____ is a small table consisting only of a list of the primary key field for each record in a table along with location information for that record.
21. A field is also called a ____.
22. ____ databases are designed to store a collection of summarized data for quick and easy data analysis.
23. The characteristics of an entity are called ____.
24. Web-based database requests are received by the Web server, which then converts the request into a database query and passes it on to the database server with the help of software called ____.
25. With ____, the computer uses each record’s primary key field and a mathematical formula called a hashing algorithm to determine a unique address that identifies where the record is physically stored in the database file.