Week 3

Question 1

acts as a bridge between databases and applications

Answer 1

database middleware

Question 2

manages communication between objects in a distributed system

Answer 2

object middleware

Question 3

provides interfaces for web based applications

Answer 3

web application servers

Question 4

facilitates message exchange between distributed applications

Answer 4

message oriented middleware (mom)

Question 5

enables communication between applications without knowing each other’s internal workings

Answer 5

application programming interface (api)

Question 6

function of staging area in data warehousing

a. clean and transform data before loading

b. directly load data into the warehouse

Answer 6

clean and transform data before loading

Question 7

role of database middleware

a. generating reports

b. facilitating communication between databases and applications

Answer 7

facilitating communication between databases and applications

Question 8

primary purpose of data warehouse

Answer 8

store and analyze data

Question 9

all parts of transaction are completed or none

Answer 9

atomicity

Question 10

data changes are saved even after failure

Answer 10

durability

Question 11

transactions do not interfere with each other

Answer 11

isolation

Question 12

involves loading data into a data warehouse after it has been cleaned and performed

Answer 12

ETL

Question 13

acts as a bridge between a user interface and backend systems

Answer 13

portals

Question 14

how does multidimensional database differ from a relational database

a. designed for quick analysis of large databases

b. uses tables to store related data

Answer 14

designed for quick analysis of large databases