10+ Sberbank Branch in India Interview Questions and Answers

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 query params are used for optional parameters

• Path params are...read more

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

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.

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 = 'value'

• Example: SELECT column_name, COUNT(*) FROM table...read more

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

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 whether the issue should be classified as a bug or an enhance...read more

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

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, designers, and other team members in prioritization process.

• Us...read more

I would prefer parallel electrical circuitry for my house.

• Parallel circuitry allows for individual appliances to operate independently without affecting others

• Parallel circuits are safer as if one appliance fails, others will continue to work

• Parallel circuits are easier to troubleshoot and repair compared to series circuits

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