Search Papers On This Blog. Just Write The Name Of The Course

Tuesday 17 May 2011

Re: ::: vuaskari.com ::: cs614 correct solved mcq's for mid

Thanx

On Mon, May 16, 2011 at 8:02 AM, Ishfaq akhter <ishfaq.khosa55@gmail.com> wrote:

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 to cross the 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.
 
O (n) 
O (n2) 
O (n lg n) 
O (lg n) 

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: 7 ( Marks: 1 ) - Please choose one
 
Cube is a __________ entity containing values of a certain fact at a certain aggregation level at an intersection of a combination of dimensions.
 
 Logical 
Physical 
Analytical 
None of these 

Question No: 8 ( Marks: 1 ) - Please choose one
 
The goal of star schema design is to simplify ________
 
Logical data model 
 Physical data model 
Conceptual data model 
None of these 

Question No: 9 ( Marks: 1 ) - Please choose one
 
Grain is the ________ level of data stored in the warehouse.
 
 Atomic 
Summarized 
Aggregated 
Cube 

Question No: 10 ( Marks: 1 ) - Please choose one
 
Transactional fact tables do not have records for events that do not occur. These are called
 
 Not Recording Facts 
Fact-less Facts 
Null Facts 
None of these 

Question No: 11 ( Marks: 1 ) - Please choose one
 
A ________ dimension is a collection of random transactional codes, flags and/text attributes that are unrelated to any particular dimension. The ______ dimension is simply a structure that provides a convenient place to store the ______ attributes.
 
 Junk 
Time 
Parallel 
None of these 

Question No: 12 ( Marks: 1 ) - Please choose one
 
During ETL process of an organization, suppose you have data which can be transformed using any of the transformation method. Which of the following strategy will be your choice for least complexity?
 
 One-to-One Scalar Transformation 
One-to-Many Element Transformation 
Many-to-Many Element Transformation 
Many-to-One Element Transformation 

Question No: 13 ( Marks: 1 ) - Please choose one
 
Change Data Capture is one of the challenging technical issues in _____________
 
 Data Extraction 
Data Loading 
Data Transformation 
Data Cleansing 

Question No: 14 ( Marks: 1 ) - Please choose one
 
Rearranging the grouping of source data, delivering it to the destination database, and ensuring the quality of data are crucial to the process of loading the data warehouse. Data ____________ is vitally important to the overall health of a warehouse project.
 

1.
Cleansing 
2. Cleaning 
3. Scrubbing
 
Which of the following options is true?
 
Option 1 only 
Option 2 only 
Option 1 & 2 only 
Option 1, 2 & 3 

Question No: 15 ( Marks: 1 ) - Please choose one
 
When performing objective assessments, companies follow a set of principles to develop metrics specific to their needs, there is hard to have "one size fits all" approach. Which of the following statement represents the pervasive functional forms?
 
 Simple Ratio, Min or Max Operation, Weighted Average 
Only Complex Ratio, Min Operation, Max Operation 
Only Simple Ratio, Min or Max Operation 
Only Min or Max Operation, Weighted Average 

Question No: 16 ( Marks: 1 ) - Please choose one
 
The input to the data warehouse can come from OLTP or transactional system
 but not from other third party database. 
True 
False 

Question No: 17 ( Marks: 1 ) - Please choose one
 
Normalization effects performance
 
 True 
False PLZ VERIFY

Question No: 18 ( Marks: 1 ) - Please choose one
 
Collapsing tables can be done on the ___________ relationships
 
One-to-One 
Many-to-Many 
 Both One-to-One and Many-to-Many 
None of these 

Question No: 19 ( Marks: 1 ) - Please choose one
 
_________ breaks a table into multiple tables based upon common column values.
 
 Horizontal splitting 
Vertical splitting 

Question No: 20 ( Marks: 1 ) - Please choose one
 
If w is the window size and n is the size of data set, then the complexity of merging phase in BSN method is___________
 
O (n) 
O (w) 
O (w n) please check this reply 
O (w log n) 

--
We say, "Be one as Pakistani Nation and grow up for Pakistan's Future". Wish you all the best. Join www.vuaskari.com,
To post to this group, send email to vuaskari_com@googlegroups.com
Visit these groups:
This (Main) Group:http://groups.google.com/group/vuaskari_com?hl=en?hl=en
MIT/MCS Group: http://groups.google.com/group/vu_askarimit?hl=en?hl=en
HRM Group: http://groups.google.com/group/askari_hrm?hl=en?hl=en
Banking Group: http://groups.google.com/group/askari_banking?hl=en?hl=en
Management: https://groups.google.com/group/vuaskari_mgt?hl=en
Marketing: https://groups.google.com/group/vuaskari_mkt?hl=en
MIS Group: http://groups.google.com/group/askari_mis?hl=en

--
We say, "Be one as Pakistani Nation and grow up for Pakistan's Future". Wish you all the best. Join www.vuaskari.com,
To post to this group, send email to vuaskari_com@googlegroups.com
Visit these groups:
This (Main) Group:http://groups.google.com/group/vuaskari_com?hl=en?hl=en
MIT/MCS Group: http://groups.google.com/group/vu_askarimit?hl=en?hl=en
HRM Group: http://groups.google.com/group/askari_hrm?hl=en?hl=en
Banking Group: http://groups.google.com/group/askari_banking?hl=en?hl=en
Management: https://groups.google.com/group/vuaskari_mgt?hl=en
Marketing: https://groups.google.com/group/vuaskari_mkt?hl=en
MIS Group: http://groups.google.com/group/askari_mis?hl=en

No comments:

Post a Comment