Deck 3: Database Management and Data Mining

Question 1

Which of the following is database element?

A)Data
B)Constraints and schema
C)Relationships
D)All of these.

Answer 1

All of these.

Question 2

What separates the physical aspects of data storage from the logical aspects of data representation?

A)Data
B)Schema
C)Constraints
D)Relationships

Answer 2

Relationships

Question 3

What scheme defines how and where the data are organized in a physical data storage?

A)External
B)Internal
C)Conceptual
D)None of these.

Answer 3

External

Question 4

Which of the following schemas defines the stored data structures in terms of the database model used?

A)External
B)Conceptual
C)Internal
D)None of these

Question 5

Which of the following schemas defines a view or views of the database for particular users?

A)External
B)Conceptual
C)Internal
D)None of these

Question 6

A collection of data designed to be used by different people is called.

A)Database
B)RDBMS
C)DBMS
D)None of these

Question 7

Which of the following is an object-oriented feature?

A)Inheritance
B)Abstraction
C)Polymorphism
D)All of these

Question 8

In ……………technique, data splits at decision points based on entropy

A)Cluster detection
B)Decision trees
C)Link analysis
D)All of the above

Question 9

Association of unknown instances with known instances is a process of………….technique

A)Memory based reasoning
B)Link analysis
C)Neural network
D)Genetic algorithm

Question 10

Which technique is based on linking of variables

A)Cluster detection
B)Decision trees
C)Link analysis
D)All of the above

Question 11

Forward propagation network is a structure of……………..

A)Memory based reasoning
B)Link analysis
C)Neural network
D)Genetic algorithm

Question 12

Data mining applications include

A)Customer segmentation
B)Market basket analysis
C)Risk management
D)All of the above

Question 13

Fraud detection is an application of

A)Data warehousing
B)Data mining
C)Both I and ii
D)None of the above

Question 14

…………….is a best source of data for a data mining operation

A)OLAP
B)Data warehouse
C)OLTP
D)None of the above

Question 15

…………….uncovers relationships and patterns in the existing data

A)Data mining
B)Data warehouse
C)OLAP
D)None of the above

Question 16

…………….steps comprise the knowledge discovery process

A)3
B)4
C)5
D)6

Question 17

Data mining is

A)Data driven
B)User driven
C)Both I and ii
D)None of the above

Question 18

OLAP is

A)Data driven
B)User driven
C)Both I and ii
D)None of the above

Question 19

Which of the following is an advantage of a database?

A)Reduction in Redundancy
B)Avoidance of inconsistency
C)Security enforcement
D)All of the above

Question 20

What is the name of the system database that contains descriptions of the data in the database?

A)Metadata
B)Data dictionary
C)Table
D)None of the above

Question 21

IMS stands for ___________

A)Information Management System
B)Internal Mechanical Security
C)International Managers Society
D)None of the above

Question 22

Which category of users need not be aware of the presence of the database system?

A)DBA
B)Naive
C)Casual
D)Application Programmers