PHP Agency Interview Questions and Answers

Q1. Interview was taken in malad on interface 7 building The relationship officer Vaibhav Panchal . He assigned Interviewer the way he was talking he was not able to speak in english half of the question i was...read more
Add your answer
Q2. His english was poor How you will get the customer count who speak in english? he didn't gave me which table to fetch from ? * question changed get the customer from one table and count from the other ...read more
Add your answer

Q1. Explain your last project and your role in this project
Add your answer
Q2. Overall working experience with other companies
Add your answer
Q3. Why choose kafka over MQ ? what challenges you faced during kafka implementation ?
Add your answer
Q4. Monolith to microservice migration journey ? what all decisions needs to be taken and how the entire migration took place.
Add your answer
Q5. If worked for RestAPI ? what is the use of swagger ? what is the content of Swagger documentation ?
Add your answer
Q6. Only this was asked to me , and rejected
Add your answer

Here’s a simple framework to approach a case study effectively:


---

Case Study Framework

1. Understand the Problem

Read the case thoroughly and identify the key issue.

Ask clarifying questions if needed (if in a live setting).

Summarize the problem in your own words.



2. Analyze the Situation

SWOT Analysis (Strengths, Weaknesses, Opportunities, Threats)

Identify relevant stakeholders.

Gather data or key insights from the case text.



3. Identify Alternatives

Brainstorm possible solutions to the problem.

Consider multiple approaches (e.g., short-term vs. long-term solutions).



4. Evaluate the Alternatives

Weigh the pros and cons of each solution.

Assess feasibility, costs,

Q1. What are the common performance issues that can occur in a system?
Ans. 
Common performance issues in a system include slow response times, high resource usage, bottlenecks, and crashes.
• Slow response times can be caused by inefficient code, network latency, or overloaded servers.

• High resource usage can lead to system slowdowns and crashes, often caused by memory leaks or inefficient algorithms.

• Bottlenecks occur when a component of the system becomes a limiting factor, such as a database ser...read more
Answered by AI
Add your answer
Q2. What is your experience with software bug fixing?
Ans. 
I have experience in identifying and resolving software bugs through thorough testing and collaboration with developers.
• Identifying bugs by reproducing issues reported by users

• Collaborating with developers to understand root cause of bugs

• Testing bug fixes to ensure they are effective

• Utilizing bug tracking tools like Jira or Bugzilla

• Experience with regression testing to prevent reoccurrence of bugs
Answered by AI
Add your answer

Shortcut Tips for Coding Tests: 1. Master the Basics: Familiarize yourself with arrays, strings, loops, and conditional statements. 2. Learn Patterns: Concentrate on sliding window, two-pointer techniques, recursion, and divide-and-conquer methods. 3. Use Standard Algorithms: Study breadth-first search (BFS), depth-first search (DFS), sorting algorithms, and dynamic programming principles. 4. Understand Data Structures: Practice with stacks, queues, linked lists, and trees. 5. Practice Edge Cases: Consider scenarios involving empty inputs, duplicates, and large datasets. 6. Write Pseudocode: Outline your plan before starting to code. 7. Optimize Early: Always strive for efficiency in your solutions.

Q1. Filters in Tableau
Add your answer
Q2. Blending and joins in Tableau
Add your answer
Q3. LOD expressions in Tableau
Add your answer
Q4. Different types of Joins in SQL, difference between TRUNCATE and DELETE
Add your answer

Q1. About my technical experience
Add your answer
Q2. What will you do if you get the offer from multiple companies
Add your answer

Q1. Introduction, be prepared to have knowledge on your resume
Add your answer
Q2. Mathematical questions like percentage
Add your answer
Q3. Critical thinking. They asked a question with a given situation what you'll do .
Add your answer
Q4. The past 4 days been climate be stroming . And current was cut off due to rain and flood , you have a important assignment to finish, what you'll do
Add your answer

The test will comprise a total of 60 questions, divided as follows: 70% of the questions will focus on finance and accounting, while the remaining questions will cover aptitude and English.

Q1. Zero coupon bonds, long-term liabilities, return on equity, debt-equity ratio, captial budgeting and techniques, bonds and its types, debt instruments meaning, collateral, mortgage, spin off, demerger, mer...read more
Add your answer

Q1. Write your own implementation for shared pointer. How it will handle if it get assigned by another one. How will you use it in main method. How will you overload -> operator and dereferencing operator in t...read more
Ans. 
Implementation of shared and unique pointers in C++ with operator overloading.
• Implement a class for shared pointer with reference counting.

• Handle assignment by incrementing reference count and decrementing old pointer's count.

• Overload -> and * operators to access underlying object.

• Use shared pointer in main method by creating instances and passing them around.

• For unique pointer, implement a class that transfers ownersh
Answered by AI
Add your answer
Q2. Simple problem for binary search but input values are double not integer
Add your answer

Q1. Given bst find two values from tree which will give you required sum. In two pointer is it better to use middle-out instead of starting from both end probabilistically
Add your answer
Q2. Design splitwise like add and explain
Add your answer

Q1. Write signature of shared pointer
Add your answer
Q2. Design system similar to load balancer where if request comes again with same id it should go to server it went for first time. with constant space complexity
Add your answer
Q3. Design system where there is org hierarchy and you should be able to find all sub-ordinates Optimize is using array of pointer
Ans. 
Design a system with org hierarchy to find all sub-ordinates using array of pointers.
• Create a class for each employee with a pointer to their manager

• Use an array of pointers to store all employee objects

• Traverse the array to find all sub-ordinates of a given employee
Answered by AI
Add your answer
Q4. Write lambda function and it's signature
Add your answer
Q5. Do you know about template Class and function template
Add your answer
Q6. How does auto work internally?
Add your answer

Q1. Are you ready to shift to bengaluru
Ans. 
Yes, I am ready to shift to Bengaluru for the c++ associate position.
• I am excited about the opportunity to work in Bengaluru.

• I have researched the city and am comfortable with the relocation.

• I am flexible and adaptable to new environments.

• I have friends/family in Bengaluru who can support me during the transition.
Answered by AI
Add your answer

There were three coding questions.

Q1. Could you provide a thorough explanation of the project?
Add your answer
Q2. OOps Concepts and question from the technical subjects
Add your answer
Q3. Why Spring Boot
Add your answer
Q4. JWT Authentication
Add your answer
Q5. Docker and Kubernetes
Add your answer

Q1. What currently you are doing in your project?
Ans. 
I am currently leading a team in designing and implementing a new database system for our project.
• Leading a team in designing a new database system

• Implementing the new database system

• Ensuring data integrity and security measures are in place
Answered by AI
Add your answer
Q2. How proficient you are in SQL?
Ans. 
I am highly proficient in SQL with extensive experience in writing complex queries, optimizing database performance, and designing database schemas.
• Extensive experience writing complex SQL queries

• Optimizing database performance through SQL

• Designing database schemas using SQL

• Familiar with advanced SQL concepts such as joins, subqueries, and indexing
Answered by AI
Add your answer
Q3. Why you have gap before MBA?
Ans. 
I took a gap to gain practical work experience and save money for my MBA.
• To gain practical work experience relevant to my field of study

• To save money for tuition and living expenses during my MBA program

• To take a break and reassess my career goals before committing to further education
Answered by AI
Add your answer
Q4. Explain procedures from SQL.
Ans. 
SQL procedures are reusable blocks of code that can be called to perform a specific task.
• Procedures are created using the CREATE PROCEDURE statement.

• They can accept input parameters and return output parameters.

• Procedures can be called using the EXECUTE or CALL statement.

• They are used to encapsulate logic for tasks that need to be performed repeatedly.

• Procedures can improve performance by reducing network traffic.
Answered by AI
Add your answer