Browse Definitions:

Quiz: Database II

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 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!

This was last updated in August 2008

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.


File Extensions and File Formats


  • risk map (risk heat map)

    A risk map, also known as a risk heat map, is a data visualization tool for communicating specific risks an organization faces. A...

  • internal audit (IA)

    An internal audit (IA) is an organizational initiative to monitor and analyze its own business operations in order to determine ...

  • pure risk (absolute risk)

    Pure risk, also called absolute risk, is a category of threat that is beyond human control and has only one possible outcome if ...


  • federated identity management (FIM)

    Federated identity management (FIM) is an arrangement that can be made among multiple enterprises to let subscribers use the same...

  • cross-site scripting (XSS)

    Cross-site scripting (XSS) is a type of injection security attack in which an attacker injects data, such as a malicious script, ...

  • firewall

    In computing, a firewall is software or firmware that enforces a set of rules about what data packets will be allowed to enter or...



  • business continuity and disaster recovery (BCDR)

    Business continuity and disaster recovery (BCDR) are closely related practices that describe an organization's preparation for ...

  • business continuity plan (BCP)

    A business continuity plan (BCP) is a document that consists of the critical information an organization needs to continue ...

  • call tree

    A call tree -- sometimes referred to as a phone tree -- is a telecommunications chain for notifying specific individuals of an ...


  • volume manager

    A volume manager is software within an operating system (OS) that controls capacity allocation for storage arrays.

  • external storage device

    An external storage device, also referred to as auxiliary storage and secondary storage, is a device that contains all the ...

  • NetApp SolidFire

    NetApp SolidFire is a business division of NetApp Inc. that specializes in all-flash storage systems.


  • hybrid hard disk drive (HDD)

    A hybrid hard disk drive is an electromechanical spinning hard disk that contains some amount of NAND Flash memory.