Quiz: Database Basics

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
c. ASCII
d. Erlang programming language
e. WebLogic

3. In creating a database, this is the process of organizing it into tables insuch 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 family of products is IBM's cross-platform relational database management system.
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 torefer 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

SCROLL DOWN FOR ANSWER KEY

















See the rest of our quiz topics

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! contactus@whatis.com

Learn more about Microsoft SQL Server 2000

Do you have something to add to this definition? Let us know. Send your comments to techterms@whatis.com

FILE EXTENSION AND FILE FORMAT LIST File Extension and File Format List: A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

RELATED CONTENT Track changes to SQL Server 2000 and 2005 with one simple utility SQL Server triggers have limits when tracking changes. Use scripts in this utility to monitor SQL Server 2000 and 2005 for new objects, logins and... Is it possible to find disabled indexes in SQL Server 2000? If you're working with SQL Server 2000 and trying to find a disabled index, here's something you should know. FAQ: Creating and altering SQL Server tables Selecting rows, moving records and tracking table activity are a few of the tasks discussed in this SQL Server tables FAQ.

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary application server  (SearchSQLServer.com) comma-separated values file  (SearchSQLServer.com)