i
bp
Work with us
Filter interviews by
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
Implementing an LRU Cache involves using a data structure to store key-value pairs with a limit on size, evicting least recently used items.
Use a combination of a hash map and a doubly linked list for efficient access and updates.
The hash map stores keys and pointers to the nodes in the linked list.
The linked list maintains the order of usage, with the most recently used at the front.
When adding a new item, check if it...
I applied via Recruitment Consulltant and was interviewed in Jan 2024.Ā There were 3 interview rounds.
2 question :
1. Find the longest common subsequence in 2 strings
2. find the 5th highest revenue from the table in last 28 days in a particular region
I was given a list of book, genre of books and books and rating of books . All list was of equal length n.
There were 2 methods which need to be implemented
1. get highest rating of book by genre . if rating are same then in lexographical order
2. update book rating by book name
I applied via Company Website and was interviewed in Mar 2023.Ā There were 3 interview rounds.
First round was online assessment test with programming and aptitude games
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
What people are saying about bp
I applied via Naukri.com and was interviewed before Jun 2020.Ā There was 1 interview round.
JSA/JHA stands for Job Safety Analysis/Job Hazard Analysis. It is a process of identifying potential hazards and risks in a job or task.
JSA/JHA is a systematic approach to identify and mitigate potential hazards in a job or task
It involves breaking down a job or task into steps and analyzing each step for potential hazards
The analysis includes identifying the hazards, assessing the risks, and implementing controls to m...
HSE plays a crucial role in ensuring the safety and well-being of employees and the environment.
HSE stands for Health, Safety, and Environment.
It involves identifying and assessing potential hazards and implementing measures to control or eliminate them.
HSE also includes training employees on safety procedures and emergency response plans.
Examples of HSE measures include wearing personal protective equipment, conductin...
Hchem is not a known term or acronym in the engineering field.
Hchem is not a commonly used term in engineering
It is possible that the interviewer misspoke or meant to ask a different question
Without more context, it is difficult to provide a more specific answer
Confined spaces pose a significant hazard due to limited entry and exit points, poor ventilation, and potential for hazardous substances.
Limited entry and exit points can make it difficult to escape in case of an emergency
Poor ventilation can lead to a buildup of toxic gases or lack of oxygen
Potential for hazardous substances such as chemicals, fumes, or dust
Examples include tanks, silos, sewers, and tunnels
Proper trai...
Precautions to be taken while working in confined spaces
Proper ventilation and air quality testing
Use of personal protective equipment
Proper lighting and communication equipment
Training and certification for workers
Emergency rescue plan in place
Fire is a chemical reaction that releases heat, light, and various gases.
Fire is a rapid oxidation process that occurs when fuel (such as wood, paper, or gasoline) combines with oxygen in the presence of heat or a spark.
It releases heat, light, and various gases such as carbon dioxide, water vapor, and nitrogen oxides.
Fire can be beneficial (such as for cooking or heating) or destructive (such as in wildfires or house ...
There are four types of fire: Class A, Class B, Class C, and Class D.
Class A fires involve ordinary combustibles such as wood, paper, or cloth.
Class B fires involve flammable liquids or gases such as gasoline, oil, or propane.
Class C fires involve electrical equipment such as appliances, wiring, or circuit breakers.
Class D fires involve combustible metals such as magnesium, titanium, or sodium.
Modes of heat transfer include conduction, convection, and radiation.
Conduction is the transfer of heat through a material without any movement of the material itself.
Convection is the transfer of heat through the movement of fluids, such as air or water.
Radiation is the transfer of heat through electromagnetic waves, such as from the sun or a fire.
MSDS stands for Material Safety Data Sheet.
MSDS provides information about hazardous chemicals and substances.
It includes information about the physical and chemical properties of the substance, health hazards, precautions for safe handling and use, and emergency procedures.
MSDS is required by law for all hazardous chemicals and substances used in the workplace.
It is important to read and understand the MSDS before usi...
Firefighting involves identifying and extinguishing fires to prevent damage and loss of life.
Assess the situation and determine the type and size of fire
Use appropriate firefighting equipment such as fire extinguishers, hoses, and pumps
Follow safety protocols and wear protective gear
Coordinate with other firefighters and emergency responders
Evacuate people from the affected area
Monitor the situation and ensure the fire...
Prevent accidents by identifying potential hazards and implementing safety measures.
Conduct regular safety audits and risk assessments
Provide proper training and education to employees
Implement safety protocols and procedures
Use appropriate safety equipment and gear
Encourage a culture of safety and accountability
Regularly review and update safety policies and procedures
H2S is a colorless, flammable, and toxic gas with a strong odor of rotten eggs.
H2S is commonly known as hydrogen sulfide.
It is produced naturally by the breakdown of organic matter and is found in natural gas, crude oil, and volcanic gases.
It is highly toxic and can cause respiratory failure, loss of consciousness, and even death.
H2S is used in various industries such as oil and gas, mining, and pulp and paper.
It is al...
H2S is a colorless, flammable, and toxic gas with a strong odor of rotten eggs.
H2S is highly flammable and can ignite easily
It is toxic and can cause respiratory failure
It has a distinctive odor of rotten eggs
H2S is used in the production of sulfuric acid and in the petroleum industry
Permissible exposure limits (PEL) are the maximum allowable concentrations of hazardous substances in the workplace.
H2S: PEL is 10 ppm (parts per million) over an 8-hour workday
CO: PEL is 50 ppm over an 8-hour workday
CO2: No specific PEL, but recommended exposure limit is 5,000 ppm over an 8-hour workday
Methane: No specific PEL, but recommended exposure limit is 1,000 ppm over an 8-hour workday
Short term exposure limit (STEL) of H2S is 10 ppm.
STEL is the maximum concentration of a substance that a worker can be exposed to for a short period of time without suffering from immediate or long-term health effects.
The STEL for H2S is set at 10 ppm (parts per million) by OSHA (Occupational Safety and Health Administration).
Exposure to H2S at levels above the STEL can cause symptoms such as eye irritation, headache,...
I applied via Naukri.com and was interviewed in Oct 2020.Ā There were 3 interview rounds.
I applied via Company Website and was interviewed before Sep 2021.Ā There were 2 interview rounds.
To identify if a pump is cavitating while working on a DCS panel, you can look for certain indicators.
Monitor the pump's suction pressure. If it is fluctuating or dropping below the specified range, it may indicate cavitation.
Check the pump's discharge pressure. If it is higher than normal, it could be a sign of cavitation.
Listen for unusual noises such as a rattling or grinding sound coming from the pump.
Inspect the p...
To prepare a hydrocarbon vessel for vessel entry, follow these steps:
Ensure the vessel is properly isolated from the process and all sources of energy
Ventilate the vessel to remove any flammable or toxic gases
Perform a thorough inspection of the vessel for any signs of leaks or damage
Implement proper lockout/tagout procedures to prevent accidental activation of equipment
Provide appropriate personal protective equipment...
I applied via Campus Placement and was interviewed in Jul 2024.Ā There was 1 interview round.
I applied via Campus Placement and was interviewed in Sep 2024.Ā There were 2 interview rounds.
Mostly easy questions
Cheating overview like should we do it as everyone is doing
based on 5 interview experiences
Difficulty level
Duration
based on 3 reviews
Rating in categories
Senior Analyst
131
salaries
| ā¹8.2 L/yr - ā¹17 L/yr |
Analyst
103
salaries
| ā¹5.3 L/yr - ā¹12.4 L/yr |
Senior Software Engineer
79
salaries
| ā¹34 L/yr - ā¹56.8 L/yr |
ARC Analyst
75
salaries
| ā¹8.1 L/yr - ā¹14.1 L/yr |
Data Analyst
65
salaries
| ā¹10.4 L/yr - ā¹27.5 L/yr |
Reliance Industries
GAIL
Petrofac
Schlumberger