cs614 mid term solve paper april 2011

[Vuhelper]

[size=12]full solve paper in attachment [/SIZE]


Question No: 1 ( Marks: 1 ) - Please choose one
The need to synchronize data upon update is called

Data Manipulation

Data Replication

Data Coherency

Data Imitation
Question No: 2 ( Marks: 1 ) - Please choose one
Taken jointly, the extract programs or naturally evolving systems formed a spider web
also known as

Distributed Systems Architecture

Legacy Systems Architecture

Online Systems Architecture

Intranet Systems Architecture
Question No: 3 ( Marks: 1 ) - Please choose one
For good decision making, data should be integrated across the organization
LoB (Line of Business). This is to give the total view of organization from:

Owner’s Perspective

Customer’s Perspective

Decision Maker’s Perspective

Employee's Perspective
Question No: 4 ( Marks: 1 ) - Please choose one
Node of a B-Tree is stored in memory block and traversing a B-Tree involves ______
page faults.
Question No: 5 ( Marks: 1 ) - Please choose one
Which statement is true for De-Normalization?

Redundant data is a performance liability at query time, but is a performance
benefit at update time.

Redundant data is a performance benefit at both query time and update time.

Redundant data is a performance liability at both query time and update time.

Redundant data is a performance benefit at query time, but is a performance
liability at update time.
Question No: 6 ( Marks: 1 ) - Please choose one
Pre-join technique is used to avoid

Run time join

Compile time join

Load time join

[Real sweeto]

Jazak Allah

[Xpert]

what is ur name sweeto