Indiafilings Product Advisor Interview Questions and Answers

Q1. I was a referred candidate
Add your answer

Q1. Good,.....,.......,,,..
Add your answer

Q1. 1.writing a complex query in sql?
Ans. 
A complex SQL query involves multiple tables, joins, subqueries, and functions to retrieve specific data.
• Identify the tables and columns needed for the query

• Use JOIN statements to combine data from multiple tables

• Use subqueries to retrieve data from a subset of the main query

• Use aggregate functions like COUNT, SUM, AVG, etc. to perform calculations on data

• Use GROUP BY to group data based on a specific column

• Use HAVING ...read more
Answered by AI
Add your answer
Q2. Program for a target number by sum of n numbers
Ans. 
Program to find n numbers that sum up to a target number.
• Take input of target number and n

• Use a loop to take input of n numbers

• Check if sum of n numbers is equal to target number

• If yes, print the n numbers

• If no, try again with different n numbers
Answered by AI
Add your answer

Q1. Candidate should be clear enough to explain current role in details
Add your answer

Q1. Regarding to past experience
View 3 more answers

Q1. Related to past experience and few technical questions
Add your answer

Q1. Previous experience and Some technical questions
Add your answer

Cleared group discussion without interrupting

Q1. What do u know about corporate action.
Ans. 
Corporate action refers to any event initiated by a publicly-traded company that affects its stakeholders.
• Corporate actions can be voluntary or mandatory

• Examples of corporate actions include stock splits, dividends, mergers and acquisitions, and spin-offs

• Corporate actions can have a significant impact on the company's stock price and overall value

• Investors need to stay informed about corporate actions to make informed
Answered by AI
View 1 more answer
Q2. What are the type of corporate action
Ans. 
Corporate actions are events initiated by a company that can affect the stock price and shareholder value.
• Dividends

• Stock splits

• Mergers and acquisitions

• Spin-offs

• Rights issues

• Bonus issues

• Share buybacks

• Name changes

• Delistings
Answered by AI
View 1 more answer
Q3. Are u willing work in any shifts
Add your answer
Q4. Yes if it is in the boundary area determined by company then it's ok for me to work
Add your answer
Q5. What is work experience overall and any reason to leave the organisation?
Add your answer
Q6. Yes there was a reason behind it. I had served 14 years in last organization but the why it was treated to me was not exceptable. Mangement was not that supportive and it was Jp morgan
Add your answer

Q1. Do u know to work on pivot and build macros
Ans. 
Yes, I am proficient in working with pivot tables and building macros.
• I have experience in creating pivot tables to analyze large data sets and extract meaningful insights.

• I am skilled in using macros to automate repetitive tasks and improve efficiency.

• I have worked with various functions and formulas in Excel to manipulate data and create custom reports.

• I am familiar with VBA programming and can write code to enhance ...read more
Answered by AI
Add your answer
Q2. Yes indeed i do know both pivot and macros apart i have learnt paython
Add your answer

Q1. What are u expecting in terms of salary
Add your answer
Q2. Any thing which suits as per Market.
Add your answer

Q1. What is coupons
Ans. 
Coupons are discounts or special offers provided by retailers to customers to encourage purchases.
• Coupons can be in the form of physical paper vouchers or digital codes

• They typically offer a discount on a specific product or a percentage off the total purchase

• Some coupons have restrictions such as expiration dates or minimum purchase requirements
Answered by AI
Add your answer
Q2. What is fixed income
Ans. 
Fixed income refers to investments that pay a fixed interest or dividend income, such as bonds or certificates of deposit.
• Fixed income investments provide a predictable stream of income to investors.

• Examples include government bonds, corporate bonds, municipal bonds, and preferred stocks.

• Fixed income securities are generally considered lower risk compared to equities.
Answered by AI
Add your answer