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

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