Playablo Interview Questions and Answers

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

Q1. SQL trigger details Deadlock handle Cost of query Some managerial questions
Add your answer

Q1. Discuss about salary and my documents
Add your answer

Q1. Explain SDLC & types of SDLC models.
Ans. 
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...read more
Answered by AI
View 1 more answer
Q2. Explain defect life cycle.
Ans. 
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
Answered by AI
Add your answer
Q3. Explain STLC in detail.
Ans. 
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...read more
Answered by AI
Add your answer
Q4. Write Sql query for displaying total number of students from child details table where child names starting with 'A'.
Ans. 
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'.
Answered by AI
View 1 more answer
Q5. Explain joins & its types with an example each.
Ans. 
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...read more
Answered by AI
Add your answer
Q6. Difference between testcases & test scenarios.
Ans. 
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...read more
Answered by AI
Add your answer
Q7. What is boundary value analysis? How do u perform boundary value testing for User ID & Password textfields in login page?
Ans. 
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 ...read more
Answered by AI
View 1 more answer
Q8. What is API testing? Do u know how to perform Api testing in postman tool?
Ans. 
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...read more
Answered by AI
Add your answer
Q9. What is performance testing & explain its types? & Do u know Apache Jmeter?
Ans. 
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...read more
Answered by AI
Add your answer
Q10. Differentiate between functional & non- functional testing.
Ans. 
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...read more
Answered by AI
Add your answer
Q11. What is test planning?
Ans. 
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
Answered by AI
Add your answer
Q12. If u get a blocker defect just the previous day of ur release date. What will be ur approach? How will u convince the developer to fix this defect?
Ans. 
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...read more
Answered by AI
Add your answer
Q13. Types of White box testing & black box testing.
Ans. 
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...read more
Answered by AI
Add your answer

Q1. Some behavioural questions.
Add your answer

Q1. Just self introduction & salary discussion.
Add your answer