Data Warehousing & Mining(MARKS OBTAINED 30 OUT OF 30)

Assignment A

1. Identify the five components of the data communication system? What is the difference between half-duplex and full-duplex transmission modes? Name the four basic network topologies, and cite an advantage of each type.

2. Define analog transmission? Define analog to analog conversion.

3. Define digital to analog conversion. Which of the four digital to analog conversion technique is most susceptible to noise? Defend your answer.    

4. How do guided media differ from unguided media? What are the three major classes of guided media? Name the advantages of optical fibre over twisted–pair and coaxial cable?    

5. Compare and contrast error control and flow control. What are the three protocols used for error control for noisy channels?    

6.  State and explain adaptive and non-adaptive routing algorithms.    

7. What are the characteristics of CSMA/CD? Explain Token bus and Token ring standards.

8. What is TCP/TP model and explain function of each layer. Compare the TCP header and UDP header. List the fields in the TCP header that are missing from UDP header. Give the reason for their absence.

Assignment B
Case Detail:
Being a network administrator in XYZ bank, it so happened that a hacker stole sensitive business information, an employee opened an attachment with a virus that badly damaged your system and online bank password or credit card info is stolen using spyware?
1. In view of the situation explained above, design robust firewalls with a secure network design to keep hackers at bay and implement a business continuity solution in case of an attack.

Assignment C

Question No.  1    Marks - 10
SQL helps to find _______.    
 
Options    
the interesting data    
hidden information    
intermediate data    
data under constraints that are already known

Question No.  2    Marks - 10
A data warehouse is which of the following?    
 
Options    
Can be updated by end users.    
Contains numerous naming conventions and formats.    
Organized around important subject areas.    
Contains only current data.

Question No.  3    Marks - 10
The partition of overall data warehouse is _______.     
Options    
database    
data cube.    
data mart.    
operational data

Question No.  4    Marks - 10
OLAP is used to explore the ___________ knowledge.     
Options    
shallow.    
multidimensional.    
deep.    
hidden.

Question No. 5    Marks - 10
The decision support system is used only for _______.    
Options    
cleaning.    
coding.    
selecting.    
queries.

Question No. 6    Marks - 10
________ is a creative activity that has to be performed repeatedly in order to get best result    
Options    
Cleaning    
Reporting    
Coding    
Selection

Question No.  7    Marks - 10
In K-nearest neighbor algorithm K stands for ________.    
 
Options    
number of neighbors that are investigated.    
number of iterations    
number of total records.    
random number.

Question No.  8    Marks - 10
Genetic algorithm was proposed by _______.    
 
Options    
Johnson.    
John Holland.    
Watson.    
Kohenon.

Question No.  9    Marks - 10
The set of attribute in a database that refers to data in another table is called ______.    
 
Options    
primary key.    
candidate key.    
foreign key.    
super key.

Question No.  10    Marks - 10
In KDD and data mining, noise is referred to as ________.    
 
Options    
repeated data.    
complex data.    
meta data.    
random errors in database

Question No.  11    Marks - 10
A coding operation in which an attribute with cardinality n is replaced by n binary attributes is called as ______.    
 
Options    
falsification of table    
enrichment of table.    
flattening of table.    
fuzzification of table.

Question No.  12    Marks - 10
______ itself has become a production factor of importance.    
 
Options    
Data.    
Information.    
Program.    
Algorithm.

Solve by www.solvezone.in contact for more details at 8882309876

Question No.  13    Marks - 10
Data mining is used to refer ______ stage in knowledge discovery in database.    
 
Options    
selection.    
retrieving.    
discovery.    
coding.

Question No.  14    Marks - 10
__________________refers to the process of deriving high-quality information from text.    
 
Options    
Text Mining.    
Image Mining.    
Database Mining.    
Multimedia Mining.    

Question No.  15    Marks - 10
_____________ is the application of data mining techniques to discover patterns from the Web.     
Options    
Text Mining    
Multimedia Mining.    
Web Mining    
Link Mining.

Question No.  16    Marks - 10
AI stands for ____.    
 
Options    
art of interest.    
artificial interest.    
art of intelligence    
artificial intelligence.    

Question No.  17    Marks - 10
The algorithms that are controlled by human during their execution is _______ algorithm.    
 
Options    
unsupervised.    
supervised.    
batch learning.    
incremental.

Question No.  18    Marks - 10
A snowflake schema is which of the following types of tables?    
 Options    
Fact    
Dimension    
Helper    
All of the above

Question No.  19    Marks - 10
Fact tables are which of the following?    
 Options    
Completely denormalized    
Partially denormalized    
Completely normalized    
Partially normalized    

Question No.  20    Marks - 10
Data transformation includes which of the following?    
 Options    
A process to change data from a detailed level to a summary level    
A process to change data from a summary level to a detailed level    
Joining data from one source into various sources of data    
Separating data from one source into various sources of data

Question No.  21    Marks - 10
The _______ data are stored in data warehouse.    
 Options    
operational.    
historical.    
transactional.    
optimized.

Question No.  22    Marks - 10
A ______ is not the rule that govern the basic structure of data warehouse.    
 Options    
time dependent.    
volatile.    
subject oriented.    
integrated.

Question No.  23    Marks - 10
A collection of interesting and useful patterns in database is called _______.    
 Options    
knowledge.    
information.    
data.    
algorithm.

Question No.  24    Marks - 10
SQL stands for ________.    
 Options    
simple query language.    
structured query language.    
strong query language.    
simple language.

Question No.  25    Marks - 10
_______ is used to find relationship between multidimensional data.    
 Options    
K-nearest neighbor    
Decision trees.    
Association rules.    
OLAP tools.

Question No.  26    Marks - 10
Association rules are always defined on________.    
 Options    
binary attribute.    
single attribute.    
relational database.    
multidimensional attribute.

Question No.  27    Marks - 10
________analysis divides data into groups that are meaningful, useful, or both.    
 Options    
Classification.    
Association.    
Cluster.    
Relation.

Question No.  28    Marks - 10
Which of the following is the not a types of clustering?    
 Options    
Which of the following is the not a types of clustering?    
Hiearachical.    
Partitional.    
Splitting.

Question No.  29    Marks - 10
Data compression is to compress the given data by encoding in terms of _________.    
 Options    
bytes.    
bits.    
cluster.    
group.

Question No.  30    Marks - 10
Dimensionality reduction reduces the data set size by removing _________.    
 Options    
relevant attributes.    
irrelevant attributes.    
derived attributes.    
composite attributes.    

Question No.  31    Marks - 10
Capability of data mining is to build __________ models.    
 Options    
retrospective.    
interrogative.    
predictive.    
imperative.    

Question No.  32    Marks - 10
The terms equality and roll up are associated with___________.    
 Options    
data mart.    
visualization.    
OLAP.    
decision tree.

Question No.  33    Marks - 10
Discovery of cross-sales opportunities are called_________.    
 Options    
segmentation.    
visualization.    
correction.    
association.

Question No.  34    Marks - 10
Which of the following is not a decision tree node?    
 Options    
Root node.    
Internal node.    
Leaf node.    
predicted node.

Question No.  35    Marks - 10
Which of the following is not a data mining attribute?    
 Options    
nominal.    
multiple.    
interval.    
ordinal.
Question No.  36    Marks - 10
Nominal and ordinal attributes are collectively referred to as_________ attributes.    
 Options    
qualitative.    
perfect.    
consistent.    
optimized.

Question No.  37    Marks - 10
___________ is used for discrete target variable.    
 Options    
Nominal.    
Classification.    
Clustering.    
Association.

Question No.  38    Marks - 10
Binary attribute are    
 Options    
This takes two values '0' and '1'    
the natural environment of a certain species    
systems that can be used without knowledge of internal operations    
none of these

Question No.  39    Marks - 10
The task of correcting and preprocessing data is called ____________.    
 Options    
data analysis    
data processing    
data cleansing    
data mining

Question No.  40    Marks - 10
A schema with a fact table, multiple dimensional table and foreign keys from the fact table to the dimension table is called a ____________.    
 Options    
sub schema    
logical schema    
snowflake schema    
star schema