1. Which one of the following supports basic OLAP operations, including slice-and-dice, drill-down, roll-up and pivoting?

(a) Information processing
(b) Analytical processing
(c) Transaction processing
(d) Data mining

Answer: (b)

2. Which one of the following systems is customer-oriented and is used for transaction and query processing by Clerks, Clients and IT professionals?

(a) OLAP
(b) OLTP

Answer: (b)

3. In the discretization technique, if the discretization process uses class information then it is:

(a) Top-down discretization
(b) Bottom-up discretization
(c) Supervised discretization
(d) Un-supervised discretization

Answer: (c)

4. In which one of the following data transformations the low-level or primitive (raw) data are replaced by higher-level concepts through the use of concept hierarchies?

(a) Smoothing
(b) Aggregation
(c) Normalization
(d) Generalization

Answer: (d)

5. The database which is partitioned across multiple disks and parallel processing occurs within a specific task that is performed concurrently on different processors against different sets of data, is:

(a) Vertical parallelism
(b) Horizontal parallelism
(c) Inter-query parallelism
(d) Intra-query parallelism

Answer: (b)

6. In a distributed transaction processing system, a transaction should satisfy the properties of:

(a) RPC
(b) ACID
(c) Nested transactions
(d) MOM (Message Oriented Middleware)

Answer: (b)

7. The distributed systems containing devices which are often characterized by small, battery-powered, mobile, adopt to contextual changes, encourage ad hoc composition and recognize sharing are called:

(a) Distributed Computing Systems
(b) Cloud Computing Systems
(c) Distributed Information Systems
(d) Distributed Pervasive Systems

Answer: (d)

8. Which one of the following architectural styles of distributed systems is based on publish/subscribe systems?

(a) Event-based architectures
(b) Object-based architectures
(c) Data-centered architectures
(d) Layered architectures

Answer: (a)

9. In a decentralized distributed system architecture where the tables of distributed relational databases, are split column-wise and distributed across multiple machines, is called:

(a) Horizontal distribution
(b) Overlay distribution
(c) Three-tiered distribution
(d) Vertical distribution

Answer: (d)

10. In a distributed system, the interface suitable for development work in high-performance server clusters and can handle more advanced features of buffering and synchronization is:

(a) RPC (Remote Procedure Call)
(b) Berkeley Socket Interface
(c) XTI (Open Transport Interface)
(d) MPI (Message-Passing Interface)

Answer: (d)