Societe Generale Global Solution Centre Interview Questions, Process, and Tips for Freshers

Coding test was easy, there were 2 questions.

Q1. Square root of a number in log n time
Ans. 
Using binary search, square root of a number can be found in log n time.
• Choose a range for the square root

• Use binary search to find the square root within the range

• Adjust the range based on whether the guess is too high or too low
Answered by AI
Add your answer

Q1. Basic questions on leadership and some problem based.
Add your answer
Q2. Basics questions
Add your answer

Q1. Difference between truncate, Drop and delete
Ans. 
Truncate, Drop, and Delete are SQL commands for managing data, differing in scope and impact on database structure.
• TRUNCATE: Removes all rows from a table but retains the structure. Example: 'TRUNCATE TABLE employees;'

• DROP: Deletes the entire table and its structure from the database. Example: 'DROP TABLE employees;'

• DELETE: Removes specific rows based on a condition but keeps the table structure. Example: 'DELETE FROM
Answered by AI
Add your answer
Q2. What is RDMS ?
Ans. 
RDBMS stands for Relational Database Management System, a software for managing relational databases.
• Data is stored in tables, which consist of rows and columns.

• Supports SQL (Structured Query Language) for querying and managing data.

• Ensures data integrity and supports ACID properties (Atomicity, Consistency, Isolation, Durability).

• Examples include MySQL, PostgreSQL, Oracle Database, and Microsoft SQL Server.

• Allows rela
Answered by AI
Add your answer

Q1. Explain Trade Life Cycle
Ans. 
Trade Life Cycle is the process of a trade from initiation to settlement.
• Trade initiation

• Order routing

• Execution

• Confirmation

• Clearing and settlement

• Trade reporting
Answered by AI
View 1 more answer
Q2. Explain Clean price and Dirty price
Ans. 
Clean price is the price of a bond excluding accrued interest, while dirty price includes accrued interest.
• Clean price is the price of a bond without any accrued interest

• Dirty price is the price of a bond including accrued interest

• Accrued interest is the interest that has accumulated on a bond since its last coupon payment

• Clean price + accrued interest = dirty price

• Dirty price is also known as the full or invoice price
Answered by AI
Add your answer
Q3. Explain Fixed Income Securities.
Ans. 
Fixed income securities are debt instruments that pay a fixed interest rate over a specific period of time.
• Fixed income securities are also known as bonds.

• They are issued by governments, corporations, and other entities to raise capital.

• Investors receive regular interest payments until the bond matures, at which point they receive the principal amount.

• The interest rate on fixed income securities is determined by the cr...read more
Answered by AI
Add your answer
Q4. Role of Investment Bank
Ans. 
Investment banks help companies and governments raise capital by underwriting and selling securities.
• Assist in mergers and acquisitions

• Provide financial advisory services

• Underwrite and sell securities

• Help clients raise capital

• Facilitate trading of securities

• Examples: Goldman Sachs, JPMorgan Chase, Morgan Stanley
Answered by AI
Add your answer
Q5. Different functions of Investment Bank.
Ans. 
Investment banks perform various functions such as underwriting, M&A advisory, sales and trading, research, and asset management.
• Underwriting: helping companies issue securities and managing the process of selling them to investors

• M&A advisory: advising companies on mergers and acquisitions

• Sales and trading: buying and selling securities on behalf of clients

• Research: providing analysis and recommendations on companies ...read more
Answered by AI
Add your answer

Q1. Performance Tunings Joins
Add your answer
Q2. SSIS Bufferr and memories related queries Parallel processing in SSIS Power BI reporting life cycle DAX questions on power BI
Add your answer

Q1. Role of CPU AND Cores in Performance Improvement Sharding concepts TABLE PARTITION DATA WAREHOUSE
Add your answer

Q1. Role based questions
Add your answer