Quiz: Database II - Quiz from WhatIs.com
Part of the Database glossary:

Some of you may have found our "Quiz: Database Basics" not quite challenging enough, so here's a tougher one. Good luck!

How to take the quiz:
- After reading the question, click on the answer that you think is correct to go to the whatis.com definition. If the answer you've chosen is correct, you will see the question text somewhere in the definition.
- Check your answers by using the answer key at the end of the quiz.

1) At this level of normalization, each column in a table that is not a determiner of the contents of another column, must itself be a function of the other columns in the table.
a) 1NF
b) 2NF
c) 3NF

2) This method of online analytical processing stores data in both a relational and a multimdimensional database.

3) Which technology was Microsoft's first attempt at an object-oriented database interface?
a) MQSeries
b) ADO
c) DAO
d) UDA

4) What concept would a data modeler NOT be expected to know?
a) class
b) object
c) UML
d) FMP

5) Which of the following tree structures is unique in that the tree organization varies depending on which nodes are most frequently accessed?
a) B-tree
b) binary tree
c) quad tree
d) splay tree

6) The basic unit of this SQL variant is called a block.
b) XQL

7) The acronym ACID is typically used in reference to:
a) transactions
b) CRM analytics
c) data integrity
d) stubs

8) A Database Management System (DBMS) may be used by, or combined with, this type of transaction manager.
a) DB2
c) Oracle
d) Cognos

9) Encapsulation, types, classes, inheritance, overriding combined with late binding, and extensibility are all features of this type of database.
a) multidimensional database
b) relational database
c) object-oriented
d) open source

10) A programmer using this type of middleware might need the Interface Definition Language (IDL).
a) RPC
b) ORB
c) MUD
d) EAI


Scroll down for answer key:








ANSWERS: 1b;2a;3c;4d;5d;6a;7a;8b;9c;10b
Let us know how you did! contactus@whatis.com

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

Related Terms


  • structured data

    - Structured data contrasts with unstructured and semi-structured data. The three can be considered to exist on a continuum, with unstructured data being the least formatted and structured data being... (WhatIs.com)


    - SAP S/4HANA is the next generation of the Business Suite ERP platform, built on the SAP HANA in-memory platform. S/4HANA aims to be easier to use and administer to allow enterprises to solve more c... (SearchSAP.com)

  • MPP database (massively parallel processing database)

    - An MPP database is a database that is optimized to be processed in parallel for many operations to be performed by many processing units at a time. (SearchDataManagement.com)


  • 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 About Quiz: Database IIPowered by ITKnowledgeExchange.com

Get answers from your peers on your most technical challenges

Tech TalkComment



    Contribute to the conversation

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