Quiz #12: Database II

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



Some of you may have found our "Quiz #8: 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 or an approximation of it somewhere in the definition.
OR
- After reading the question, write down the letter of your answer choice on scrap paper. 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) transaction
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

Be sure to take:


Quiz #1: Help Desk Basics
Quiz #2: Security Basics
Quiz #3: Data Storage
Quiz #4: Networking Hardware
Quiz #5: Getting Your Message Across the Network
Quiz #6: Servers
Quiz #7: Protocols
Quiz #8: Database Basics
Quiz #9: Wireless
Quiz #10: TCP/IP
Quiz #11: Ego-Booster
Quiz #12: Database II (you're on this Quiz now)
Quiz #13: AS/400










To learn more about database programming, we recommend you visit our sister site searchVB.com, a member of the TechTarget community.

To learn more about databases, we recommend you visit our sister site searchDatabase.com, a member of the TechTarget community.

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

Dig deeper on Data governance and management for SOA

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchSoftwareQuality

SearchCloudApplications

SearchAWS

TheServerSide

SearchWinDevelopment

Close