Avatto > UGC NET COMPUTER SCIENCE > PRACTICE QUESTIONS > Database > Data Mining

Database MCQ - Data Mining

51 Suppose there are five instances, i1, i2, i3, i4, i5 in a dataset having three features, X,Y and Z as shown in the table below:

Instances	X	Y	Z
i1	1.6	2.3	5.1
i2	2.4	2.5	4.6
i3	3.9	3.6	3.7
i4	4.1	3.7	2.5
i5	5.6	8.3	1.8

In order to find the dependence between two variables we use the Pearson's Correlation Coefficient. Based on your understanding of Correlation Coefficient, choose the correct option/s:
1. A strong positive correlation between X and Y
2. A strong negative correlation between X and Y
3. A weak positive correlation between X and Z
4. A weak negative correlation between X and Z

52 Suppose, you got a situation where you find that your linear regression model is under fitting the data. In such situation which of the following options would you consider?
a. You will add more features
b. You will start introducing higher degree features
c. You will remove some features

Consider the dataset, S given below:

Elevation	Road Type	Speed Limit	Speed
steep	Uneven	Yes	Slow
steep	Smooth	Yes	Slow
flat	Uneven	No	Fast
steep	Smooth	No	Fast

Elevation, Road Type and Speed Limit are the features and Speed is the target label that we want to predict.

53 Find the entropy of the dataset, S as given above:

Consider the dataset, S given below:

Elevation	Road Type	Speed Limit	Speed
steep	Uneven	Yes	Slow
steep	Smooth	Yes	Slow
flat	Uneven	No	Fast
steep	Smooth	No	Fast

Elevation, Road Type and Speed Limit are the features and Speed is the target label that we want to predict.

54 Find the information Gain if the dataset is split at the feature "Elevation":

Consider the dataset, S given below:

Elevation	Road Type	Speed Limit	Speed
steep	Uneven	Yes	Slow
steep	Smooth	Yes	Slow
flat	Uneven	No	Fast
steep	Smooth	No	Fast

Elevation, Road Type and Speed Limit are the features and Speed is the target label that we want to predict.

55 Find the feature on which the parent node must be chosen to split the dataset, S based on information gain:

Your Progress

0%

Start Practising!

You've answered 0 of 108 questions in this topic.

Practice Spotlight

Build momentum in Data Mining

Start with a short question set, review every explanation, and revisit difficult questions before moving ahead.

Day 4 / 10

Global Spotlight

Build Your First Streak

Complete one short Data Mining session today, then return tomorrow. Consistency matters more than a long first session.

Day 8 / 10

Question Spotlight

Question:

Hidden knowledge referred to

A. A set of databases from different vendors, possibly using different database paradigms
B. An approach to a problem that is not guaranteed to work but performs well in most cases
C. Information that is hidden in a database and that cannot be recovered by a simple SQL query.
D. None of these

Correct answer: C

Click to view the complete question details

Day 4 / 10 Open this question

Community Insight

Based on 17 saved attempts

Most Attempted TopicData Modeling
Most Challenging TopicSQL
Average Accuracy88%

Featured Question

(Based on recent community answers)

Q. #152020% Incorrect

Data dictionary is

Try This Question →

This Week's Challenge

Complete 20 questions and set the community benchmark!

0 / 20 Start Challenge →

Why Practice with Avatto?

High Quality MCQsExam-focused questions with accurate answers

Detailed ExplanationsStep-by-step explanations to enhance learning

Latest Exam PatternBased on updated syllabus and pattern

Performance AnalyticsTrack performance and improve weak areas

100% Free PracticePractice unlimited questions for free

Forgot your password?

I agree with the Terms.