vu cs614 Mid Term - Quiz No.1
vu cs614 Data Warehousing Quiz
This quiz belongs to book/course code vu cs614 Data Warehousing of vu organization. We have 13 quizzes available related to the book/course Data Warehousing. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Mid Term. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: 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.
None of these
Independence on technology
Dependence on technology
Question 4: For a relation to be in 4NF it must be:-
In 3NF and every non-key column is non-transitively dependent upon its Foreign key.
In 3NF and It does not have multi valued dependencies
In 3NF and every non-key column is non-transitively dependent upon its primary key.
In 2NF if and only if it is in first normal form and all nonkey attributes are fully functionally dependent on the key.
Question 5: Pakistan is one of the five major __________ countries in the world.
Rice-growing
Weapon Producing
Cotton-growing
Question 6: Focusing on data warehouse delivery only often end up __________.
Good Stable Product
None of these
Rebuilding
Success
Question 7: 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, 2 & 3
Option 2 only
Option 1 & 2 only
Option 1 only
Question 8: Pre-join technique is used to avoid
Compile time join
Load time join
Run time join
Question 10: The goal of ideal parallel execution is to completely parallelize those parts of a computation that are not constrained by data dependencies. The smaller the portion of the program that must be executed __________, the greater the scalability of the computation.
Sequentially
In Parallel
Distributed
None of these