All Check Services Interview Questions and Answers

Q1. Basic c#and MVC architecture, partial view, singleton class
Add your answer
Q2. Index ,view, optimisation techniques in database
Ans. 
Indexing, viewing, and optimization techniques are essential for improving database performance.
• Use indexes to quickly retrieve data from tables

• Regularly analyze and optimize queries for better performance

• Utilize views to simplify complex queries and improve readability

• Consider partitioning tables for better manageability and performance

• Use tools like explain plans to analyze query performance
Answered by AI
Add your answer

Q1. Difference in MVC and ado.net, filters in MVC, resultset in mvc
Ans. 
MVC is a design pattern for organizing code in web applications, while ADO.NET is a data access technology for connecting to databases.
• MVC stands for Model-View-Controller and helps in separating concerns in web applications.

• ADO.NET is a data access technology in .NET framework for connecting to databases.

• Filters in MVC are used to add pre-processing or post-processing logic to controller actions.

• Resultset in MVC refer...read more
Answered by AI
Add your answer
Q2. Rank functions in SQL server
Ans. 
Functions in SQL server can be ranked based on their usage, complexity, and performance.
• Rank functions based on usage - COUNT, SUM, AVG, MAX, MIN

• Rank functions based on complexity - CASE, COALESCE, ISNULL

• Rank functions based on performance - ROW_NUMBER, RANK, DENSE_RANK
Answered by AI
Add your answer

Q1. Brief introduction
Add your answer
Q2. Skills test online
Add your answer

Q1. Windows server AD roles
Add your answer
Q2. Group polices & server administrator basic questions
Add your answer
Q3. Windows server troubleshooting issues
Ans. 
Windows server troubleshooting issues
• Identify and resolve network connectivity problems

• Troubleshoot server performance issues

• Resolve software installation and configuration problems

• Investigate and fix server hardware failures

• Address security vulnerabilities and apply patches

• Diagnose and resolve Active Directory issues
Answered by AI
Add your answer

Q1. Salary discussion & previous company experiences
Add your answer

Basic DSA and fronted questions were asked

Q1. Salary negosiation
Add your answer
Q2. Joining data and basic HR questions wew asked
Add your answer

Q1. About current and expected CTC, experience, willingness to relocate.
Add your answer
Q2. About company’s policy of taking a security cheque of 3 months’ salary.
Add your answer
Q3. Emphasis on giving interview without proper preparation time.
Add your answer

Q1. Accounting questions
Add your answer

Q1. When the Junior HR didnt get back. Senior HR called after my followup. He tried justifying giving less salary.
Add your answer
Q2. The only disappointment was that if the co. didnt have the required budget then why consent to it initially and emphasize on giving an interview.
Add your answer
Q3. The HR goes silent. You have to keep following up.
Add your answer

Q1. Project explanation, tell me about yourself
Ans. 
I am a data scientist with experience in machine learning and data analysis.
• I have worked on projects involving predictive modeling, natural language processing, and computer vision.

• I am proficient in programming languages such as Python and R, and have experience with tools like TensorFlow and Tableau.

• I have a strong background in statistics and mathematics, and am able to communicate complex ideas to both technical a
Answered by AI
Add your answer

Q1. About the company, about previous company
Add your answer

Q1. Ensemble technique, difference between bagging and boosting and all their models
Ans. 
Bagging and boosting are ensemble techniques used to improve model performance by combining multiple models.
• Bagging involves training multiple models on different subsets of the data and combining their predictions through averaging or voting.

• Boosting involves iteratively training models on the same data, with each subsequent model focusing on the misclassified samples of the previous model.

• Examples of bagging models i...read more
Answered by AI
Add your answer
Q2. What is random in random forest, case study question what would u suggest to increase the revenue of the store
Add your answer
Q3. RFM analysis, customer segmentation, explain project written in your resume. Just go through the dataset in the detailed way like what are the columns and dependent variable etc they asked in detail.
Add your answer
Q4. Tell me about ur overall professional journey
Ans. 
I have had a diverse professional journey with experience in various industries.
• Started as a software engineer at a tech startup

• Moved to a management consulting firm as a data analyst

• Transitioned to a healthcare company as a data scientist

• Currently working in a fintech company as a senior data scientist

• Have experience in machine learning, data visualization, and project management
Answered by AI
Add your answer

Q1. No Interview just search the keywords and find the answer from company website
Add your answer

Q1. Basic Situational questions
Add your answer

Q1. Generic questions
Add your answer

Before you participate in a GD, consider engaging in other public speaking opportunities to build your confidence and skills. 😍😍

Q1. Q1. Tell me about yourself Q2. What motivates to take your career in recruitment Q3. Why have you choose HR Stream in MBA instead of others
Add your answer
Q2. Tell me about yourself
Add your answer

Q1. It is real ya not
Add your answer
Q2. How to work is coronis
Ans. 
Coronis is a software platform used in the insurance industry to streamline processes and improve efficiency.
• Coronis helps insurance companies automate tasks and workflows.

• It provides tools for policy management, claims processing, and underwriting.

• The platform integrates with various data sources to gather information for risk assessment.

• Coronis enables better customer service through faster response times and accurat...read more
Answered by AI
Add your answer
Q3. How many years your experience
Ans. 
I have 15 years of experience in the insurance industry.
• I have been working in the insurance industry for 15 years.

• My experience includes various roles such as underwriting, claims management, and sales.

• I have a deep understanding of insurance policies, risk assessment, and client management.

• During my career, I have successfully handled complex insurance claims and developed strategic partnerships with key clients.

• I ha...read more
Answered by AI
Add your answer
Q4. How many years you have entered school
Ans. 
I have entered school for 16 years.
• I have completed 12 years of primary and secondary education.

• I have completed 4 years of undergraduate studies.

• I have not pursued any further education beyond that.

• Total years of schooling: 12 + 4 = 16.
Answered by AI
Add your answer

Q1. Tell me something about yourself.
Add your answer
Q2. Tell me more about your work experience.
Add your answer
Q3. What have you done in your domain and how did it help your company?
Add your answer

The CEO of client firm has reported that there has been increase in number of applicants for job at their firm by 50% but the growth in new hires has decreased by 15%. You need to help him/her investigate the cause.
[Please note that I stands for Interviewer and C stands for Candidate]

C: I would like to know more about the product the firm sells.

I: Firm is like TCS services and has similar operations.

C: How have the profits and sales grown in the said period?

I: The firm is doing well. There is in fact, an increase in the profits.

C: Has the competition also faced a similar issue related to hiring?

I: We do not know about the competitors and their hire growth-rates.

C: There can be two approaches to the problem. The reason could be because of either external or internal factors. Do you want me to look at any one of these first?

I: I would like you to tell me how it could be external and how could it be internal.

C: It can be external in terms of the macro effects such as general outlook of the service, technology needed by the employees in the domain, etc. It can be internal in terms of factors such as product outlook in market, promotions made for the work environment, place - work place (infrastructure) employee satisfaction, employee wages, company requirement of employees etc. Do you want me to take any one of these?

I: Yes. Please go ahead with internal factors.

C: Considering the increase in job applications we can look at promotions, salaries, place. Has there been any change in type of employees that are required for services that the client provides?

I: No, there has been no change.

C: Considering the increase in job applications again we can rule out employee satisfaction process, then we would be left with hiring process, has there been any changes in structure of hiring process, the panel, number of rounds, etc.?

I: No, there has not been any change in structure of hiring process.

C: Despite the increase in the number of applications the hiring process has not changed. This might have led to a situation where due to large volume of applications there is a delay in hiring process. Is the hiring process on first come first serve bases or best of interviewees model?

I: Yes, there has been increase in delay time because the company follows best of interviewees model. That would be it. Thankyou.

Your client is a lemonade seller in Lucknow, and he wants you to provide a strategy to expand his reach in entire UP.
[Please note that I stands for Interviewer and C stands for Candidate]

C: What type of lemonade is the client selling and are there any constraints that my client wants me to take care of?

I: It is a regular lemonade available in 2 variants, soda, and non-soda. No, you do not have any constraints and assume there is no investment restriction.

C: First, I would like to look at the factors that affect my strategy. From supply side would look at the raw materials, infrastructural cost, production process cost and distribution/logistics cost. From demand side, the reach of customers towards the shop, the competitors, etc.

I: Good, now how will you choose the locations(cities) for your expansion in UP.

C: Since we are not restricted on the investment that we get, we can think in terms of demand, first in short run I would be looking into metro and tier-1 cities like Noida and Kanpur. In the long term, would focus on tier 2 and tier 3 cities.

I: Well, now considering that you have a lemonade in Lucknow how would you price your lemonade?

C: The pricing can be done in 3 ways, cost based, competition based, and value based. Since we are having no investment restriction, I would go ahead with competition and value based. First, I would like to consider an additional value of the lemonade to be Rs 3. Given high investment, I would like to assume that we are using high quality raw material and equipment and thus, producing high quality lemonade. With the cost assumptions that paper cup costs Rs 2, Rs 2 for raw materials, Rs 3 for processing and a margin of Rs 2, the lemonade for competitors is priced at Rs 9. Adding the value to this, we can say that the price of lemonade should be Rs 12 for our client.

I: Good, I think that sums up the case.