Browse Definitions :
Quiz

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 whatis.com definition. If the answer you've chosen is correct, you will see the question text somewhere in the definition.
OR
- 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
d) DKNF

2) This method of online analytical processing stores data in both a relational and a multimdimensional database.
a) HOLAP
b) ROLAP
c) OLAP
d) DIMM

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.
a) PL/SQL
b) XQL
c) SQLJ
d) TMQL

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
b) CICS
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! [email protected]

This was last updated in August 2008
SearchCompliance
  • OPSEC (operations security)

    OPSEC (operations security) is a security and risk management process and strategy that classifies information, then determines ...

  • smart contract

    A smart contract is a decentralized application that executes business logic in response to events.

  • compliance risk

    Compliance risk is an organization's potential exposure to legal penalties, financial forfeiture and material loss, resulting ...

SearchSecurity
  • DOS (disk operating system)

    A DOS, or disk operating system, is an operating system that runs from a disk drive. The term can also refer to a particular ...

  • private key

    A private key, also known as a secret key, is a variable in cryptography that is used with an algorithm to encrypt and decrypt ...

  • security token

    A security token is a physical or digital device that provides two-factor authentication for a user to prove their identity in a ...

SearchHealthIT
SearchDisasterRecovery
  • What is risk mitigation?

    Risk mitigation is a strategy to prepare for and lessen the effects of threats faced by a business.

  • change control

    Change control is a systematic approach to managing all changes made to a product or system.

  • disaster recovery (DR)

    Disaster recovery (DR) is an organization's ability to respond to and recover from an event that affects business operations.

SearchStorage
  • What is RAID 6?

    RAID 6, also known as double-parity RAID, uses two parity stripes on each disk. It allows for two disk failures within the RAID ...

  • PCIe SSD (PCIe solid-state drive)

    A PCIe SSD (PCIe solid-state drive) is a high-speed expansion card that attaches a computer to its peripherals.

  • VRAM (video RAM)

    VRAM (video RAM) refers to any type of random access memory (RAM) specifically used to store image data for a computer display.

Close