Quiz: Unleashing the Power of the Database - Quiz from WhatIs.com

Quiz

Quiz: Unleashing the Power of the Database

Part of the Database glossary:

How to take the quiz:
- After reading the question, click on the answer that you think iscorrect to go to the whatis.com definition. If the answer you've chosenis correct, you will see the question text (or a paraphrase of it) somewhere in the definition.
OR
- After reading the question, write down the letter of your answerchoice on scrap paper. Check your answers by using the answer key at the end of the quiz, where you'll also find additional resources related to the correct answer.

1. This is a type of program that lets one or more computer users create, manage, and access data in a database.
a. B2B
b. DBMS
c. multidimensional database
d. Electronic Data Interchange
e. High Performance Storage System

2. In a relational database, this is a data structure that organizes the information about a single topic into rows and columns.
a. block
b. record
c. tuple
d. table
e. command line interface

3. This is a family of relational database management system products from IBM that serve a number of different operating system platforms.
a. Cognos
b. DB2
c. ADO
d. Universal Data Access
e. WebLogic

4. This is a central repository for all or significant parts of the data that an enterprise's various business systems collect.
a. data repository
b. business information warehouse
c. knowledge warehouse
d. data mart
e. data warehouse

5. This is the job title of someone who directs or performs all activities related to maintaining a successful database environment.
a. DBA
b. MOLAP
c. PHP
d. RFC
e. DDBMS

6. This is a common standard language used to update and get information from a database.
a. VB
b. TMQL
c. PHP
d. SQL
e. VLDB

7. This is a file format that contains the values in a table in which column values are separated by a comma and each row starts a new line.
a. ASCII
b. data dictionary
c. CSV file
d. virtual organization
e. functional specification

8. In a relational database, this is the data structure that holds a single piece of data, such as first name or phone number.
a. catalog
b. field
c. entity
d. object
e. row

9. This is an organized selection of data from a database that allows you to look at it from a particular perspective.
a. Venn diagram
b. Gantt chart
c. B-tree
d. splay tree
e. view

10. This a program tool allows you to reorganize and summarize selected columns and rows of data in a spreadsheet or database table to obtain a desired report.
a. pivot table
b. PERT chart
c. quad tree
d. ODBC
e. normalization

SCROLL DOWN FOR ANSWER KEY

















See the rest of our quiz topics
Answer Key:

1.) b. DBMS


SearchDatabase has assembled a handy compendium of DBMS tips and scripts.

2.) d. table
There's more information about tables in this SearchDatabase tip on Optimizing database performance.

3.) b. DB2
Search390 provides a collection of resources about DB2 .

4.) e. data warehouse
SearchCRM maintains a page of Best Web Links for data warehousing .

5.) a. DBA
Sara Cushman's SearchDatabase article is called "Starting over as a DBA."

6.) d. SQL
SearchVB provides a selection of Best Web Links for SQL .

7.) c. CSV file
SearchDatabase SQL Server Expert Tony Bain offers advice about exporting data to a CSV file .

8.) b. field
Barrie Sosinsky's SearchDatabase tip explains how to create Serial ID fields .

9.) e. view
Michael V. Mannino's SearchDatabase tip offers advice on creating Multi-table updateable views .

10.) a. pivot table
SearchDatabase offers more information in its Best Links for Microsoft Access .

To learn more, see our guide, Learn IT: Unleashing the Power of the Database .

This was last updated in July 2008
Posted by: Margaret Rouse

Related Terms

Definitions

  • enterprise search

    - Enterprise search is the organized retrieval of structured and unstructured data within an organization. (WhatIs.com)

  • data profiling

    - Data profiling, also called data archeology, is the statistical analysis and assessment of the quality of data values within a data set for consistency, uniqueness and logic.   (SearchDataManagement.com)

  • XKeyscore

    - XKeyscore (XKS) is the front end search engine interface that interacts with all NSA  federated databases for the collected Internet traffic, communicated data and phone metadata of private citizens. (WhatIs.com)

Glossaries

  • Database

    - Terms related to databases, including definitions about relational databases and words and phrases about database management.

  • Internet applications

    - This WhatIs.com glossary contains terms related to Internet applications, including definitions about Software as a Service (SaaS) delivery models and words and phrases about web sites, e-commerce ...

Ask a Question. Find an Answer.Powered by ITKnowledgeExchange.com

Ask An IT Question

Get answers from your peers on your most technical challenges

Ask Question

Tech TalkComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.