What are the types of joins in database in detail. Example of adhoc testing. Test Cases of Red bus ticket booking screen. API response through PUT method . How to find duplicate records . Question on Nested joins .

Question

Accepted Answer

The interview question covers various topics related to database testing and quality analysis.

Types of joins in database include inner join, left join, right join, and full outer join.
Adhoc testing involves testing without any predefined test cases.
Test cases for Red bus ticket booking screen can include verifying the availability of seats, checking the payment gateway, and ensuring the booking confirmation message is displayed.
API response through PUT method involves updating data on the server using the HTTP PUT request.
Duplicate records can be found using SQL queries with the GROUP BY and HAVING clauses.
Nested joins involve joining multiple tables in a query using multiple join conditions.

What are the types of joins in database in detail. Example of adhoc testing. Test Cases of Red bus ticket booking screen. API response through PUT method . How to find duplicate records . Question on Nested joins .

Popular interview questions of Quality Analyst

Top HR questions asked in BirchStreet Systems Quality Analyst