CS614 - Data Warehousing

All MCQs Tests - VU CS614 - Data Warehousing

Start

Subject	CS614 - Data Warehousing			Chapter / Term	All MCQs
Quiz No	1	Total Time	10 Minute(s)	No. of Questions	10 Question(s)

Start Test Now

Chapter / Term

Time

Question(s)

Q1

Question 1: DSS queries do not involve a primary key

TRUE

False

Q2

Question 2: 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

Q3

Question 3: There are many variants of the traditional nested-loop join, if there is an index is exploited, then it is called __________

Naïve nested loop join

index nested loop join

temporary index nested loop join

none of these

Q4

Question 4: Multidimensional databases typically use proprietary __________ format to store pre-summarized cube structures.

File

Application

Aggregate

Database

Q5

Question 5: The goal of star schema design is to simplify __________.

Logical data model

Physical data model

Conceptual data model

None of the given

Q6

Question 6: Suppose the amount of data recorded in an organization is doubled every year. This increase is __________.

Linear

Quadratic

Exponential

Logarithmic

Q7

Question 7: in agriculture extension is that pest population beyond which the benefit of spraying outweighs levels

TRUE

FALSE

Q8

Question 8: 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.

Operational

Internal

External

None of the given

Q9

Question 9: Relational databases allow you to navigate the data in __________ that is appropriate using the primary, foreign key structure within the data model.

Only One Direction

Any Direction

Two Direction

None of the given