Societe Generale Global Solution Centre Interview Questions and Answers

Using SQL joins to find the nth highest value in a table

• Use a combination of SQL joins and subqueries to find the nth highest value in a table

• For example, you can use a query like SELECT DISTINCT column_name FROM table_name ORDER BY column_name DESC LIMIT n-1,1

Credit card companies make money through interest charges, fees, and interchange fees.

• Interest charges on balances carried over from month to month

• Annual fees charged to cardholders for the privilege of using the card

• Late payment fees for missed payments

• Interchange fees charged to merchants for processing transactions

• Foreign transaction fees for purchases made in a foreign currency

Use Python to find the most frequent word in a string

• Split the string into words using split() method

• Create a dictionary to store word frequencies

• Iterate through the words and update the dictionary

• Find the word with the highest frequency using max() method

Reverse a string using recursion

• Create a recursive function that takes a string as input

• Base case: if the string is empty, return an empty string

• Recursive case: return the last character of the string concatenated with the result of calling the function on the substring excluding the last character

I will increase sales growth by implementing targeted marketing strategies and building strong relationships with clients.

• Conduct market research to identify potential clients and their needs

• Develop personalized marketing campaigns to target specific client segments

• Build strong relationships with clients through regular communication and exceptional service

• Identify cross-selling and upselling opportunities to increase revenue

• Collaborate with other departments to ensure seamle...read more

Guesstimates involve making educated guesses or estimates based on available information.

• Understand the problem and the variables involved

• Break down the problem into smaller parts if necessary

• Use logical reasoning and available data to make estimates

• Provide a range of estimates rather than a single number

• Consider different scenarios and their impact on the estimate