20+ Garden Reach Shipbuilders & Engineers Interview Questions and Answers

SQL query to retrieve name of employee with salary greater than department average.

• Calculate average salary of department using GROUP BY clause

• Join employee and department tables using department ID

• Filter employees with salary greater than department average

• Select employee name

I would investigate the root cause of the issue and work with the customer to find a satisfactory solution.

• Listen to the customer's complaints and concerns

• Apologize for any inconvenience caused

• Investigate the issue to identify the root cause

• Work with the customer to find a satisfactory solution

• Follow up with the customer to ensure their satisfaction

I would address the employees' concerns and provide training and support to ensure successful adoption of the new tool.

• Listen to employees' concerns and address them

• Provide training and support to ensure successful adoption

• Communicate the benefits of the new tool

• Encourage feedback and suggestions for improvement

• Lead by example and use the tool yourself

• Offer incentives for using the tool

• Monitor usage and provide ongoing support

• Collaborate with IT to address any technical issue...read more

CTEs are used in SQL to create temporary result sets that can be referenced within a query.

• CTEs improve readability and maintainability of complex queries

• They can be recursively referenced to solve hierarchical problems

• CTEs can be used to simplify queries by breaking them into smaller, more manageable parts

Implement LRU cache with expiration, priority, and recentness based eviction policy.

• Use a doubly linked list to keep track of the order of elements based on recentness.

• Use a hashmap to store key-value pairs for quick access.

• Implement a priority queue to handle eviction based on priority.

• Set expiration time for each element and remove expired elements during access or eviction.

Attention is important in petrol pumps to prevent accidents, ensure correct fueling, and provide good customer service.

• Prevent accidents by avoiding spills and fires

• Ensure correct fueling to prevent damage to vehicles and ensure customer satisfaction

• Provide good customer service by assisting customers with fueling and answering any questions

• Maintain cleanliness and organization to create a safe and efficient environment

Implement a Smoke Collector problem

• Create a class SmokeCollector with methods to collect smoke data

• Implement a method to start collecting smoke data

• Design a method to analyze and store the collected smoke data

A typical Business Requirements Document (BRD) includes project scope, objectives, stakeholders, functional requirements, non-functional requirements, assumptions, constraints, and acceptance criteria.

• Project scope - defines the boundaries of the project

• Objectives - goals to be achieved by the project

• Stakeholders - individuals or groups affected by the project

• Functional requirements - specific features and functions of the system

• Non-functional requirements - performance, secu...read more

Implement k-Vendor problem

• Create a function that takes in an array of strings and an integer k

• Return the kth most frequent string in the array

• Use a hashmap to store the frequency of each string

End to end project phases involve initiation, planning, execution, monitoring and controlling, and closure.

• Initiation: Define project scope, objectives, and stakeholders.

• Planning: Develop project plan, schedule, and budget.

• Execution: Implement project plan and deliver the desired outcomes.

• Monitoring and Controlling: Track progress, identify issues, and make necessary adjustments.

• Closure: Formalize project completion, hand over deliverables, and evaluate project success.

Scrum events include Sprint Planning, Daily Standup, Sprint Review, Sprint Retrospective

• Sprint Planning: Team plans the work to be done in the upcoming sprint

• Daily Standup: Team members discuss progress, plan for the day, and identify any obstacles

• Sprint Review: Team demonstrates the work completed during the sprint to stakeholders

• Sprint Retrospective: Team reflects on the sprint and identifies areas for improvement

I would handle customers with patience, empathy, and a positive attitude.

• Listen actively to their concerns and needs

• Offer solutions and assistance in a friendly manner

• Remain calm and professional, even in challenging situations

• Seek feedback to ensure customer satisfaction

• Provide accurate information about products and services

Process to procurement refers to the steps involved in acquiring goods or services for an organization.

• It involves identifying the need for a product or service

• Creating a request for proposal (RFP) or request for quotation (RFQ)

• Evaluating proposals and selecting a vendor

• Negotiating terms and finalizing the contract

• Managing the relationship with the vendor and monitoring performance

• Re-evaluating the procurement process periodically to ensure efficiency and effectiveness

I have used security services such as AWS WAF, Cloudflare, and Nessus for vulnerability scanning.

• Utilized AWS WAF to protect web applications from common web exploits

• Implemented Cloudflare for DDoS protection and CDN services

• Conducted vulnerability scanning using Nessus to identify security weaknesses

Basic account types include checking, savings, and money market accounts with specific rules for each.

• Checking accounts are used for everyday transactions and typically have no interest but may have fees.

• Savings accounts are used for long-term savings and earn interest but may have limits on withdrawals.

• Money market accounts are a hybrid of checking and savings accounts, offering higher interest rates but with limited transactions.

• Rules for each account type may include minim...read more

Various sourcing strategies include job boards, social media, employee referrals, networking events, and recruitment agencies.

• Job boards: Posting job openings on websites like Indeed, Glassdoor, and LinkedIn.

• Social media: Utilizing platforms like Facebook, Twitter, and Instagram to reach potential candidates.

• Employee referrals: Encouraging current employees to refer qualified candidates for open positions.

• Networking events: Attending industry events, job fairs, and conference...read more

Complex VPC architectures involve multiple subnets, route tables, security groups, and network ACLs to create a secure and scalable network environment.

• Utilize multiple subnets to segment resources based on function or security requirements

• Implement route tables to control traffic between subnets and to the internet

• Use security groups to define inbound and outbound traffic rules for instances

• Leverage network ACLs to provide an additional layer of security at the subnet level

• C...read more

Instruments used in control and instrumentation include sensors, transmitters, controllers, and actuators.

• Sensors: devices that detect changes in physical properties and convert them into electrical signals (e.g. temperature sensors, pressure sensors)

• Transmitters: devices that send signals from sensors to controllers (e.g. signal transmitters)

• Controllers: devices that receive signals from sensors and transmitters to regulate processes (e.g. PID controllers)

• Actuators: devices ...read more

PID loop is a control system feedback mechanism used in industrial processes to maintain desired setpoints.

• PID stands for Proportional, Integral, Derivative

• Proportional term responds to the current error

• Integral term corrects past errors

• Derivative term predicts future errors

• PID controller continuously calculates an error value as the difference between a desired setpoint and a measured process variable

• Example: PID loop in a temperature control system adjusts the heater output...read more

Use SQL to find the department with the highest revenue.

• Use a SQL query to sum the revenue for each department

• Group the results by department

• Order the results in descending order and limit to 1 to find the department with the highest revenue