Which of the following is NOT a goal of data mining? Conformity Exploratory Conf

Question

Which of the following is NOT a goal of data mining?

Conformity

Exploratory

Confirmatory

Explanatory

2 points   

QUESTION 2

Which function is used to count the number of characters in a string field?

Len( )

Mid( )

Sum( )

Count( )

2 points   

QUESTION 3

The __________ clause is used to filter the query results based on the aggregate function.

GROUP BY

HAVING

WHERE

FILTER

2 points   

QUESTION 4

________ uses transactional systems that are supported by relational databases.

Middle Management

Operations management

Upper Management

Strategic Management

2 points   

QUESTION 5

In data integration, Consolidation using ETL (Extract, Transfer, Load) consolidates all data into __________.

a virtual view of the data

duplicate databases with real time delay

parallel databases with redundancy

a centralized data warehouse

2 points   

QUESTION 6

Middle Managers typically make ________ decisions using a DSS or MIS.

semi-structure

structured

unstructured

normalized

2 points   

QUESTION 7

When using a(n) __________ function, all attributes that are not part of the __________ function must appear in the GROUP BY clause.

mathematical

aggregate

scalar

date

2 points   

QUESTION 8

Which of the following is not a specification On Line Analytical Processing (OLAP)?

Historical

Data Warehouse

Multi-dimensional

Real time

2 points   

QUESTION 9

In data mining, which task is used for prediction?

Link Analysis

Clustering

Deviation Detection

Regression

2 points   

QUESTION 10

During the ETL (Extract, Transfer, Load) process, the __________ phase is used to correct misspellings, inconsistencies and other errors in the data.

scrub/cleanse

load and index

capture/extract

transform

A.

Conformity

B.

Exploratory

C.

Confirmatory

D.

Explanatory

Explanation / Answer

Answer)

1) C) It depends on the market survey and customer's behaviour.

2) A) len();

3) A) Group BY

4) B) Operation Management.

5) D) into a centralised data ware house.

Hit like/ upvote if you find the answer useful. Your response is important to us and is much needed.

Hope this answer helps. Happy to help. :)

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.