IBPS SO | IT OFFICER QUIZ - 6

DBMS

1. This method of online analytical processing stores data in both a relational and a multi dimensional database.

a. HOLAP

b. ROLAP

c. OLAP

d. DIMM

2. Which technology was Microsoft's first attempt at an object oriented database interface ?

a. MQseries

b. ADO

c. DAO

d. UDA

3. Which concept would a data modeler would NOT be expected to know ?

a. Class

b. Object

c. UML

d. FMP

4. Which of the following tree structures is unique in that the tree organisation varies depending upon which nodes are most frequently used ?

a. B-tree

b. Binary tree

c. quad tree

d. splay tree

5. The basic unit of this SQL variant is a block.

a. PL/SQL

b. XQL

c. SQLJ

d. TMQL

6. The acronym ACID is typically used in reference to

a. Transactions

b. CRM analytics

c. Data integrity

d. Stubs

7. A database management system (DBMS) may be used by, or combined with, this type of a transaction manager.

a. DB2

b. CICS

c. Oracle

d. Cognos

8. Encapsulation, types, classes, inheritance, overriding combined with late binding, and extensiblity all are features of this type of database

a. Multidimensional database

b. Relational database

c. Object-oriented

d. Open source

9. A programmer using this type of middleware might need the interface definition language (IDL).

a. RPC

b. ORB

c. MUD

d. EAI

10. This is a collection of data items organised as a set of formally - described tables from which data can be accessed or reassembled in many different ways without having to reorganise the database tables.

a. Relational database

b. Array

c. File allocation table

d. splay table

#Answers
1. A
2. C
3. D
4. D
5. A
6. A
7. B
8. C
9. B
10. A