Data Mining And Warehouse Set 12
On This Page
This set of Data Mining and Data Warehouse Multiple Choice Questions & Answers (MCQs) focuses on Data Mining And Warehouse Set 12
Q1 | A link is said to be _________ link if it is between pages with different domain names.
- intrinsic.
- transverse.
- direct.
- contrast.
Q2 | A link is said to be _______ link if it is between pages with the same domain name.
- intrinsic.
- transverse.
- direct.
- contrast.
Q3 | Patterns that can be discovered from a given database are which type
- more than one type
- multiple types always
- one type only
- no specific type
Q4 | A snowflake schema is which of the following types of tables?
- fact
- dimension
- helper
- all of the above
Q5 | Which one manages both current and historic transactions?
- oltp
- olap
- spread sheet
- xml
Q6 | Expansion for DSS in DW is__________.
- decision support system
- decision single system
- data storable system
- data support system
Q7 | __________describes the data contained in the data warehouse
- relational data
- operational data
- meta data
- informational data
Q8 | Converting data from different sources into a common format for processing is called as________.
- selection.
- preprocessing
- transformation
- interpretation
Q9 | Data warehousing is used in_______________
- transaction system
- database management system
- decision support system
- expert system
Q10 | Data warehouse is based on_____________
- two dimensional model
- three dimensional model
- multi dimensional model
- unidimensional model
Q11 | Multidimensional model of data warehouse called as_____
- data structure
- table
- tree
- data cube
Q12 | In data warehousing what is time-variant data?
- data in the warehouse is only accurate and valid at some point in time or over time interval
- data in the warehouse is always accurate and valid
- data in the warehouse is not accurate
- data in the warehouse is only accurate sometimes
Q13 | What is a Star Schema?
- a star schema consists of a fact table with a single table for each dimension
- a star schema is a type of database system
- a star schema is used when exporting data from the database
- none of these
Q14 | What does the acronym ETL stands for?
- explain,transfer and lead
- extract,transform and load
- extract,transfer and load
- effect,transfer and load
Q15 | Which small logical units do data warehouses hold large amounts of information?
- data storage
- data marts
- access layers
- data miners
Q16 | Which one is correct for data warehousing?
- it can be updated by end users
- it can solve all business questions
- it is designed for focus subject areas
- it contains only current data
Q17 | A fact table is related to dimensional table as a ___ relationship
- 1:m
- m:n
- m:1
- 1:1
Q18 | Minkowski distance is a function used to find the distance between two
- binary vectors
- boolean-valued vectors
- real-valued vectors
- categorical vectors
Q19 | Data set of designation {Professor, Assistant Professor, Associate Professor} is example of__________attribute.
- continuous
- ordinal
- numeric
- nominal
Q20 | Identify the correct example of Nominal Attributes.
- weight of person in kg
- income categories - high, medium, low
- mobile number
- all above
Q21 | When objects are represented using single attribute, the proximity value 1 indicates :
- objects are similar
- objects are dissimilar
- not equal
- reflexive
Q22 | Identity correct equation of Jacard Coefficient:
- j= f11/f01+f10+f11
- j= f11+f00/f01+f10+f11
- j= f11+f00/f01+f10
- none of these
Q23 | What equation we get when r parameter =2 in Minskowski Distance formula?
- manhattan distance
- euclidean distance
- lmaximum distance
- all
Q24 | ________is a generalization of Manhattan, Euclidean and Max Distance
- euclidean distance
- minkowski distance
- manhattan distance
- jaccard distance
Q25 | _________ distance is based on L1 norm.
- euclidean distance
- minkowski distance
- manhattan distance
- jaccard distance