Filter interviews by
I applied via Recruitment Consulltant and was interviewed in Jun 2022. There were 3 interview rounds.
It's was SQL server
They give 20+ query based on different scenario of SQL
And SQL server theory questions like
Different between Store procedure
And functions
What is indexing types of indexing
How to optimise table
SQL jobs
SQL trigger
Deadlock handle
CTE
Temp table
Primary key, foregin key, unique key
How to get 50% of data from table
I applied via Referral and was interviewed before Sep 2021. There were 4 interview rounds.
SDLC stands for Software Development Life Cycle. It is a process used to develop software applications.
SDLC is a systematic approach to software development.
It consists of several phases including requirements gathering, design, coding, testing, and maintenance.
There are various SDLC models such as Waterfall, Agile, Spiral, and V-Model.
Waterfall model follows a linear sequential approach where each phase is completed b...
Defect life cycle is the process of identifying, reporting, fixing, and verifying defects in software.
Defect is identified by testers during testing
Defect is reported to development team
Development team fixes the defect
Fixed defect is verified by testers
If defect is not fixed, it goes back to development team
If defect is fixed, it is closed
STLC stands for Software Testing Life Cycle which is a process of testing software from planning to deployment.
STLC involves several phases such as requirement analysis, test planning, test case development, test execution, and test closure.
Each phase has its own set of activities and deliverables.
STLC helps to ensure that the software is thoroughly tested and meets the quality standards.
STLC is an iterative process an...
SQL query to display the total number of students whose names start with 'A' from the child details table.
Use the SELECT statement to retrieve data from the table.
Use the COUNT function to count the number of rows that meet the condition.
Use the LIKE operator with the pattern 'A%' to match names starting with 'A'.
Joins are used to combine data from two or more tables based on a related column.
Types of joins: Inner join, Left join, Right join, Full outer join
Inner join returns only the matching rows from both tables
Left join returns all the rows from the left table and matching rows from the right table
Right join returns all the rows from the right table and matching rows from the left table
Full outer join returns all the rows f...
Test cases are specific inputs and expected outputs for a single functionality, while test scenarios are a collection of test cases that cover a broader functionality.
Test cases are detailed steps to verify a specific functionality
Test scenarios are a collection of test cases that cover a broader functionality
Test cases are usually written by testers
Test scenarios are usually written by business analysts or product own...
Boundary value analysis is a testing technique to identify errors at the boundaries of input values.
For User ID field, test with values just below the minimum limit, at the minimum limit, just above the maximum limit, and at the maximum limit
For Password field, test with values just below the minimum limit, at the minimum limit, just above the maximum limit, and at the maximum limit
Ensure that the system handles these ...
API testing is a type of software testing that involves testing APIs directly and verifying their functionality, reliability, performance, and security.
API testing involves testing the communication between different software systems
It verifies the functionality, reliability, performance, and security of APIs
API testing can be performed using tools like Postman, SoapUI, and JMeter
API testing can be automated using scri
Performance testing is the process of evaluating the speed, responsiveness, stability, and scalability of a software application.
Types of performance testing include load testing, stress testing, endurance testing, and spike testing.
Load testing checks the application's performance under normal and peak loads.
Stress testing evaluates the application's performance under extreme conditions.
Endurance testing checks the ap...
Functional testing checks if the system meets requirements while non-functional testing checks system performance.
Functional testing checks if the system meets requirements while non-functional testing checks system performance.
Functional testing is concerned with what the system does while non-functional testing is concerned with how well the system does it.
Functional testing includes unit testing, integration testing...
Test planning is the process of defining the scope, objectives, and approach for testing a software application.
Identifying the testing objectives
Defining the scope of testing
Determining the testing approach
Creating a test plan document
Assigning roles and responsibilities
Estimating the testing effort
Identifying test deliverables
Defining the test environment
Identifying test data requirements
Approach to handle a blocker defect just before release and convincing the developer to fix it.
Assess the impact of the defect on the release and prioritize it accordingly
Provide clear and concise information about the defect to the developer
Explain the potential risks and consequences of not fixing the defect
Collaborate with the developer to find a solution and provide support if needed
Highlight the importance of meet...
White box testing involves testing the internal structure of the software while black box testing involves testing the functionality without knowledge of the internal structure.
White box testing: unit testing, integration testing, code coverage testing
Black box testing: functional testing, system testing, acceptance testing
White box testing is also known as clear box testing or glass box testing
Black box testing is als...
Top trending discussions
I applied via Campus Placement and was interviewed in Nov 2024. There were 4 interview rounds.
The aptitude test consisted of a combination of three types of subjects: Quantitative, English, and Logical Reasoning. The difficulty level was challenging, and it would be beneficial to review the basics of the CAT exam.
The SUBSTITUTE function in Excel replaces a specific occurrence of a text string with another text string.
Syntax: SUBSTITUTE(text, old_text, new_text, instance_num)
text: The original text string where replacement will occur
old_text: The text string to be replaced
new_text: The text string to replace old_text with
instance_num: Optional parameter to specify which occurrence of old_text to replace
Example: =SUBSTITUTE("appl...
A pivot table in Excel is a data summarization tool that allows you to reorganize and summarize selected columns and rows of data.
Accessed by selecting the data range you want to analyze, then going to the 'Insert' tab and clicking on 'PivotTable'.
Utilized by dragging and dropping fields into the 'Rows', 'Columns', 'Values', and 'Filters' areas to organize and summarize data.
Can be used to quickly analyze large dataset...
Tableau and Power BI are both powerful data visualization tools, with Tableau being more user-friendly and Power BI offering better integration with Microsoft products.
Tableau is known for its user-friendly interface and ease of use for creating visually appealing dashboards.
Power BI offers better integration with Microsoft products such as Excel, SharePoint, and SQL Server.
Tableau is considered superior for its ease o...
To sort the top 10 rows in Excel, select the range of data, go to the Data tab, click on Sort, choose the column to sort by, select Top 10 from the options, and specify whether to sort in ascending or descending order.
Select the range of data containing the top 10 rows you want to sort.
Go to the Data tab in Excel.
Click on the Sort button.
Choose the column you want to sort by.
Select 'Top 10' from the 'Sort On' dropdown ...
Adjusted R-squared is a statistical measure that adjusts the R-squared value for the number of predictors in a regression model.
Adjusted R-squared takes into account the number of predictors in a regression model, providing a more accurate measure of the model's goodness of fit.
It penalizes the addition of unnecessary predictors, helping to prevent overfitting.
A higher adjusted R-squared value indicates a better fit of...
Correlation is a statistical measure that describes the relationship between two variables.
Correlation can range from -1 to 1, with 0 indicating no correlation, 1 indicating a perfect positive correlation, and -1 indicating a perfect negative correlation.
A positive correlation means that as one variable increases, the other variable also tends to increase. For example, there is a positive correlation between studying h...
The five stages of a project are initiation, planning, execution, monitoring and controlling, and closing.
Initiation: Defining the project, its scope, objectives, and stakeholders.
Planning: Creating a detailed project plan, including tasks, timelines, resources, and budget.
Execution: Carrying out the project plan and completing the work.
Monitoring and Controlling: Tracking project progress, managing changes, and ensuri...
Project managers focus on overseeing the execution of a specific project, while product managers are responsible for the overall strategy and development of a product.
Project managers are focused on the successful completion of a project within scope, budget, and time constraints.
Product managers are responsible for the strategic direction, development, and success of a product throughout its lifecycle.
Project managers...
Limitations of food delivery apps that need improvement
Inaccurate delivery times leading to customer dissatisfaction
Limited restaurant options available on the app
Difficulty in customizing orders or making special requests
Issues with order accuracy and missing items
Lack of transparency in pricing and additional fees
Led a team to successfully launch a new software application for a client
Developed project timeline and milestones
Assigned tasks to team members based on their strengths
Held regular team meetings to track progress and address any issues
Collaborated with client to ensure project met their expectations
Conducted thorough testing and quality assurance before final launch
I currently reside in a cozy apartment in downtown Seattle.
My place of domicile is in Seattle, Washington.
I live in a cozy apartment in downtown Seattle.
I have been a resident of Seattle for the past five years.
I come from a close-knit family with my parents and two siblings living in our household.
Close-knit family
Parents and two siblings
Living together in the same household
Family income can be derived from both a business and job holders.
Family income can come from a business owned by a family member.
Family income can also come from salaries earned by family members from their jobs.
In some cases, family income may be a combination of income from both business and job holders.
Examples: A family may own a small business like a bakery and also have family members working in corporate jobs.
A...
I am motivated to work in the insurance industry because of its stability, growth opportunities, and the chance to help individuals and businesses protect themselves financially.
Stability: Insurance is a stable industry that is less affected by economic downturns.
Growth opportunities: There are various career paths and opportunities for advancement within the insurance industry.
Helping others: Working in insurance allo...
Yes, I am willing to relocate to Bengaluru for the Project Manager position.
I am open to relocating for the right opportunity
I have experience working in different locations
I am excited about the prospect of working in Bengaluru
I was interviewed before Feb 2024.
posted on 14 Feb 2025
I was interviewed in Jan 2025.
Seeking new challenges and opportunities for growth.
Desire for new challenges and opportunities for growth
Looking for a company with better work-life balance
Seeking a role with more responsibility and leadership opportunities
WhatsApp is opened multiple times daily in my household for communication and sharing updates.
WhatsApp is opened multiple times daily for communication with family and friends
Used for sharing updates, photos, and videos
Helps in coordinating plans and staying connected with loved ones
I was interviewed in Jan 2025.
Design a clean code structure for API call, DB update, and UI update.
Separate concerns by creating separate classes or modules for API call, DB update, and UI update.
Use interfaces or abstract classes to define contracts for each component.
Implement error handling and data validation at each step.
Consider using asynchronous programming to prevent blocking the UI thread.
Use dependency injection to manage dependencies be
Use a unique identifier for each item in the recycler view and send it to the backend via API calls. Optimize by batching API calls and implementing pagination.
Assign a unique identifier to each item in the recycler view, such as an ID or position
Send the unique identifier of the currently shown item to the backend through API calls
Optimize by batching API calls to reduce network overhead
Implement pagination to load da
I have learned a lot in my journey so far, leading to my decision to switch companies. I have had conflicts with managers in the past.
Learned new technologies and tools in current role
Developed strong problem-solving and communication skills
Decided to switch companies for career growth opportunities
Had conflicts with a manager due to differing opinions on project direction
I was interviewed in Jan 2025.
I was interviewed in Jan 2025.
A case study is a detailed examination of a specific individual, group, event, organization, or phenomenon, allowing researchers to analyze a situation deeply and understand its various elements by gathering information through methods like interviews, observations, and document analysis; the goal is to identify patterns, challenges, and potential solutions within the unique context of the case, often used in fields like social science, medicine, business, and education to explore complex situations and develop practical insights.
"case assignment" refers to the process of assigning a specific case, usually a real-world scenario or problem, to an individual or team to analyze, evaluate, and provide solutions within an academic or professional setting; key details include the case subject, relevant background information, key questions to address, expected deliverables, and deadlines, allowing the assignee to apply theoretical knowledge to practical situations and develop critical thinking
Some of the top questions asked at the Playablo interview -
based on 13 reviews
Rating in categories
Softwaretest Engineer
12
salaries
| ₹3.5 L/yr - ₹6.2 L/yr |
Web Developer
6
salaries
| ₹5 L/yr - ₹6 L/yr |
Software Engineer
5
salaries
| ₹4.7 L/yr - ₹9.8 L/yr |
Product Advisor
5
salaries
| ₹5 L/yr - ₹5.9 L/yr |
Software Testing Engineer
4
salaries
| ₹3.5 L/yr - ₹3.8 L/yr |
TCS
Infosys
Wipro
HCLTech