Societe Generale Global Solution Centre Business Analyst Interview Questions and Answers

Q1. How many joins are in SQL?
Ans. 
The number of joins in SQL can vary depending on the complexity of the query.
• The number of joins in SQL can range from 0 (no joins) to multiple joins in a single query.

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• Joins are used to combine rows from two or more tables based on a related column between them.

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id;
Answered by AI
Add your answer
Q2. Explain about difference left and inner join? And scenarios questions
Add your answer

It was actually easy.

Q1. It was mostly SQL questions.
Add your answer

Q1. This round was more of a personal level and to check the confidence of the candidate.
Add your answer

Q1. Calculation of Bonds
Ans. 
Calculation of bonds involves determining the present value of future cash flows.
• Calculate the present value of the bond's future cash flows using the bond's coupon rate, face value, and yield to maturity.

• Discount each cash flow back to present value using the yield to maturity.

• Sum up all the present values to get the bond's price.

• Consider factors such as coupon frequency and time to maturity in the calculation.
Answered by AI
Add your answer

Q1. Why societe Generale
Add your answer

Q1. Basic Hr Questions about previous experience,salary and location.
Add your answer

Q1. Technical Question Topics Asset Liability Management SLS, IRS,LCR,Basel Guideline,Derivatives,Netting Agreement, Bond Market,VAR, Stress Testing etc.
Add your answer

Q1. Managerial Round Basic Behavioral and Little bit technical as per Business Line.Introduction about job role and responsibilities
Add your answer