Data Warehousing and Data Mining MCQ Quiz in தமிழ் - Objective Question with Answer for Data Warehousing and Data Mining - இலவச PDF ஐப் பதிவிறக்கவும்

OLTP: It stands for online transaction processing. It involves transaction-oriented applications.  It is based on query processing and total number of transactions processed in a second.

Characteristics of OLTP are:

• Transaction involves small amount of data.
• Response time is short
• It uses fully normalized schema and removes inconsistencies
• It strictly performs the predefined operations on small number of records.
• Indexed data is accessed easily using OLTP
• It supports complex data models.

The correct answer is option 4.

Concept:

Object Oriented DBMS:

Object-oriented DBMS is derived from the model of the object-oriented programming paradigm.  Components of object-oriented data models are,

Object:

A real-world entity, such as a specific life task on a to-do list.

Attributes and Methods:

An object has a state as well as behaviors. An object has properties (also known as attributes) such as name, status, and create date. Its state is represented by the collection of its attributes. An object also has behaviors (also known as methods, actions, or functions) that change or operate on its properties.

Class:

The grouping of all objects with the same properties and behaviors forms a class.

Object-Oriented Design Patterns:

Object-oriented data modeling also implies certain principles like inheritance, polymorphism, overriding, and association.

Hence the correct answer is All the above.

Customer Relationship Management (CRM) is a process of managing a company's interactions and relationships with customers and potential customers.

Data mining:

• Data mining is the process of finding different patterns and relationships within a large volume of data.
• Data mining uses various algorithms and techniques to find trends from the existing data warehouses.
• In CRM, data mining means analyzing data on customers and assisting the business in finding and evaluating relevant information.
• This technique can be used to get a clear picture of the customer's life cycle.
• The customer life-cycle includes customer identification, acquisition, retention, and development.
• Data mining usually involves the use of predictive, forecasting, and descriptive modeling techniques as its key elements.
• The more data available in the database, the more accurate the models will be, and more value will be gained as well.

• CRM with the help of data analysis enables an organization to engage in many useful activities.
• Data mining along with data analysis aids in managing customer retention, choosing the right segments, setting optimal pricing policies, and ranking suppliers as per need.
• Data mining with the help of Artificial Intelligence will be able to shape the future of CRM and aid companies to become more customer-oriented.
• The combination of CRM and data mining tools will increase the knowledge and understanding of customers, products, and transactional data, improving tactical marketing activity and strategic decision-making.

Therefore, in CRM, data mining means analyzing data on customers.

Data Dictionary:

• Data Dictionary is a collection of names, definitions, and attributes about data elements that are being used in a database and information system.
• Data Dictionary provides Meta data about data elements.

DFD (Data flow Diagram):

• Data flow diagrams are used to graphically represent the flow of data in a business information system.

Decision tree:

• A decision tree is a decision support tool that uses a tree like graph and their possible consequences, including chance event outcomes, resource costs, and utility.

Decision Table:

• A decision table is an excellent tool to use in both testing and requirement management.
• Decision table testing is a software testing technique used to test system behaviour for different inputs.

The correct answer is option 3.

Concept:

Object Oriented DBMS:

Object-oriented DBMS is derived from the model of the object-oriented programming paradigm. They are helpful in representing both consistent data as stored in databases, as well as transient data, as found in executing programs. They use small, reusable elements called objects. Each object contains a data part and a set of operations that works upon the data. The object and its attributes are accessed through pointers instead of being stored in relational table models.

Relational DBMS:

In relational databases, the database is represented in the form of relations. Each relation models an entity and is represented as a table of values.

Network DBMS:

Network DBMS is one where the relationships among data in the database are of type many to many in the form of a network.

Hierarchical DBMS:

In hierarchical DBMS, the relationships among data in the database are established so that one data element exists as a subordinate of another.

Hence the correct answer is ​Object Oriented DBMS.

The correct answer is option 1.

Concept:

Many Web applications use an architecture called the three-tier architecture, which adds an intermediate layer between the client and the database server.

The 3-tier architecture consists of the three layers as follows:

Hence the correct answer is Application Server or Web Server.

Concept:

Big data is a field that treats ways to analyse, systematically extract information from, or otherwise deal with data sets that are too large or complex to be dealt with by traditional data-processing application software.

Explanation:

Big Data can be defined using the famous 3 Vs - Volume, Velocity and Variety.

VOLUME:

Volume refers to the amount of data generated through websites, portals and online applications.

VELOCITY:

With Velocity we refer to the speed with which data are being generated.

VARIETY

Variety in Big Data refers to all the structured and unstructured data that has the possibility of getting generated either by humans or by machines.

The most added data are unstructured -texts, tweets, pictures & videos.

Enterprise Resource Planning (ERP):

• Type of software that organizations use to manage day to day business activities such as accounting, project management and supply chain operations.
• Helps plan budget, predict and report on an organization’s financial results.
• It is an example of multiuser database application

Hence option 2 is the correct answer.

Correct answer: Option 1

Concept:

Many Web applications use an architecture called the three-tier architecture, which adds an intermediate layer between the client and the database server.

The 3-tier architecture consists of the three layers as follows:

Hence the correct answer is Application Server or Web Server.

The correct answer is Data mining.

Key Points

• Data mining - Data mining is the process of sorting through large data sets to identify patterns and relationships that can help solve business problems through data analysis.
• It helps data scientists easily analyze enormous amounts of data quickly.

Additional Information

• Data scientists can use the information to detect fraud, build risk models, and improve product safety.
• It helps data scientists quickly initiate automated predictions of behaviors and trends and discover hidden patterns.

• Data collection - It is the process of gathering data for use in business decision-making, strategic planning, research, and other purposes.
• Data may be grouped into four main types based on methods for collection:

1. Observational.
2. Experimental.
3. Simulation.
4. Derived.

• Data sampling -It is a statistical analysis technique used to select, process, and analyze a representative subset of a population.
• Types of sampling: Random, Systematic, Convenience, Cluster, and Stratified.