Filter interviews by
I applied via Approached by Company and was interviewed before Dec 2023. There were 2 interview rounds.
Use SQL query to find duplicate records in a database table
Use GROUP BY clause with COUNT() function to identify duplicate records
Join the table with itself on the columns that need to be checked for duplicates
Filter the results to show only records with count greater than 1
To create a new table from an existing table, you can use the CREATE TABLE AS SELECT statement in SQL.
Use the CREATE TABLE AS SELECT statement in SQL to create a new table based on the structure and data of an existing table.
Specify the columns you want to include in the new table and the source table from which to select the data.
You can also add conditions or filters to the SELECT statement to customize the data bein
Top trending discussions
I applied via Naukri.com and was interviewed in Dec 2020. There were 5 interview rounds.
I applied via Referral and was interviewed before Feb 2023. There was 1 interview round.
NAV calculation capital of call distribution notice
NAV (Net Asset Value) calculation involves determining the value of a fund's assets minus its liabilities
Capital call is a request for additional funds from investors in a private equity fund
Distribution notice is a document sent to investors detailing the distribution of profits or income from an investment
To write reverse list
I applied via Referral and was interviewed before Sep 2022. There were 3 interview rounds.
IRR, NPV, and NAV are financial metrics used to evaluate the profitability and value of investments.
IRR (Internal Rate of Return) is the discount rate that makes the net present value of all cash flows from a particular investment equal to zero.
NPV (Net Present Value) is the difference between the present value of cash inflows and outflows of an investment.
NAV (Net Asset Value) is the value of a fund's assets minus its...
Mutual funds pool money from multiple investors to invest in a diversified portfolio of securities. Hedge funds are actively managed investment funds that use a variety of strategies to achieve high returns. Private equity involves investing in privately held companies or buying out public companies to take them private.
Mutual funds pool money from multiple investors to invest in a diversified portfolio of securities.
H...
Analysis of financial statements involves reviewing and interpreting a company's financial data to assess its performance and make informed decisions.
Review income statement, balance sheet, and cash flow statement to understand financial health
Calculate key financial ratios like profitability, liquidity, and solvency ratios
Compare current financial data with historical data and industry benchmarks
Identify trends, stren...
Limited partners are passive investors with limited liability, while general partners are actively involved in managing the business with unlimited liability.
Limited partners have limited liability and are not involved in the day-to-day operations of the business.
General partners have unlimited liability and are actively involved in managing the business.
Limited partners typically contribute capital to the business but...
I appeared for an interview before Mar 2024.
Technical Discussion
Technical Discussion with Coding Test
I worked as a project manager at a consulting firm, leading teams to deliver strategic solutions for clients across various industries.
Managed a team of 10 consultants to deliver a market entry strategy for a tech startup.
Conducted data analysis to identify key trends, resulting in a 20% increase in client revenue.
Facilitated workshops with clients to align project goals and expectations, enhancing client satisfaction.
...
I applied via Naukri.com and was interviewed before Oct 2022. There were 4 interview rounds.
They asked basic java programs
Adding 2 no by using strams.
based on 1 interview
Interview experience
based on 11 reviews
Rating in categories
Software Engineer
101
salaries
| ₹3 L/yr - ₹11.8 L/yr |
Technical Specialist
71
salaries
| ₹6 L/yr - ₹15.5 L/yr |
Technical Analyst
64
salaries
| ₹9 L/yr - ₹17 L/yr |
Senior Technical Analyst
62
salaries
| ₹11.5 L/yr - ₹19.5 L/yr |
Senior Software Engineer
62
salaries
| ₹4.8 L/yr - ₹18 L/yr |
ITC Infotech
CMS IT Services
KocharTech
Xoriant