90+ Metscco Heavy Steel Industries Interview Questions and Answers

Display values from a table with alternate value

• Use a loop to iterate through the table values

• Use an if-else statement to check for alternate values

• Display the alternate values using a different formatting or color

• Consider using CSS or JavaScript to enhance the display

Yes

• Implemented OOPs concepts in the project using Stream API

• Utilized Map in Collections to implement OOPs principles

• Used Stream API to apply functional programming concepts in the project

Use SQL query with WHERE clause to filter out low values while fetching data from DB2 table

• Use SELECT statement to fetch data from table

• Add WHERE clause with condition to filter out low values

• Example: SELECT * FROM table_name WHERE column_name > 10

• Use ORDER BY clause to sort the data in ascending or descending order

A controller to handle POST requests in a Spring REST API.

• Create a new class annotated with @RestController

• Define a method in the class annotated with @PostMapping

• Use @RequestBody annotation to bind the request body to a parameter

• Implement the logic to handle the POST request

• Return the response using ResponseEntity

Annotations used in web services, pagination, exception handling in Spring

• Web services in Spring can be annotated with @RestController or @Controller

• Pagination can be achieved using @PageableDefault and @PageableParam

• Exception handling can be done using @ExceptionHandler and @ControllerAdvice

FCR stands for First Call Resolution. I have handled X number of incidents with a Y% FCR rate.

• FCR is a metric used to measure the percentage of incidents resolved on the first call or contact.

• A high FCR rate indicates efficient incident management and customer satisfaction.

• I have handled X number of incidents with a Y% FCR rate, which demonstrates my ability to quickly and effectively resolve issues.

• For example, in my previous role as an Incident Manager at XYZ company, I ach...read more

The @Transactional annotation is used in Spring JPA to manage transactions in database operations.

• The @Transactional annotation is used to mark a method or class as transactional.

• It ensures that all database operations within the annotated method or class are executed within a single transaction.

• If an exception occurs, the transaction is rolled back, and changes made within the transaction are not persisted.

• The @Transactional annotation can be used with different propagation ...read more

Excel sheet is a software application by Microsoft that allows users to organize, format, and calculate data with formulas.

• Excel sheet is a spreadsheet program used for data analysis and management.

• It allows users to create tables, charts, and graphs to represent data.

• Formulas are used to perform calculations on data in Excel, such as adding, subtracting, multiplying, and dividing.

• Examples of formulas include SUM, AVERAGE, MAX, MIN, and COUNT.

• Excel also has built-in functions...read more

WPF provides better UI design and development options than Windows Forms.

• WPF allows for more flexible and customizable UI design.

• WPF supports vector graphics and animations.

• WPF has better data binding capabilities.

• WPF is more modern and actively developed than Windows Forms.

• WPF is better suited for creating modern desktop applications.

Procedures and triggers are database objects used to automate tasks and enforce rules.

• Procedures are a set of SQL statements that can be executed repeatedly.

• Triggers are special types of procedures that are automatically executed in response to certain events.

• Triggers can be used to enforce business rules, audit changes, or replicate data.

• Procedures and triggers can be written in various programming languages such as SQL, PL/SQL, T-SQL, etc.

Singleton design pattern restricts the instantiation of a class to a single instance.

• Ensures only one instance of a class exists

• Provides a global point of access to that instance

• Used when only one object is needed to coordinate actions across the system

• Example: Database connection manager

The Account golden rule is a fundamental principle in accounting that states that for every debit entry, there must be a corresponding credit entry.

• The Account golden rule is also known as the Dual Aspect Concept.

• It is based on the principle of double-entry bookkeeping.

• The rule ensures that the accounting equation (Assets = Liabilities + Equity) remains in balance.

• For example, if a company purchases inventory for cash, there will be a debit entry to the inventory account and ...read more

Sorting using JCL and COBOL

• JCL can be used to submit a COBOL program for sorting

• COBOL program can use SORT verb to sort data

• Sorting can be done based on specific fields or criteria

• COBOL program can use SORT-RETURN to check the status of the sort operation

SLA for P3 incident is typically 24-48 hours.

• P3 incidents are considered low priority incidents

• SLA for P3 incidents is usually longer than P1 and P2 incidents

• SLA for P3 incidents can vary depending on the organization and the severity of the incident

• Typically, SLA for P3 incidents is around 24-48 hours

• SLA for P3 incidents may include response time, resolution time, and communication requirements

Severity refers to the impact of a bug on the system, while priority refers to the order in which bugs should be fixed. Requirements are gathered through meetings, interviews, documentation review, and prototyping.

• Severity is the measure of how much a bug affects the system's functionality.

• Priority determines the order in which bugs should be fixed based on business needs.

• Requirements are gathered through meetings with stakeholders to understand their needs and expectations.

• I...read more

An incident refers to an unplanned interruption or degradation of a service, while a service request is a formal request for assistance or information.

• Incident: Unplanned interruption or degradation of a service

• Service request: Formal request for assistance or information

• Incidents are typically reported by users when a service is not functioning as expected

• Service requests are initiated by users seeking help or information, such as password reset, software installation, etc.

• I...read more

LINQ (Language Integrated Query) is a Microsoft technology that allows querying data from different sources using a common syntax.

• LINQ provides a unified way to query data from different sources such as databases, XML documents, and collections.

• It allows developers to write queries using a common syntax regardless of the data source.

• LINQ queries are strongly typed and can be checked at compile time.

• Examples of LINQ providers include LINQ to SQL, LINQ to XML, and LINQ to Objec...read more

Encapsulation is hiding implementation details while abstraction is showing only necessary details.

• Encapsulation is achieved through access modifiers like private, protected, and public.

• Abstraction is achieved through abstract classes and interfaces.

• Encapsulation provides data security and prevents unauthorized access.

• Abstraction helps in reducing complexity and improves maintainability.

• Example of encapsulation: Class with private variables and public methods.

• Example of abstr...read more

MVC life cycle is a series of steps that occur when a request is made to an MVC application.

• Request is received by the routing engine

• Routing engine determines the controller and action to handle the request

• Controller is instantiated and action method is called

• Action method returns a view

• View is rendered and returned as a response

Lower profitability can be caused by various factors such as declining sales, increased expenses, inefficient operations, or external market conditions.

• Declining sales due to changing consumer preferences or increased competition

• Increased expenses from rising costs of raw materials or labor

• Inefficient operations leading to higher production costs or wastage

• External market conditions like economic downturn or regulatory changes

My strengths include excellent communication skills, problem-solving abilities, and a positive attitude.

• Excellent communication skills

• Strong problem-solving abilities

• Positive attitude

• Ability to work well under pressure

• Attention to detail

• Ability to multitask

• Empathy and patience

• Flexibility and adaptability

Sales is the process of selling products or services, while marketing is the process of creating demand for those products or services.

• Sales involves direct interaction with customers to close deals, while marketing involves creating brand awareness and generating leads.

• Sales is focused on short-term goals, while marketing is focused on long-term goals.

• Sales is a subset of marketing, as marketing encompasses a broader range of activities such as advertising, public relations,...read more

An abstract class is a class that cannot be instantiated and is used as a base class for other classes.

• An abstract class can have abstract and non-abstract methods.

• Abstract methods have no implementation and must be implemented by the derived class.

• An abstract class can have constructors and fields.

• An abstract class can be used to define a common interface for a group of related classes.

• Example: Animal is an abstract class and Dog, Cat, and Bird are derived classes.

I have handled multiple job portals and have extensive experience in job postings and sourcing skills.

• Managed 5 different job portals simultaneously

• Posted over 100 job listings in the past year

• Utilized various sourcing techniques such as LinkedIn, networking events, and employee referrals

The five stages of project implementation are initiation, planning, execution, monitoring and controlling, and closing.

• Initiation: Define the project, set goals, and identify stakeholders.

• Planning: Develop a detailed project plan, allocate resources, and set timelines.

• Execution: Implement the project plan and carry out the work.

• Monitoring and Controlling: Track progress, manage changes, and ensure quality.

• Closing: Finalize all activities, hand over deliverables, and evaluate ...read more

ADO.NET is a data access technology used to connect applications to databases.

• ADO.NET provides a set of classes to interact with databases.

• It supports disconnected data architecture.

• It uses Data Providers to connect to different databases.

• It supports LINQ to SQL for querying databases.

• Examples of Data Providers are SQL Server, Oracle, MySQL, etc.

WPF stands for Windows Presentation Foundation. It is a graphical subsystem for rendering user interfaces in Windows-based applications.

• WPF is a part of .NET Framework and provides a unified programming model for building desktop applications.

• It uses XAML (eXtensible Application Markup Language) to define and create user interfaces.

• WPF supports rich media, 2D and 3D graphics, animation, and data binding.

• It allows for separation of UI design and development, making it easier f...read more

I use historical data, industry trends, and economic indicators to create forecasts.

• Gather historical data on sales, expenses, and other relevant metrics

• Analyze industry trends and economic indicators that may impact the business

• Use forecasting models such as regression analysis or time series analysis

• Adjust forecasts based on qualitative factors like market conditions or company strategy

• Regularly review and update forecasts as new information becomes available

Cluster index physically orders the data rows in the table, while non-cluster index does not.

• Cluster index determines the physical order of data rows in the table.

• Non-cluster index does not affect the physical order of data rows.

• Cluster index is faster for retrieval of data in the order specified by the index.

• Non-cluster index is faster for retrieval of data based on specific columns.

• Example: Cluster index on a primary key column will physically order the table by that key.

• Ex...read more

SLA is calculated by measuring the time between a customer's request and the completion of the service.

• Determine the start and end time of the service request

• Subtract the start time from the end time to get the total time taken

• Compare the total time taken to the agreed upon SLA timeframe

• Calculate the percentage of requests completed within the SLA timeframe

• SLA = (Number of requests completed within SLA timeframe / Total number of requests) * 100

A financial statement that shows a company's assets, liabilities, and equity at a specific point in time.

• It is a snapshot of a company's financial position.

• Assets are listed on one side and liabilities and equity on the other.

• The balance sheet equation is Assets = Liabilities + Equity.

• It helps investors and creditors evaluate a company's financial health.

• Examples of assets include cash, inventory, and property.

• Examples of liabilities include loans and accounts payable.

• Example...read more

There are 8 primitive data types in Java.

• Primitive data types: byte, short, int, long, float, double, char, boolean

• Examples: int num = 10; char letter = 'A'; boolean flag = true;

DELETE removes specific rows from a table, while TRUNCATE removes all rows from a table.

• DELETE is a DML command, while TRUNCATE is a DDL command.

• DELETE can be rolled back, while TRUNCATE cannot be rolled back.

• DELETE triggers delete triggers on each row, while TRUNCATE does not trigger any delete triggers.

• DELETE is slower as it maintains logs, while TRUNCATE is faster as it does not maintain logs.

Cursor is a database object used to manipulate data in a result set.

• Cursor is used to fetch a set of rows from a result set.

• It allows the application to move forward and backward through the result set.

• Cursor can be declared and opened in SQL.

• It can be used to update or delete rows in a result set.

• Cursor can be closed explicitly or implicitly.

Anti money laundering (AML) refers to a set of laws, regulations, and procedures aimed at preventing the illegal generation of income through criminal activities.

• AML is a process designed to detect and prevent money laundering and terrorist financing.

• It involves implementing policies and procedures to identify and report suspicious activities.

• Financial institutions and businesses are required to comply with AML regulations to ensure transparency and prevent illicit financial ...read more

AHT% is calculated by dividing the total talk time by the total call time and multiplying by 100.

• Calculate total talk time and total call time

• Divide total talk time by total call time

• Multiply the result by 100 to get AHT%

Reverse a string using recursion in Java

• Create a recursive method that takes a string as input

• Base case: if the string is empty or has only one character, return the string

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

Financial markets are platforms where buyers and sellers trade financial assets such as stocks, bonds, currencies, and commodities.

• Financial markets facilitate the buying and selling of financial assets

• They include stock markets, bond markets, currency markets, and commodity markets

• Prices in financial markets are determined by supply and demand

• Participants in financial markets include individual investors, institutional investors, and financial institutions

The stages of anti-money laundering include placement, layering, and integration.

• Placement: The process of introducing illicit funds into the financial system.

• Layering: The process of disguising the origin of funds through complex transactions.

• Integration: The process of making illicit funds appear legitimate by merging them with legal funds.

• Example: A criminal starts by depositing cash from illegal activities into multiple bank accounts (placement), then transfers the funds ...read more

Utilize historical data, consider external factors, use multiple forecasting methods, and regularly review and adjust forecasts.

• Utilize historical data to identify trends and patterns

• Consider external factors such as economic indicators, industry trends, and market conditions

• Use multiple forecasting methods like time series analysis, regression analysis, and scenario analysis

• Regularly review and adjust forecasts based on new information and changes in the business environment

BPO stands for Business Process Outsourcing. It involves contracting a third-party service provider to handle specific business operations.

• BPO involves outsourcing non-core business functions to specialized service providers.

• Common BPO services include customer support, technical support, data entry, and back office operations.

• Companies opt for BPO to reduce costs, improve efficiency, and focus on core business activities.

• Example: A company outsourcing its customer service op...read more

Exception handling in Java is a mechanism to handle runtime errors and prevent program crashes.

• Use try-catch blocks to handle exceptions

• Use finally block to execute code regardless of exception

• Use throw keyword to manually throw exceptions

• Use throws keyword in method signature to declare exceptions that can be thrown

Revenue recognition principle dictates when revenue should be recognized in financial statements.

• Revenue should be recognized when it is earned, realized or realizable, and can be measured reliably.

• It is important to match revenues with the expenses incurred to generate them.

• Examples include recognizing revenue from the sale of goods when the risks and rewards of ownership have transferred to the buyer.

• Another example is recognizing revenue from services as they are performed...read more