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 was interviewed in Nov 2024.
I applied via Naukri.com
More about testing process and need to write C# string program
Commonwealth Bank of Australia, India interview questions for popular designations
Get interview-ready with Top Commonwealth Bank of Australia, India Interview Questions
Data warehousing is the process of collecting, storing, and managing data from various sources for analysis and reporting.
Data warehousing involves extracting data from multiple sources and consolidating it into a central repository.
It is used for analytical reporting, business intelligence, and decision-making purposes.
Data warehouses are designed for query and analysis rather than transaction processing.
Examples of d...
Script in Python to print 'Hello, World!'
Use the print() function in Python to display the text 'Hello, World!'
Ensure the text is enclosed in single or double quotes
I applied via Approached by Company and was interviewed in Apr 2024. There was 1 interview round.
It was easy. Just basic Math and DI
Analyzing liquidity involves assessing a company's ability to meet short-term financial obligations.
Calculate current ratio (current assets / current liabilities)
Assess quick ratio (liquid assets / current liabilities)
Examine cash flow from operations to see if it covers short-term obligations
Review working capital to determine if there are enough current assets to cover current liabilities
LTV stands for Loan-to-Value ratio. Analyzing a home loan application involves assessing the borrower's creditworthiness and the property's value.
LTV is calculated by dividing the loan amount by the appraised value of the property.
A lower LTV ratio indicates a lower risk for the lender.
Analyzing a home loan application involves reviewing the borrower's credit score, income, debt-to-income ratio, employment history, and...
Top trending discussions
Interview experience
based on 507 reviews
Rating in categories
Senior Analyst
250
salaries
| ₹8.2 L/yr - ₹30 L/yr |
Senior Associate
219
salaries
| ₹5.8 L/yr - ₹12 L/yr |
Senior Software Engineer
202
salaries
| ₹15 L/yr - ₹50.1 L/yr |
Analyst
191
salaries
| ₹5 L/yr - ₹20 L/yr |
Software Engineer
180
salaries
| ₹11.1 L/yr - ₹35.6 L/yr |
HDFC Bank
ICICI Bank
State Bank of India
Axis Bank