Vuhelper
04-28-2011, 07:58 PM
full solve paper in attachment
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
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