Simplifying Concepts

Essence of Life is in Simplicity

Data Warehouse Mining Viva

DWMBI (Data Warehouse Mining & Business Intelligence) Viva Questions:
Hey guys, welcome back we @ conceptSimplified are devoted to simplify your task. Following are few of the Most frequently asked Viva questions in DWMBI and would be extremely useful if you are specifically from Mumbai University.

Data Warehouse Mining Viva
CH-1 Introduction to Data Mining

  • What is data mining?
  • What are functionalities of Data Mining?
  • Classify Data Mining systems
  • Explain Integration of Data Mining system with a Database or Datawarehouse
  • Architecture of Typical Data mining System?
  • What are major Data Mining Issues?
  • Explain KDD process?

CH-2 Data WareHousing

  • What is Data warehousing?
  • Difference between Database and Datawarehouse?
  • Explain Star Schema?
  • Explain Snow flake Schema?
  • Difference between Star and snow flake schema?
  • Explain Fact and Dimensional table?
  • Explain Factless Fact table?
  • What is OLAP?
  • What is OLTP?
  • State applications of OLAP.
  • Difference between OLAP and OLTP?
  • State OLAP operations?

CH-3 Data Preprocessing

  • Difference between clustering and classification?
  • What is Data cleaning?
  • What is Data Integration?
  • What is Data Transformation?
  • State Data Reduction techniques ?
  • Explain Data Reduction techniques in short?
  • Which techniques are used for Numerosity Reduction?
  • Give ways of handling Noise Data?
  • What is noisy data?

CH-4 Mining Frequent Patterns,Associations and Correlations

  • What is Market basket analysis?
  • Explain Apriori Algorithm?
  • Explain FP-Tree Algorithm?
  • How FP-Tree is better than Apriori Algorithm?
  • Give formula of Support and Confidence?
  • K-mean Algorithm
  • What are Constraint based association rule mining?
  • Explain mining multilevel association Rules?
  • Explain mining multidimensional association Rules?

CH-5 Classification and Prediction

  • What is Classification?
  • What is Prediction?
  • State Issues regarding Classification and Prediction?
  • State various classification methods?
  • What is Regression?
  • State types of Regression?
  • Explain Linear Regression?
  • Explain Non Linear Regression?
  • Give formulae of a)Information Gain b)Entropy c)Gini index?
  • Explain Decision tree in brief?
  • Explain Bayesian classification?

CH-6 Cluster Analysis

  • What is clustering ?
  • What is Clustering Analysis?
  • State types of data in Clustering Analysis?
  • State Categories of clustering methods?
  • State partitioning methods?
  • What is BIRCH?
  • What is ROCK?
  • Explain DBSCAN?
  • Explain K-means?
  • Explain K-mediods?
  • Explain Agglomerative Clustering?
  • Explain Outliers Analysis?

CH-7 Mining Stream and Sequence Data

  • What is Stream Data?
  • Explain Association mining in stream data?
  • Explain Sequence Mining in transactional database?
  • Explain different Data Stream methodologies?
  • Explain Hoeffding Tree Algorithm?

CH-8 Spatial Data & Text Mining

  • Compare Data Mining and Text Mining.
  • State Spatial Clustering methods.
  • What is Spatial OLAP?
  • What is Spatial data mining?
  • State different approaches in Text Mining?
  • State Spatial Clustering Methods?
  • What is Web mining ?
  • What is Web Content Mining?
  • What is Web Structure Mining?

CH-9 Data Mining for Bussiness Intelligence Applications.

  • What is business intelligence ?
  • State Business Intelligence issues?
  • How Data Mining be used for BI Applications?
  • Explain Data Mining for Market Segmentation?
  • Explain Data Mining for Retail Industry?

Software Engineering viva questions

Hello guys, vivas are around and no clue what to study, we at conceptSimplified simplify your task.Below are few questions which we would recommend you to be prepared before giving your Vivas.

  • Name the software process models. Describe them.
  • What is process metrics and project metrics?
  • Name the software estimation techniques. Give the formula. Explain any one technique?
  • What are the principles of project planning?
  • Function Points & Lines of Code.
  • Define risk analysis. Steps of risk analysis.
  • What is RMMM(Risk Management, Mitigation & Monitoring) plan?
  • What are the principles of project scheduling?
  • What are milestones, WBS chart and Gantt chart?
  • What is software requirement? Requirements in engineering process.
  • Data flow diagrams. Characteristics of good SRS.
  • Software design abstraction and architecture.
  • Definition and types of cohesion and coupling.
  • What are the design issues?
  • Explain SCM process and tools.
  • What is Software quality assurance?
  • Explain Quality metrics ( Defect Removal Efficiency)?
  • What is baseline?
  • Different types of software testing.
  • Difference between blackbox testing and white box testing.
  • What is Software engineering?
  • What is Reverse engineering?
  • Service oriented software engineering.
  • What is alpha-beta testing?(Most asked question)
  • What is requirement analysis and specification?
  • What is use case model?
  • Test case and Test scenario.
  • Draw use case for library management, ATM.
  • What is version control?
  • What is change control?
  • What is requirement gathering?
  • What is FTR (Formal Technical Review)?
  • Explain the steps in FTR?
  • Define Software Engineering?
  • What are estimation techniques?
  • Explain design principles?
  • What is CoCoMo model?
  • What are testing principles?

Note: These are few of the most Frequently Asked Viva Questions. It would be best if you refer Software Engineering A Practitioner’s Approach 7th Edition – Roger Pressman for solutions of viva questions.

Persistent Placement Process

Persistent Placement Process-Recruitment Drive:

About Persistent:
Persistent is a place that values enrichment both on a professional and personal level. With this in mind, Life @ Persistent is dynamic. Life for employees is brimming with activities and there are groups for you to pursue your personal interests in areas such as arts, culture and sports.

Sports buffs can participate in sports events organized by the Persistent Sports Committee. If your interest lays more on the artistic side, you will have plenty of occasions to express your creative self through the Persistent Arts Circle, fondly coined as PAC. Other groups include the Welfare Activity Group (WAG), PRERANA that is a Women Professional support group, and Green Persistent that promotes ecological initiatives.

ALSO they provide many health benefits and other benefits to employees ,A doctor and a mental health counselor visit all of their campuses on a regular basis.Helpdesks are available to help resolve queries about banking, tax planning, insurance, etc.To encourage fitness, you will find on campus, a fully equipped gym and yoga room with a full time instructor.They also serve lunch and snacks for all employees.

Placement Process:
General outline of the Persistent Placement Process:(Only for IT/COMPS Candidates.)

  • Pre-Placement talk
  • Online Aptitude Test
  • Technical Interview I
  • Technical Interview II
  • HR and Management Interview

Pre-Placement talk:
Now coming to the placement process, it is slightly different from that of TCS. Firstly you would be subjected to a pre-placement talk. This would last for around for 30 to 45 minutes. Basically they would talk about their whole roots and origin, their current position in the industry and most importantly they would discuss about their working lifestyle. After this you would be subjected to an aptitude test. However one more thing to get clarified is that Persistent is not a bulk recruiter and usually takes 5 to 10% of candidates (for Navi Mumbai Region) and this was the case in my campus. And as of 2014-2015, Persistent was offering Rs 3.59 lakhs for new recruits in Mumbai region.
NOTE:The Placement Process for me was a Pooled Campus Recruitment Drive.It had 5 Major and reputed Colleges participating in the Drive.

Online Aptitude Test:
One thing which I found that in its aptitude test, Persistent even gives a programming question for a challenge. That is aptitude and programming questions were integrated. Even more interesting fact was that all those who cleared the aptitude were only those who could get through this programming challenge. The main portion of the test was related to Operating System Fundamentals, Data Structures-Mainly Tree and Linked List Concepts,C++ Syntax and Concepts.The Non Technical Part was mainly focused on Logical and Analytical Reasoning more than Numerical Data Relations or Mathematical Aptitude.There was a C++ code related to substring method of STRING Class and had a class making use of it, a method having string and count as parameters.Pseudo code was provided. This speaks volumes about Persistent’s need for Logically and Analytically Sound Selects.

TECHNICAL INTERVIEW I: (Duration One Hour and 15 Minutes)
All the candidates who have cleared aptitude cum programming challenge test are now subjected to TI-I.From the total of 150 odd students who gave aptitude test only 29 finally got selected to the TR-I. As mentioned above the duration might get you worried , once you are in the interview room the time moves fast.Be ready to be grilled in the technical interview of Persistent.I was asked in which language I was comfortable in, to which I replied Java.And the next moment I was asked questions related to C++. The question was to explain the block of Simple C++ Program(where the main method would lie, the classes would lie ,etc). Actually the basic concepts for C++ or Java are same ,so he might be checking my skills there.

Then slowly he moved on to Java and asked questions related to public static void main, why each one of them is necessary , and what if it is removed.Then the interviewer moved on to data structures ,Linked Lists, Stacks, Queues and many more.He asked real life examples for few of them.Then the binary trees and tree concepts in data structures.He didn’t move easily from one question to other , and it was quite a tedious session for me. But he was quite satisfied with most of my answers and I was able to clear this round. Do not worry unnecessarily be confident because confidence is what matters. I have seen many who have knowledge and good grip over programming language could not make it but guys who had confidence could clear this round.

This is the actual filtering interview.The interview started with me waiting One Hour outside the cubicle, completely tensed and was facing with my back towards the Interviewer. Only the glass partition and the ongoing interviewee were separating us.I during my long halt at the door had to rotate my neck nearly 360 DEGREES to get a glimpse of things inside.It was increasing my nervousness more as I could see the girl inside continuously writing or talking , and her body language was as if she ‘trying to convince,with all the greatness installed in her system’,and the interviewer just had a casual look.Now after that tense hour , finally the door opened but I was waiting outside, I had drank a few glasses of water during that hour and was very nervous only because i had just went through a tedious Ist TI.Soon a volunteer asked me to enter the room and things changed upside down.

All of the atmosphere was quite became same as that of Ist TI.And soon the Interviewer smiled and asked few personal questions and even I answered them with a happy face but with heavy heart.After that he went through my Resume and asked about my internship with a online engineering portal and things related to it. I was quite quick to answer them and he seemed interested.Soon he asked about Java and the famous static keyword.Later he asked about Java Technologies like Swings,AWT.Next Questions were on Servlets,JSP their differences and Netbeans IDE.He also asked about the MVC Model and explaination for the same.

It took lot of time in all these questions.Soon he leaned on the table after making an effort to bring his chair closer to the table and smiled.Now he told I am going to ask you few questions for which you have to provide not just an answer but support with an equally defining logic.This got me triggered and I smiled a bit and replied ,OK.Then he asked the first Puzzle type Ques of the Interview,”How many steps you walk daily right from your doorstep till the moment you step into the college classroom,you have exactly 10 minutes he said looking into his watch(it was already 5:34 in the evening)”.I answered it without using pen and paper and provided explanation for every step I mentioned.At the end he was convinced and we both laughed , as a result he got interested and was happy and said “I want to ask One MORE”.I said sure and he asked” Assume Rajasthan as the state of concern for us for the moment , and tell me how many Camels were drinking water today at 2pm “.I dont know how but I answered this as it came with no hiccups and he said “I m convinced”.Soon he asked few more personal questions and the TI-II was over.

HR & Management Interview:
It was 20 minutes after my TI-II and lasted for the same span of time that is 20 minutes.I entered in and there were two HR Managers waiting.One of them stood throughout the the interview the other sat casually laid back into his seat.I went inside soon he said to have a seat.He asked me the most GENERIC questions.

  • Tell me about Yourself.
  • Your Hobbies.
  • Your Interests and qualities that will benefit our Organization.

(In the meantime while I was busy answering, the TI-II interviewer stepped in and I greeted him with a smile).Later the standing HR Manager asked me question.
Suppose you are a Team Leader with a promotion in hand to be give away among Three of your Members.No 1 is punctual but does not provide 100% solution guarantee.No 2 is not punctual but when he is around job is Done.No 3 is Lazy but provides 100% solution guarantee, how will do the promotion thing?

I took approx 20 seconds and replied, “I will promote the lazy member on condition he leaves his laziness”
There was lot of cross-questioning on why not the No 1 or No 2 but I hold on to my answer and later he replied placing my Resume on the bunch of papers and said “SELECTED!!!”

I never relied on his comment but felt that I was through but after exactly 13 longgg days my college TPO got a mail with my name at no 3 and only 13 was the head count of Final Selects.


  • This was entirely based on my experience. And I no way assure that you would be undergoing through the same process. This was the procedure followed for 2014-2015 candidates.
  • Go through all the Data structure Basics and Tree basics and Java Fundamentals and you should make it.
    Be confident and make yourself be portrayed logical and sound.
  • Dont play skipping stones while answering “No Single Answer” question/puzzles.
  • Stick to one answer and provide a valid reason.

Xoriant Placement Process

Xoriant Placement Process-Recruitment Drive:
About Xoriant:
Xoriant was one such company for which I was searching whole over the Internet but was not able to find any relevant information regarding its placement process. This prompted me to give you all the brief description of the Xoriant placement process. First things first, Xoriant is a Software product development company. It has been in this software development arena for past two decades and is a CMM level-4 organisation as of 2014. For further information about Xoriant I would recommend you to read this article

Placement Process:
General outline of the Xoriant Placement Process:

  • Pre-Placement talk
  • Online Aptitude Test
  • Group Discussion
  • Technical Interview
  • HR and Management Interview

Pre-Placement talk:
Now coming to the placement process, it is slightly different from that of TCS. Firstly you would be subjected to a pre-placement talk. This would last around for 30 to 45 minutes. Basically they would talk about their whole roots and origin, their current position in the industry and most importantly they would discuss about their working lifestyle. After this you would be subjected to an aptitude test. However one more thing to get clarified is that Xoriant is not a bulk recruiter and usually takes two or three candidates and this was the case in my campus. And as of 2014-2015, Xoriant was offering Rs 4.5 lakhs for new recruits in Mumbai region.

Online Aptitude Test:
As usual the aptitude test is conducted online. One thing which I found that in its aptitude test, Xoriant even gives a programming question for a challenge. That is aptitude and programming questions were integrated. Even more interesting fact was that all those who cleared the aptitude were only those who could get through this programming challenge. In 2014-2015 recruitment process there were two Programming questions asked, basically we were given the task to write two programs. Programs were kept at the end of the normal aptitude questions and were evaluated by an online compiler that was integrated within their aptitude software itself. This was the new process that was introduced especially for 2014-2015 batch. Further moving into detail we were specifically given two programs based on Set (Collection Interface) and Map of Java Data Structures. So I recommend you reading the basic methods of these data structures. You could refer to these basic methods from

Group Discussion:
All the candidates who have cleared aptitude cum programming challenge test are now subjected to Group Discussions (GD). Frankly speaking there was a sharp decline in those who got selected for GD. From the total of 87 students who gave aptitude test only 17 finally got selected to the GD. In my campus GD was taken in a two groups of 8 and 9 candidates respectively. Now talking about the purpose of GD, basically the recruitment people were trying to figure out our communication skills and analyzing capability. For instance in my case, we were given a topic “If you were a government and given Rs 1000cr to be used for whole of India what would you invest on, whether on Eradication of Poverty or Space Programme ”. So basically this was a kind of question looking out for our analyzing skills. And finally from this round only around 8 candidates were selected for the Technical Interview Process.

Technical Interview:
In the technical interview there was nothing which I found different. Basically I would recommend all to have a thorough understanding of your project. Basically say if you were building some software on say MVC architecture then you should have a good understanding of the architecture itself. So it is essential for you to have a deeper insight of your project. Further you would be asked some simple programming questions like write a logic for Printing Fibonacci Series in reverse order say from number 13 to 0 onwards (i.e. 13,8,5,3,2,1,1,0 ). These were few questions to which I was subjected.

HR & Management Interview:
From the group of 8 students only 5 got selected for HR Interview process. And again in HR there was nothing different. To prepare for HR questions “Click here”. And finally, only 3 candidates were selected by Xoriant from my campus.This was all about Xoriant Placement Process.

Note: This was entirely based on my experience. And I no way assure that you would be undergoing through the same process. This was the procedure followed for 2014-2015 candidates.

L&T Recruitment process

L&T placement process 2014-2015:

Step-1: Pre-Placement Process
If L&T InfoTech is coming to your campus then you would be definitely notified by your TPO (Training and placement officer). First of all, you would be sent a softcopy of L&T Trainee application form and a self declaration form. Once you receive you need to take a print out of these forms. These need to be filled and submitted on your placement day. Also make sure you attach your photograph in the application form. And it is essential that you fill the form with BLACK ball pen. This is essentially the pre-placement process that every aspirant needs to do. This was what the process that was prevalent for 2014-2015 batch. Further L&T have their recruitment drive around September-October in Mumbai region. This is what the usual trend is.

Step-2: Placement Day
On the placement day it is essential that candidates carry following along with them

  • Trainee application and Self Declaration form
  • Resume/CV
  • College-ID card
  • Passport size photograph (2 is enough)
  • Finally attested photocopies of all the certificates (Class-X, XII, All semester exam mark sheet copy) along with the original certificates.

Note: These are just the basic requirements; other requirements would be specified either by TPO or through email to you.

The recruitment process is usually a day long and ends around 8.00 or 9.00pm. About eligibility criteria it would be notified to you by your TPO. In Mumbai region L&T made eligibility criteria 55% (for 6 semesters if L&T is coming in 7th Semester) in the last moment. However the candidate needs to have an aggregate of 60% at the end of B.E. The recruitment process was open for Information Technology, Computer Science, EXTC, Bio-Technology, Mechanical and MCA students. Further top 15% of candidates from a particular branch are exempted from giving aptitude.

The recruitment process of L&T is quite different from TCS. Recruitment process consists of:

  • Pre-Placement talk
  • Online/Offline aptitude test
  • Group Discussion
  • Paragraph Writing
  • Technical & HR Interview.

The whole of pre-placement talk is concentrated on what are the positions, hierarchy of the organization and all about L&T InfoTech history. This usually lasts for 30 minutes or so. After that L&T conducts Offline or Online aptitude. In my campus it was offline that is it was a paper based aptitude test. For aptitude preparation tips and techniques “Click here”.

Followed by aptitude the select candidates would be subjected to a group discussion (GD). Usually GD conducted by L&T consists of 10 to 12 members and is roughly for duration of 10-15 minutes. Again this is also an elimination round. Roughly 5 to 6 candidates are selected from 10 to 12 candidates subjected to GD. However the GD is entirely performance based and above figures is just an estimate. GD topics are usually abstract in nature. A list of selected candidates would be announced for paragraph writing.

However the paragraph writing is not an elimination round. And then the candidates are subjected to Technical Interview. Here the candidates are expected to be well versed with core computer and programming concepts. For technical interview preparation there are few sites that I recommend you to check out:

These are few links that would be helpful for your Technical interview preparation.

Finally the candidates who have cleared the Technical interview are then subjected to HR interview. For HR interview preparations “Click here”. Further it is essential that candidate is well prepared about L&T history as few HR questions may be based on pre-placement talk. For more information about L&T visit- And by the end of the day that is around 8.00 or 9.00 pm the HR or the person in charge would announce a final list of selected candidates and a copy of list would be provided to your TPO (Training and Placement officer).

error: Content is protected !!