Sberbank Branch in India Interview Questions, Process, and Tips

The coding test comprised 10 multiple-choice questions covering topics such as Testing Techniques including Equivalence Partitioning, Boundary Value Analysis, Decision Tables, State Transition, and SQL.

Q1. Given two tables, subscribers and subscriptions, how can one find the users who have active subscriptions between a specified start date and end date?
Add your answer
Q2. What are at least five bugs that you can identify on a sample test application's login page?
Add your answer

Q1. What process improvements did you implement as a Senior Software QA Engineer in your previous two organizations?
Add your answer
Q2. There are 10 bugs but not enough time to fix all of them before release. How would you help the developer choose what to fix.
Add your answer
Q3. How would you approach a situation where a developer rejects a bug report, categorizing it as an enhancement?
Add your answer
Q4. How would you handle a situation where you do not have sufficient time to address all the test scenarios?
Add your answer

Q1. Can we use POST method instead of get method
Ans. 
Yes, POST method should be used for sending sensitive data or when data length exceeds URL limit.
• POST method should be used when sending sensitive data like passwords or personal information.

• POST method should be used when the data length exceeds the URL limit, as GET has a limit on the amount of data that can be sent.

• GET method should be used for retrieving data from the server without changing anything on the server.
Answered by AI
Add your answer
Q2. Difference between where and having clauses in sql
Ans. 
Where clause is used to filter rows before grouping, while having clause is used to filter groups after grouping.
• Where clause is used with SELECT, UPDATE, DELETE statements to filter rows based on a condition

• Having clause is used with GROUP BY statement to filter groups based on a condition

• Where clause is applied before grouping, having clause is applied after grouping

• Example: SELECT * FROM table_name WHERE column_name...read more
Answered by AI
Add your answer
Q3. What are the aggregate functions in SQL
Ans. 
Aggregate functions in SQL are used to perform calculations on a set of values and return a single value.
• Aggregate functions include functions like SUM, AVG, COUNT, MIN, and MAX.

• SUM - calculates the sum of values in a column

• AVG - calculates the average of values in a column

• COUNT - counts the number of rows in a result set

• MIN - finds the minimum value in a column

• MAX - finds the maximum value in a column
Answered by AI
Add your answer
Q4. What is the difference between path params and query params
Ans. 
Path params are part of the URL path, while query params are appended to the URL after a '?'
• Path params are used to identify a specific resource in the URL path, while query params are used to filter or sort the resources

• Path params are defined in the URL path itself, such as /users/{id}, while query params are appended to the URL, such as /users?sort=asc

• Path params are typically used for mandatory parameters, while qu...read more
Answered by AI
Add your answer
Q5. Write a SQL query on inner join (given with a table and data)
Ans. 
SQL query using inner join to retrieve data from two tables
• Use INNER JOIN to combine rows from two tables based on a related column

• Specify the columns to select from each table

• Add a condition to match the related columns in the ON clause
Answered by AI
Add your answer
Q6. Application module to find bugs
Ans. 
One way to find bugs in an application module is through thorough testing and using debugging tools.
• Conduct thorough testing of the application module to identify bugs

• Use debugging tools like breakpoints, logging, and profiling to pinpoint and fix bugs

• Implement automated testing to catch bugs early in the development process
Answered by AI
Add your answer

Q1. Rest Api testing
Add your answer

Q1. Roles and responsibilities
Add your answer

Q1. What is your expectations
Ans. 
My expectation is to lead a successful project delivery by effectively managing resources, timelines, and stakeholder expectations.
• Clear communication with team members and stakeholders

• Setting realistic goals and timelines

• Proactively identifying and addressing risks

• Ensuring quality deliverables within budget constraints
Answered by AI
Add your answer
Q2. What will you bring with yourself
Ans. 
I will bring strong project management skills, leadership experience, and a track record of successful project delivery.
• Extensive experience in project management

• Proven track record of successful project delivery

• Strong leadership skills

• Ability to effectively communicate with stakeholders

• Experience in managing cross-functional teams
Answered by AI
Add your answer