Filter interviews by
DDL, DML, and DQL are SQL categories for defining, manipulating, and querying data in databases.
DDL (Data Definition Language) is used to define database structures. Example: CREATE TABLE, ALTER TABLE.
DML (Data Manipulation Language) is used for managing data within schema objects. Example: INSERT, UPDATE, DELETE.
DQL (Data Query Language) is used to query and retrieve data. Example: SELECT.
Procedures perform actions without returning values; functions return values and can be used in expressions.
Procedures are called for their side effects, e.g., updating a database.
Functions return a value and can be used in expressions, e.g., calculating a sum.
Procedures do not have a return type, while functions must specify one.
Example of a procedure: 'UPDATE Employee SET Salary = Salary * 1.1'.
Example of a func...
PL/SQL code blocks consist of declarations, executable commands, and exception handling for structured programming in Oracle databases.
Declaration Section: This is where variables, constants, and cursors are declared. Example: 'DECLARE v_employee_name VARCHAR2(100);'
Executable Section: This part contains the actual code that performs operations. Example: 'BEGIN SELECT name INTO v_employee_name FROM employees WHERE...
Sheet piles are commonly used in damp and flood-prone areas to provide structural support and prevent water infiltration.
Sheet piles are driven into the ground to create a barrier against water seepage.
They are often made of steel or vinyl and are interlocked to form a continuous wall.
Sheet piles can be used in cofferdams, seawalls, and flood protection systems.
They are effective in preventing soil erosion and pro...
We followed strict safety protocols including regular safety inspections, providing proper PPE, conducting safety training sessions, and implementing emergency response plans.
Regular safety inspections were conducted to identify and address potential hazards
Proper personal protective equipment (PPE) was provided to all employees
Safety training sessions were held to educate employees on safe work practices
Emergency...
I manage warehouse operations by overseeing inventory, coordinating shipments, optimizing layout, and ensuring safety protocols.
Oversee inventory levels to prevent stockouts and overstocking
Coordinate shipments to ensure timely delivery and minimize delays
Optimize warehouse layout for efficient storage and retrieval
Enforce safety protocols to prevent accidents and ensure compliance with regulations
ArcelorMittal is the world's largest steel producer, operating in over 60 countries and employing over 190,000 people.
ArcelorMittal was formed in 2006 through the merger of Arcelor and Mittal Steel.
It is headquartered in Luxembourg and has a significant presence in Europe, the Americas, Asia, and Africa.
The company produces a wide range of steel products for various industries, including automotive, construction, ...
Arcelormittal Nippon Steel is a joint venture between Arcelormittal and Nippon Steel, formed to create a leading steel company.
The joint venture combines the strengths of both companies in terms of technology, expertise, and market reach.
It allows for greater efficiency and cost savings through shared resources and operations.
The partnership also enables the company to better serve customers globally with a wider ...
Preventive maintenance is planned maintenance to prevent breakdowns, while breakdown maintenance is repairing equipment after it has failed.
Preventive maintenance is scheduled and proactive
Breakdown maintenance is reactive and occurs after equipment failure
Preventive maintenance reduces downtime and increases equipment lifespan
Breakdown maintenance can be costly and cause production delays
Examples of preventive ma...
The size of a transformer can vary greatly depending on its intended use and power capacity.
The size of a transformer is typically measured in kVA (kilovolt-amperes) or MVA (megavolt-amperes).
Transformers used in residential settings can range from 5-50 kVA.
Transformers used in industrial settings can range from 500 kVA to over 100 MVA.
The physical size of a transformer can also vary greatly depending on its power...
I applied via Walk-in and was interviewed before Aug 2020. There was 1 interview round.
Flushing and pickling are processes used to clean and protect hydraulic systems.
Flushing involves removing contaminants and debris from the system using a flushing fluid.
Pickling involves applying a protective coating to the system to prevent corrosion.
Both processes are important for maintaining the performance and longevity of hydraulic systems.
Examples of flushing fluids include water, solvents, and specialized flus...
Preventive maintenance is planned maintenance to prevent breakdowns, while breakdown maintenance is repairing equipment after it has failed.
Preventive maintenance is scheduled and proactive
Breakdown maintenance is reactive and occurs after equipment failure
Preventive maintenance reduces downtime and increases equipment lifespan
Breakdown maintenance can be costly and cause production delays
Examples of preventive mainten...
I appeared for an interview in Mar 2025, where I was asked the following questions.
I am a dedicated and experienced professional with a strong background in leadership and management.
Over 10 years of experience in supervisory roles
Proven track record of successfully leading teams to achieve goals
Strong communication and problem-solving skills
Bachelor's degree in Business Administration
Previous experience in handling budgets and resources effectively
I have successfully led a team to increase productivity by 20% and reduce costs by 15% in my previous role as a Section Incharge.
Led a team to increase productivity by 20%
Reduced costs by 15%
Implemented new strategies to streamline processes
Received recognition for outstanding performance
As a Section Incharge, my roles and responsibilities include overseeing the daily operations of a specific department or section, managing staff, ensuring compliance with regulations, and implementing strategies to improve efficiency.
Overseeing the daily operations of the assigned section
Managing and supervising staff members
Ensuring compliance with regulations and company policies
Implementing strategies to improve eff...
I applied via Naukri.com and was interviewed in May 2024. There were 2 interview rounds.
Sheet piles are commonly used in damp and flood-prone areas to provide structural support and prevent water infiltration.
Sheet piles are driven into the ground to create a barrier against water seepage.
They are often made of steel or vinyl and are interlocked to form a continuous wall.
Sheet piles can be used in cofferdams, seawalls, and flood protection systems.
They are effective in preventing soil erosion and protecti...
Grade of concrete refers to the strength of the concrete mix design.
Grade of concrete is denoted by the ratio of cement to sand to aggregate.
Common grades of concrete include M10, M15, M20, etc.
Higher grade concrete has higher strength and durability.
For example, M20 concrete has a compressive strength of 20 MPa.
I applied via LinkedIn and was interviewed in May 2024. There were 2 interview rounds.
Explain the importance of conducting safety audits in a workplace.
Safety audits help identify potential hazards and risks in the workplace.
They ensure compliance with safety regulations and standards.
Audits can lead to improvements in safety procedures and practices.
Regular audits can prevent accidents and injuries.
Audits provide a way to measure the effectiveness of safety programs.
Examples: conducting a fire safety a...
I applied via Naukri.com and was interviewed in Nov 2023. There were 3 interview rounds.
I manage warehouse operations by overseeing inventory, coordinating shipments, optimizing layout, and ensuring safety protocols.
Oversee inventory levels to prevent stockouts and overstocking
Coordinate shipments to ensure timely delivery and minimize delays
Optimize warehouse layout for efficient storage and retrieval
Enforce safety protocols to prevent accidents and ensure compliance with regulations
We followed strict safety protocols including regular safety inspections, providing proper PPE, conducting safety training sessions, and implementing emergency response plans.
Regular safety inspections were conducted to identify and address potential hazards
Proper personal protective equipment (PPE) was provided to all employees
Safety training sessions were held to educate employees on safe work practices
Emergency resp...
I applied via Approached by Company and was interviewed in Oct 2023. There were 3 interview rounds.
General discussion about my job
I appeared for an interview before Apr 2024, where I was asked the following questions.
Procedures perform actions without returning values; functions return values and can be used in expressions.
Procedures are called for their side effects, e.g., updating a database.
Functions return a value and can be used in expressions, e.g., calculating a sum.
Procedures do not have a return type, while functions must specify one.
Example of a procedure: 'UPDATE Employee SET Salary = Salary * 1.1'.
Example of a function:...
DDL, DML, and DQL are SQL categories for defining, manipulating, and querying data in databases.
DDL (Data Definition Language) is used to define database structures. Example: CREATE TABLE, ALTER TABLE.
DML (Data Manipulation Language) is used for managing data within schema objects. Example: INSERT, UPDATE, DELETE.
DQL (Data Query Language) is used to query and retrieve data. Example: SELECT.
PL/SQL code blocks consist of declarations, executable commands, and exception handling for structured programming in Oracle databases.
Declaration Section: This is where variables, constants, and cursors are declared. Example: 'DECLARE v_employee_name VARCHAR2(100);'
Executable Section: This part contains the actual code that performs operations. Example: 'BEGIN SELECT name INTO v_employee_name FROM employees WHERE id =...
Top trending discussions
The duration of ArcelorMittal interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 33 interview experiences
Difficulty level
Duration
based on 463 reviews
Rating in categories
Deputy Manager
138
salaries
| ₹5.3 L/yr - ₹16 L/yr |
Manager
123
salaries
| ₹7.2 L/yr - ₹25 L/yr |
Assistant Manager
107
salaries
| ₹4 L/yr - ₹13.4 L/yr |
Assistant Field Engineer
56
salaries
| ₹1.8 L/yr - ₹4.3 L/yr |
Senior Manager
54
salaries
| ₹11.4 L/yr - ₹30 L/yr |
Tata Steel
Tata Steel Downstream Products
Tata BlueScope Steel
Arjas Steel