CS614 Final Term Solved MCQs with References by Moaaz

Solved MCQS · From Final term Papers · Feb 03,2013 · PSMD01 · Spring 2012

Q1. To identify the __________________ required we need to perform data profiling (1 marks)

1. Degree of Transformation (Page 437)
2. Complexity
3. Cost
4. Time

Correct answer: Degree of Transformation (Page 437)

Q2. Companies collect and record their own operational data, but at the same time they also use reference data obtained from _______ sources such as codes, prices etc. (1 marks)

1. Operational
2. None of these
3. Internal
4. External (Page 21)

Correct answer: External (Page 21)

Q3. Ad-hoc access means to run such queries which are known already. (1 marks)

1. True
2. False (Page 18)

Correct answer: False (Page 18)

Q4. ____________ in agriculture extension is that pest population beyond which the benefit of spraying outweighs its cost. (1 marks)

1. Profit Threshold Level
2. Economic Threshold Level (Page 332)
3. Medicine Threshold Level
4. None of these

Correct answer: Economic Threshold Level (Page 332)

Q5. People that design and build the data warehouse must be capable of working across the organization at all levels (1 marks)

1. True (Page 320)
2. False

Correct answer: True (Page 320)

Q6. The _________ is only a small part in realizing the true business value buried within the mountain of data collected and stored within organizations business systems and operational databases. (1 marks)

1. Independence on technology
2. Dependence on technology (Page 320)
3. None of these

Correct answer: Dependence on technology (Page 320)

Q7. Relational databases allow you to navigate the data in ____________ that is appropriate using the primary, foreign key structure within the data model. (1 marks)

1. Only One Direction
2. Any Direction (Page 19)
3. Two Direction
4. None of these

Correct answer: Any Direction (Page 19)

Q8. DSS queries do not involve a primary key (1 marks)

1. True (Page 21)
2. False

Correct answer: True (Page 21)

Q9. Data Transformation Services (DTS) provide a set of _____ that lets you extract, transform, and consolidate data from disparate sources into single or multipledestinations supported by DTS connectivity. (1 marks)

1. Tools (Page 373)
2. Documentations
3. Guidelines

Correct answer: Tools (Page 373)

Q10. The need to synchronize data upon update is called (1 marks)

1. Data Manipulation
2. Data Replication
3. Data Coherency (Page 12)
4. Data Imitation

Correct answer: Data Coherency (Page 12)

Q11. Taken jointly, the extract programs or naturally evolving systems formed a spider web, also known as (1 marks)

1. Distributed Systems Architecture
2. Legacy Systems Architecture (Page 14)
3. Online Systems Architecture
4. Intranet Systems Architecture

Correct answer: Legacy Systems Architecture (Page 14)

Q12. Node of a B-Tree is stored in memory block and traversing a B-Tree involves ______ page faults. (1 marks)

1. O (n)
2. O (n2)
3. O (n lg n)
4. O (lg n) (Page 22)

Correct answer: O (lg n) (Page 22)

Q13. Which statement is true for De-Normalization? (1 marks)

1. Redundant data is a performance liability at query time, but is a performance benefit at update time.
2. Redundant data is a performance benefit at both query time and update time.
3. Redundant data is a performance liability at both query time and update time.
4. Redundant data is a performance benefit at query time, but is a performance liability at update time. (Page 51)

Correct answer: Redundant data is a performance benefit at query time, but is a performance liability at update time. (Page 51)

Q14. As apposed to the out come of classification, estimation deal with ____________ valued outcome. (1 marks)

1. Discrete
2. Isolated
3. Continuous (Page 260)
4. Distinct

Correct answer: Continuous (Page 260)

Q15. The goal of ______is to look at as few block as possible to find the matching records. (1 marks)

1. Indexing (Page 222)
2. Partitioning
3. Joining
4. none of these

Correct answer: Indexing (Page 222)

Q16. The technique that is used to perform these feats in data mining modeling, and this act of model building is something that people have been doing for long time, certainly before the _______ of computers or data mining technology. (1 marks)

1. Access Advent click for detail
2. Ascent Avowal