Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

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

Question 3

Which technique is based on linking of variables

Accepted Answer

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

Question 4

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

Accepted Answer

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

Question 5

IMS stands for ___________

Accepted Answer

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

Question 6

OLAP is

Accepted Answer

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

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

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

Question 10

Data mining is

Accepted Answer

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

Question 11

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

Accepted Answer

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

Question 12

Which of the following is an advantage of a database?

Accepted Answer

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

Question 13

Which of the following is database element?

Accepted Answer

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

Question 14

Which of the following is an object-oriented feature?

Accepted Answer

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

Question 15

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

Accepted Answer

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

Question 16

Fraud detection is an application of

Accepted Answer

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

Question 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

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

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

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

Which technique is based on linking of variables

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

IMS stands for ___________

OLAP is

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

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

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

Data mining is

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

Which of the following is an advantage of a database?

Which of the following is database element?

Which of the following is an object-oriented feature?

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

Fraud detection is an application of

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

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

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

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

Database Management System DBMS: Part A

Database Management System DBMS: Part B

Database Management System: Relational Model and Operations

Oracle Backup, Distributed Databases, and SQL Commands

Filters

Exam 3: Database Management and Data Mining

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

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

Which technique is based on linking of variables

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

IMS stands for ___________

OLAP is

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

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

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

Data mining is

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

Which of the following is an advantage of a database?

Which of the following is database element?

Which of the following is an object-oriented feature?

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

Fraud detection is an application of

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

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

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

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

Database Management System DBMS: Part A

Database Management System DBMS: Part B

Database Management System: Relational Model and Operations

Oracle Backup, Distributed Databases, and SQL Commands

Filters