AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
CARE Analytics and Advisory
Compare
Filter interviews by
CARE Analytics and Advisory Software Developer Interview Questions, Process, and Tips
Top CARE Analytics and Advisory Software Developer Interview Questions and Answers
- Q1. What you will don if a SQL query taking time to run.
- Q2. what is interface class
- Q3. how to handle global exception
CARE Analytics and Advisory Software Developer Interview Experiences
2 interviews found
Anonymous
(2 Questions)
- Q1. What is interface class
- Ans.
An interface class in software development is a blueprint for a class that defines a set of methods that a class must implement.
Interface classes contain abstract methods that must be implemented by any class that implements the interface.
Interfaces allow for multiple inheritance in programming languages that do not support it.
Interfaces are used to define a contract for classes to adhere to, ensuring consistency and i...
- Q2. How to handle global exception
- Ans.
Global exceptions can be handled by using try-catch blocks in the code.
Use try-catch blocks to catch exceptions at a global level
Implement a global exception handler to log or display the exception details
Consider using frameworks like Spring Boot for handling global exceptions
(2 Questions)
- Q1. What you will don if a SQL query taking time to run.
- Ans.
I will analyze the query execution plan, optimize the query, check for indexing, and consider partitioning.
Analyze the query execution plan to identify any bottlenecks or inefficiencies.
Optimize the query by rewriting it, adding indexes, or restructuring the data.
Check for proper indexing on the tables involved in the query.
Consider partitioning large tables to improve query performance.
Use tools like SQL Profiler or D...
- Q2. Type of indexes
- Ans.
Indexes in databases help improve query performance by allowing faster data retrieval.
Types of indexes include B-tree, hash, bitmap, and full-text indexes.
B-tree indexes are commonly used for range queries.
Hash indexes are useful for equality queries.
Bitmap indexes are efficient for low cardinality columns.
Full-text indexes are used for searching text data.
Skills evaluated in this interview
Neelanjana Chakravarty
Selected
I applied via Naukri.com and was interviewed in Apr 2024. There were 2 interview rounds.
Technical Test round for Java and .Net
(4 Questions)
- Q1. There were many questions
- Q2. Java technology
- Q3. .Net Technology
- Q4. Python Technology
Top trending discussions
Interview questions from similar companies
Interview Questionnaire
1 Question
- Q1. A-Z in MySQL, programming languages(only concepts)
I applied via Campus Placement and was interviewed before Mar 2020. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Basics about .Net and SQl server
- Q2. What are triggers
- Ans.
Triggers are database objects that automatically execute in response to certain events or changes in data.
Triggers are used to enforce business rules or data integrity.
They can be used to audit changes to data.
Triggers can be set to execute before or after an event, such as an insert, update, or delete operation.
They can be defined on tables, views, or schemas.
Examples of triggers include sending an email notification ...
Interview Preparation Tips
Skills evaluated in this interview
Interview Questionnaire
1 Question
- Q1. Tell me something about your self?
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Sep 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Technical questions on Microsoft .net/core Azure.
Interview Preparation Tips
Some formality question may ask like tell me about yourself? what were you are doing so far?are you comfortable for something like in night shifts? etc to check your communication. I advise be honest with yourself on this questions so that you may avoid searching next job after immediately joining the next organisation. I also request don't say yes for sake of yes for the offer and based on that you search the next organisation during your notice period and finally you may drop all the less offered salaries organisations, believe me the offer which you have rejected that may help to the needy person and also maintain the trust in the IT industry if you are honest with yourself.
thanks and best of luck.
I applied via Campus Placement and was interviewed in Jul 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Another Skills Prepare for this job?
Interview Preparation Tips
I applied via Naukri.com and was interviewed before Jan 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Java Basic questions and Git
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Aug 2020. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Interfaces
- Q2. Oop concepts
Interview Preparation Tips
I applied via Walk-in and was interviewed in Aug 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. They ask only basics of programming languages which are mentioned in resume
Interview Preparation Tips
CARE Analytics and Advisory Interview FAQs
Tell us how to improve this page.
CARE Analytics and Advisory Interviews By Designations
- CARE Analytics and Advisory Software Developer Interview Questions
- CARE Analytics and Advisory Analyst Interview Questions
- CARE Analytics and Advisory Internship Trainee Interview Questions
- CARE Analytics and Advisory Software Engineer Interview Questions
- CARE Analytics and Advisory Business Analyst Interview Questions
CARE Analytics and Advisory Software Developer Interview Process
based on 2 interviews
Interview experience
Software Developer Interview Questions from Similar Companies
Fast track your campus placements
CARE Analytics and Advisory Software Developer Reviews and Ratings
based on 2 reviews
Rating in categories
|
Software Engineer
40
salaries
|  ₹2.2 L/yr - ₹7.3 L/yr |
|
Business Analyst
24
salaries
| ₹7 L/yr - ₹12 L/yr |
|
Senior Software Engineer
12
salaries
| ₹5.4 L/yr - ₹11.5 L/yr |
|
Associate Director
10
salaries
| ₹30.1 L/yr - ₹41 L/yr |
|
Project Lead
8
salaries
| ₹13.6 L/yr - ₹25 L/yr |
TCS
Accenture
Wipro
Cognizant
- Home >
- Interviews >
- CARE Analytics and Advisory Interview Questions >
- CARE Analytics and Advisory Software Developer Interview Questions
