Get started Bring yourself up to speed with our introductory content.

Quiz #8: Database Basics

Take our fun quiz on databases to see how your IT knowledge stacks up.

"To steal ideas from one person is plagiarism, to steal ideas from many is research." -Anon.

How to take the quiz:
After reading the question, click on the answer that you think is correct to go to the definition. If the answer you've chosen is correct, you will see the question text or an approximation of it somewhere in the definition.
After reading the question, write down the letter of your answer choice on scrap paper. Check your answers by using the answer key at the end of the quiz.

1. This is a collection of data items organized as a set of formally-described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables.
a. relational database
b. array
c. file allocation table
d. splay tree
e. Venn diagram

2. This is a standard interactive and programming language for getting information from and updating a database.
a. dynamic data exchange
b. Structured Query Language
d. Erlang programming language
e. WebLogic

3. In creating a database, this is the process of organizing it into tables in such a way that the results of using the database are always unambiguous.
a. probability
b. normalization
c. data modeling
d. query by example
e. virtual organization

4. In 1977, this company set out to prove that the prevailing theory that relationship databases lacked commercial viability, was wrong.
a. Hewlett-Packard
b. Oracle
c. Cognos
d. Solaris
e. Sybase

5. This IBM family of products is a relational database management system for large business computers.
a. DBA
b. B2B
c. PHP
d. RDF
e. DB2

6. This type of database, which can be used to mine data for business trends, doesn't require SQL queries, but instead allows a user to ask questions like "How many Aptivas have been sold in Nebraska so far this year?".
a. line information database
b. High Performance Storage System
c. object-oriented database management system
d. multidimensional database
e. functional specification

7. This is an open standard application programming interface (API) for accessing a database.
a. Universal Data Access
b. Open Database Connectivity
c. Topic Map Query Language
d. Open Data-Link Interface
e. command line interface

8. This term, used to describe a database that occupies magnetic storage in the terabyte range, describes a database that contains billions of table rows.
a. Very Large Database
b. holographic storage
c. Cold Fusion
d. giant
e. Electronic Data Interchange

9. This is a collection of descriptions about data objects that is created for the benefit of programmers and others who might need to refer to them.
a. data dictionary
b. stored procedure
c. Virtual File Allocation table
d. Virtual Address eXtension
e. catalog

10. This term is used to describe the process of forecasting, or simply discovering patterns in data that can lead to predictions about the future.
a. customer relationship management
b. PERT chart
c. data mining
d. enterprise risk management
e. histogram


To learn more about database programming, we recommend you visit our sister site, a member of the TechTarget community.

To learn more about databases, we recommend you visit our sister site, a member of the TechTarget community.

Be sure to try these other quizzes:

Quiz #1: Help Desk Basics
Quiz #2: Security Basics
Quiz #3: Data Storage
Quiz #4: Networking Hardware
Quiz #5: Getting Your Message Across the Network
Quiz #6: Servers
Quiz #7: Protocols
Quiz #8: Database Basics (you're on this quiz now)
Quiz #9: Wireless
Quiz #10: TCP/IP
Quiz #11: Ego-Booster
Quiz #12: Database II
Quiz #13: AS/400

ANSWER KEY:> 1a - 2b - 3b - 4b - 5e - 6d - 7b - 8a - 9a - 10c
Let us know how you did and suggest a topic for a future quiz! [email protected]

Dig Deeper on Topics Archive