71. 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)

72. 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

(c) ROLAP

(d) HOLAP

Answer: (b)

73. 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)

74. 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)

75. 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)

76. 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)

77. 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)

78. 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)

79. 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)

80. 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)