i
Filter interviews by
The output of each join between Table 1 and Table 2 with values 1,1,1 and 1,1,0 respectively.
Inner join: Output will be 1,1,1 as it only includes matching values from both tables.
Left join: Output will be 1,1,1 from Table 1 as it includes all values from Table 1 and matching values from Table 2.
Right join: Output will be 1,1,0 from Table 2 as it includes all values from Table 2 and matching values from Table 1.
Full out...
To find duplicates without using count(*), use self-join and group by clause.
Use self-join to join the table with itself on the column that contains the duplicates.
Use group by clause to group the results by the column that contains duplicates.
Select the columns you want to display along with the count of duplicates.
I applied via Approached by Company and was interviewed in Dec 2021. There was 1 interview round.
Risk based testing is a method of prioritizing testing efforts based on the likelihood and impact of potential failures.
Identify potential risks and their impact on the system
Prioritize testing efforts based on the identified risks
Allocate testing resources accordingly
Continuously monitor and reassess risks throughout the testing process
Examples: testing critical functionalities first, testing for security vulnerabilit
Top trending discussions
Types of testing include functional testing, non-functional testing, manual testing, automated testing, regression testing, and performance testing.
Functional testing: Testing the functionality of the software against the requirements.
Non-functional testing: Testing aspects like performance, usability, and security.
Manual testing: Testing performed manually by testers.
Automated testing: Testing performed using automate...
I applied via LinkedIn and was interviewed before Aug 2020. There were 4 interview rounds.
posted on 6 Nov 2019
I applied via Referral and was interviewed in May 2019. There were 3 interview rounds.
I applied via Referral and was interviewed before Sep 2019. There were 3 interview rounds.
I approach dynamic objects by analyzing their behavior and adapting my approach accordingly.
I start by understanding the nature of the dynamic object and its expected behavior
I then analyze its movement patterns and any potential obstacles or hazards
Based on this analysis, I adapt my approach to ensure safe and efficient interaction with the dynamic object
For example, when working with a moving conveyor belt, I would e...
Implicit and explicit wait are two types of wait in Selenium used to synchronize the test execution with the application.
Implicit wait is used to set a default waiting time for the web elements to load before throwing an exception.
Explicit wait is used to wait for a specific condition to occur before proceeding with the test execution.
Implicit wait is set globally for the entire test script while explicit wait is set f...
posted on 29 Nov 2022
I applied via Naukri.com and was interviewed before Nov 2021. There were 3 interview rounds.
I applied via Company Website and was interviewed in Oct 2019. There were 3 interview rounds.
I applied via Referral and was interviewed before Nov 2020. There was 1 interview round.
Collateral management is the process of managing and monitoring collateral pledged to secure a loan or other financial obligation.
Collateral can include assets such as real estate, stocks, bonds, and commodities.
The purpose of collateral management is to mitigate credit risk and ensure that the lender has sufficient collateral to cover any potential losses.
Collateral management involves tracking the value of the collat...
Haircut for collaterals refers to the reduction in value of the collateral pledged by a borrower to secure a loan.
Haircut is the percentage reduction in the value of the collateral that a lender applies to account for market fluctuations and potential losses.
It is used to determine the amount of loan that can be extended against the collateral.
For example, if a borrower pledges a property worth $100,000 as collateral a...
based on 1 interview
Interview experience
based on 6 reviews
Rating in categories
Senior Analyst
262
salaries
| ₹8.1 L/yr - ₹30.3 L/yr |
Senior Software Engineer
248
salaries
| ₹15 L/yr - ₹50.1 L/yr |
Senior Associate
241
salaries
| ₹5.8 L/yr - ₹12.4 L/yr |
Software Engineer
205
salaries
| ₹12 L/yr - ₹35.6 L/yr |
Analyst
204
salaries
| ₹4.8 L/yr - ₹20 L/yr |
Wells Fargo
JPMorgan Chase & Co.
HSBC Group
Citicorp