i
Filter interviews by
I applied via Approached by Company and was interviewed in Apr 2023. There were 3 interview rounds.
24/7 production environment
PL/SQL is a procedural language extension to SQL used for writing complex queries and programs.
SQL is used for querying and manipulating data in a database
PL/SQL is used for writing complex queries and programs
PL/SQL is a procedural language that extends SQL with programming constructs like loops and conditional statements
PL/SQL is used to create stored procedures, functions, and triggers in Oracle databases
Query to find last string from emp table
Use the ORDER BY clause with DESC keyword to sort the table in descending order
Use the LIMIT keyword to limit the result to 1 row
Assuming the last string refers to the last row in the table
Query to find maximum salary from EMP
Use the MAX() function to find the maximum salary
Specify the column name for salary in the SELECT statement
Specify the table name and column name for salary in the FROM clause
Top trending discussions
posted on 24 Sep 2023
I applied via Naukri.com and was interviewed in Aug 2023. There were 2 interview rounds.
HashMap is a data structure that stores key-value pairs and uses hashing to quickly retrieve values based on keys.
HashMap internally uses an array of linked lists to store key-value pairs.
When a key-value pair is added, the key is hashed to determine the index in the array where the pair will be stored.
If multiple key-value pairs hash to the same index, they are stored in a linked list at that index.
To retrieve a value...
HashMap is not thread-safe while ConcurrentHashMap is thread-safe.
HashMap is not thread-safe and can lead to ConcurrentModificationException if modified while iterating.
ConcurrentHashMap allows concurrent modifications without the need for external synchronization.
ConcurrentHashMap achieves thread-safety by dividing the map into segments, allowing multiple threads to operate on different segments concurrently.
Concurren...
No, main method in Java cannot be overridden.
Main method is a static method of a class and cannot be overridden.
Subclasses can have their own main method, but it will not be considered as the entry point of the program.
Example: public class SubClass extends MainClass { public static void main(String[] args) { // This is not the entry point of the program }}
Use the 'ls' command with the '-a' flag to find hidden files in Unix.
Use the command 'ls -a' to list all files, including hidden files.
Hidden files in Unix start with a dot (.) before the file name.
Example: 'ls -a' will display all files, including hidden files.
Use the sed command to replace a string in Unix
Use the following syntax: sed 's/original_string/new_string/g' filename
The 's' flag stands for substitute, 'g' flag stands for global (replace all occurrences)
Example: sed 's/hello/goodbye/g' file.txt
posted on 17 Dec 2024
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
Developed a web-based inventory management system for a retail company
Utilized Java for backend development
Implemented responsive design using HTML, CSS, and JavaScript
Integrated barcode scanning functionality for efficient inventory tracking
I was responsible for providing technical support to end users and troubleshooting application issues within the team.
Providing technical support to end users
Troubleshooting application issues
Collaborating with team members to resolve issues
Documenting solutions and best practices
I applied via Naukri.com
It is a computer base test and we have numerical, verbal and logical reasoning question will be their
Discussion between a group of participants on a given topic
I applied via Referral and was interviewed in Jun 2024. There were 2 interview rounds.
1 hour, wage question, not related to mention technology.
posted on 22 Aug 2024
sed command is a stream editor used to perform text transformations on an input stream or file.
sed stands for stream editor
It is used to perform text transformations on an input stream or file
Commonly used for search and replace operations
Syntax: sed 's/search/replace/g' filename
Example: sed 's/foo/bar/g' file.txt
I applied via Walk-in
posted on 15 May 2024
I applied via Recruitment Consulltant and was interviewed in Nov 2023. There was 1 interview round.
posted on 22 Aug 2022
I will handle team conflicts by promoting open communication, facilitating discussions, and finding mutually agreeable solutions.
Encourage open communication among team members
Facilitate discussions to understand the root cause of conflicts
Promote active listening and empathy
Mediate conflicts and find mutually agreeable solutions
Implement team-building activities to improve collaboration
I would approach the issue by communicating with all relevant teams and creating a plan to recover the lost data.
Identify the cause of the data loss
Notify all relevant teams and stakeholders
Create a plan to recover the lost data
Implement the plan and monitor progress
Communicate updates to all stakeholders
As a Production Support Manager, my responsibilities included overseeing the support and maintenance of production systems, managing a team of support analysts, coordinating with stakeholders, and ensuring timely resolution of issues.
Managed a team of support analysts and provided guidance and support
Oversaw the support and maintenance of production systems
Coordinated with stakeholders to understand their requirements ...
Yes, I am flexible for working hours.
I am willing to work evenings, weekends, and holidays if required.
I understand the importance of being available during critical production issues.
I am open to adjusting my schedule to accommodate team needs.
I have experience working in shifts and adapting to changing work hours.
I prioritize the success of the team and the smooth operation of production systems.
I can join immediately.
I am available to start immediately.
I can join as soon as required.
I am ready to start right away.
As a Production Support Manager, I handle major issues by identifying root causes, coordinating with teams, and implementing effective solutions.
Identify root causes of major issues
Coordinate with teams to resolve issues
Implement effective solutions to prevent future occurrences
I applied via Company Website and was interviewed in Jan 2023. There were 2 interview rounds.
A support engineer is responsible for providing technical assistance and resolving issues related to software or hardware systems.
Providing technical support to customers or end-users
Troubleshooting and resolving software or hardware issues
Installing, configuring, and maintaining systems
Monitoring system performance and identifying potential problems
Collaborating with development teams to address bugs or enhancements
Do...
A ticketing tool is a software application used to track and manage customer support requests or issues.
Ticketing tools help in organizing and prioritizing customer support tickets.
They provide a centralized platform for communication and collaboration between support teams and customers.
Ticketing tools often include features like ticket assignment, status tracking, and reporting.
Examples of popular ticketing tools inc
A monitoring tool is a software application or system that collects and analyzes data to track the performance and health of a system or application.
Monitoring tools collect data from various sources such as servers, networks, databases, and applications.
They provide real-time visibility into the system's performance, availability, and resource utilization.
Monitoring tools can generate alerts or notifications when pred...
SQL comments are used to add explanatory notes or remarks within SQL code.
SQL comments start with a double hyphen (--), or can be enclosed between /* and */
Comments are ignored by the SQL engine and are not executed as part of the code
Comments can be used to improve code readability and provide documentation
Comments can be used to disable or temporarily remove parts of the code for testing or debugging purposes
DML stands for Data Manipulation Language.
DML is a subset of SQL (Structured Query Language) used to manipulate data in a database.
It includes commands like INSERT, UPDATE, DELETE, and SELECT.
DML statements are used to add, modify, or delete data in database tables.
For example, INSERT statement is used to add new records, UPDATE statement is used to modify existing records, DELETE statement is used to remove records, a...
Some of the top questions asked at the Societe Generale Global Solution Centre Production Support Analyst interview -
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Senior Analyst
1.8k
salaries
| ₹4.7 L/yr - ₹15 L/yr |
Software Engineering Specialist
1.7k
salaries
| ₹8.9 L/yr - ₹33 L/yr |
Analyst
1.6k
salaries
| ₹2.8 L/yr - ₹11 L/yr |
Software Engineer
1.4k
salaries
| ₹5 L/yr - ₹19.6 L/yr |
Business Analyst
1.1k
salaries
| ₹6 L/yr - ₹26 L/yr |
BNP Paribas
Crédit Agricole
HSBC Group
Barclays