Sberbank Branch in India Interview Questions and Answers

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?
Ans. 
Five bugs on a sample test application's login page
• Incorrect error message displayed for invalid credentials

• Password field allows special characters when it shouldn't

• Forgot password link leads to a broken page

• Login button does not respond when clicked

• Successful login does not redirect to the correct page
Answered by AI
Add your answer

Q1. What process improvements did you implement as a Senior Software QA Engineer in your previous two organizations?
Ans. 
Implemented process improvements in previous roles as Senior Software QA Engineer.
• Introduced automated testing to increase efficiency and accuracy of testing processes.

• Implemented a standardized bug tracking system to streamline communication and resolution of issues.

• Established regular code review sessions to catch potential issues early in the development cycle.

• Introduced performance testing to identify and address b...read more
Answered by AI
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.
Ans. 
Prioritize bugs based on severity, impact on users, and functionality importance.
• Prioritize bugs based on severity - fix critical bugs that cause crashes or data loss first.

• Consider impact on users - fix bugs that affect a large number of users or key functionality.

• Importance of functionality - prioritize bugs that impact core features or key user workflows.

• Collaborate with stakeholders - involve product managers, desi...read more
Answered by AI
Add your answer
Q3. How would you approach a situation where a developer rejects a bug report, categorizing it as an enhancement?
Ans. 
Discuss with the developer to understand their reasoning and provide additional information to support the bug classification.
• Initiate a discussion with the developer to understand their perspective on why the bug is considered an enhancement.

• Provide additional information such as user impact, expected behavior, and screenshots to support the bug classification.

• Collaborate with the developer to reach a consensus on whe...read more
Answered by AI
Add your answer
Q4. How would you handle a situation where you do not have sufficient time to address all the test scenarios?
Ans. 
Prioritize test scenarios based on criticality and impact, communicate with stakeholders, and focus on high-risk areas.
• Prioritize test scenarios based on criticality and impact

• Communicate with stakeholders to set expectations and discuss potential risks

• Focus on high-risk areas first to ensure essential functionality is tested
Answered by AI
Add your answer

Q1. Questions around RAG LLM application evaluation, optimisation and deployment techniques
Add your answer
Q2. LLM fine tuning techniques, project discussion, familiarity with open source LLMs and some questions around NLP and evaluation metrices
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