DemandShore Solutions Interview Questions and Answers

Q1. Find length of longest substring, without repeating charecters
Add your answer
Q2. Implement a custom method for Memoization
Add your answer
Q3. What is this keyword, and follow up questions were asked on this
Add your answer
Q4. Deep copy and shallow copy
Add your answer

The test was easy, containing data interpretation questions

Q1. Case study to evaluate my approach
Add your answer
Q2. Guesstimate to evaluate my approach
Ans. 
To evaluate your approach, I would estimate the number of cars passing through a busy intersection in a day.
• Identify the average number of cars passing through the intersection per minute

• Calculate the total number of minutes in a day

• Multiply the average cars per minute by total minutes in a day to get an estimate
Answered by AI
Add your answer

Q1. Difference between reach and engagement?
Add your answer

Q1. Tell me about yourself?
Ans. 
I am a dedicated and detail-oriented PMO Analyst with a strong background in project management and data analysis.
• I have a Bachelor's degree in Business Administration with a focus on project management.

• I have experience in creating and maintaining project plans, tracking progress, and analyzing data to identify trends and areas for improvement.

• I am proficient in using project management tools such as Microsoft Project...read more
Answered by AI
Add your answer
Q2. Where do you see yourself in 5 years?
Ans. 
In 5 years, I see myself as a seasoned PMO Analyst leading strategic projects and mentoring junior team members.
• Leading strategic projects within the organization

• Mentoring junior team members to help them grow professionally

• Continuing to enhance my skills and knowledge in project management

• Possibly pursuing advanced certifications in project management
Answered by AI
Add your answer

Q1. Powerbi features?
Add your answer
Q2. PM roles and responsibility
Ans. 
PM roles involve planning, organizing, leading, and controlling project activities to achieve project goals.
• Develop project plans and schedules

• Coordinate project resources and stakeholders

• Monitor project progress and report on status

• Manage project risks and issues

• Ensure project deliverables meet quality standards

• Facilitate communication among team members

• Adapt to changes in project scope or requirements
Answered by AI
Add your answer

Q1. What is the Triggers
Ans. 
Triggers are special types of stored procedures that are automatically executed when certain events occur in a database.
• Triggers are used to maintain referential integrity, enforce business rules, and automate actions in a database.

• They can be set to execute before or after INSERT, UPDATE, or DELETE operations on a table.

• Examples of triggers include auditing changes to a table, updating a related table when a record is
Answered by AI
Add your answer
Q2. What is the Stored Procedures
Ans. 
Stored procedures are precompiled SQL queries stored in a database for reuse.
• Stored procedures are used to perform specific tasks or operations in a database.

• They can improve performance by reducing the amount of data sent between the database and application.

• Stored procedures can be called from within other SQL queries or from application code.

• They can also help with security by controlling access to data and enforcin
Answered by AI
Add your answer

String Array manipulation

Q1. Different activity launch modes, services, intent-services
Ans. 
Different launch modes control how activities are launched, services run in the background, and intent-services handle asynchronous tasks.
• Launch modes include standard, singleTop, singleTask, and singleInstance

• Services are used for long-running operations in the background

• Intent-services are used for handling asynchronous tasks on a separate worker thread
Answered by AI
Add your answer
Q2. Normal android sdk related questions and about third party libraries
Add your answer

Q1. Interview with India Director
Add your answer

Q1. Let me know about yourself
Add your answer
Q2. Normal queries about you
Add your answer

Q1. Which function is used to calculate weighted product
Ans. 
The function used to calculate weighted product is the SUMPRODUCT function.
• The SUMPRODUCT function multiplies corresponding components in the given arrays and returns the sum of those products.

• It is commonly used in financial analysis, inventory management, and supply chain optimization.

• Example: =SUMPRODUCT(A1:A3, B1:B3) will calculate the weighted product of values in cells A1 to A3 and B1 to B3.
Answered by AI
Add your answer
Q2. What can we use to summarize the data
Ans. 
Data can be summarized using various methods such as charts, graphs, tables, and statistical measures.
• Charts: Visual representation of data like bar charts, pie charts, line graphs.

• Graphs: Representing data points and relationships between them.

• Tables: Organizing data in rows and columns for easy comparison.

• Statistical measures: Calculating averages, medians, standard deviations, etc.
Answered by AI
Add your answer

Q1. Tell me about yourself
Ans. 
I am a dedicated MIS executive with a strong background in data analysis and reporting.
• Experienced in managing databases and generating reports for decision-making

• Proficient in data visualization tools such as Tableau and Power BI

• Skilled in identifying trends and patterns in data to improve business processes
Answered by AI
Add your answer
Q2. Questions related to Hobbies
Add your answer

Q1. Countif, countifs, sumif, sumifs
Add your answer
Q2. Question related to vlookup
Add your answer

Q1. Tell me About yourself in detailed
Ans. 
I am a dedicated and hardworking individual with a passion for learning and helping others.
• Graduated with honors from XYZ University

• Worked as a volunteer at local community center

• Currently pursuing a certification in project management
Answered by AI
Add your answer
Q2. What's your experience and how your experience help us
Ans. 
I have over 10 years of experience in project management, leading cross-functional teams to successful project completion.
• Led multiple projects from initiation to closure, ensuring on-time and within budget delivery

• Managed stakeholder expectations and communication effectively

• Utilized project management tools and methodologies to streamline processes

• Trained and mentored junior team members in project management best pr
Answered by AI
Add your answer
Q3. What's your previous job roles
Ans. 
I have worked as a marketing coordinator, sales associate, and customer service representative in my previous job roles.
• Marketing coordinator - Developed marketing strategies and campaigns to promote products/services.

• Sales associate - Assisted customers with product selection and processed transactions.

• Customer service representative - Handled customer inquiries, resolved issues, and provided support.
Answered by AI
Add your answer
Q4. How many years of experience you have
Ans. 
I have 10 years of experience in the field.
• 10 years of experience in the industry

• Extensive knowledge and skills acquired over the years

• Proven track record of successful projects and achievements
Answered by AI
Add your answer
Q5. And also some behavioural questions
Add your answer