Infosys
100+ Interview Questions and Answers
Q1. 2. Explain COMP, COMP-2, COMP-3 and Display. What are the difference between Continue and Next Sentence? Why does SOC7 occur?
Explanation of COMP, COMP-2, COMP-3, Display, Continue, Next Sentence, and SOC7.
COMP is a binary data type, COMP-2 is a packed decimal data type, COMP-3 is a packed decimal data type with sign, and Display is a character data type.
Continue is used to transfer control to the next statement within the same paragraph, while Next Sentence is used to transfer control to the first statement of the next paragraph.
SOC7 occurs due to a data exception error, such as an invalid numeric ...read more
Q2. 1. Explain COND parameter in JCL. What parameters can be coded both in JOB level as well as STEP level. What are GDG and how to access previous version, next version and current version in any given job.
COND parameter in JCL, parameters in JOB and STEP level, accessing GDG versions in a job.
COND parameter is used to specify a condition code that must be satisfied for the job or step to execute.
Parameters like TIME, REGION, MSGCLASS, etc. can be coded in both JOB and STEP level.
GDG (Generation Data Group) is a group of datasets related to each other by a common name and a generation number.
To access previous version, use (-1), next version use (+1), and current version use (0...read more
Q3. What is Data Dictionary, an explanation about all the elements of DDIC?
A Data Dictionary is a centralized repository that provides a detailed description of all data elements used in a system.
A Data Dictionary contains information about the structure, meaning, and usage of data elements.
It helps in maintaining data integrity and consistency across the system.
Data Dictionary entries typically include data element names, descriptions, data types, lengths, and validation rules.
It serves as a reference for developers, analysts, and users to understa...read more
Q4. 3. How to fetch more than one record from DB from COBOL? Explain the precompilation process. Why is bind necessary? SQL error code for duplicate record present in table?
Fetching multiple records from DB in COBOL and precompilation process
Use SELECT statement with appropriate WHERE clause
Use cursor to fetch multiple records
Precompilation process involves converting COBOL code to C code
Bind is necessary to link the precompiled C code with DB
SQL error code for duplicate record present in table is -803
Q5. Explain threading and how to implement multithreading
Threading is a technique to execute multiple tasks concurrently. Multithreading can be implemented using threads.
Threading allows multiple tasks to run concurrently, improving performance and responsiveness.
Threads are lightweight processes that share the same memory space.
Threads can be created using programming languages like Java, C++, or Python.
Multithreading can be implemented by creating and managing multiple threads within a program.
Thread synchronization techniques li...read more
Q6. Suppose a part of code is on PRD, what is the first thing u need to check from DEV if there any other changes done in between.
Check the version control system for any changes made to the code in DEV.
Check the commit history in the version control system.
Compare the code in PRD with the latest version in DEV.
Ensure that any changes made in DEV are properly tested and approved before deploying to PRD.
Q7. Unix commands to copy the directory and delete contents of the directory
The Unix command to copy a directory is 'cp -r' and to delete the contents of a directory is 'rm -r'.
To copy a directory, use the 'cp -r' command followed by the source directory and destination directory.
To delete the contents of a directory, use the 'rm -r' command followed by the directory name.
Be cautious when using the 'rm -r' command as it permanently deletes the contents of the directory.
Q8. What is Client independent and client dependant? Describe some tables.
Client independent and client dependent are two types of tables in a database.
Client independent tables contain data that is not specific to any particular client or user.
Client dependent tables contain data that is specific to a particular client or user.
Examples of client independent tables include product catalogs, while examples of client dependent tables include user profiles.
Client dependent tables often have a foreign key relationship with client independent tables.
Q9. What is Unit testing. Which unit testing you have used?
Unit testing is a software testing technique where individual units or components of a software application are tested in isolation.
Unit testing is done to ensure that each unit/component of the software application is working as expected.
It helps in identifying and fixing bugs early in the development cycle.
Unit tests are automated and can be run frequently to ensure that changes made to the code do not break existing functionality.
Examples of unit testing frameworks include...read more
Q10. What is the difference between where and having clause?
Where clause filters rows before grouping, having clause filters groups after grouping.
Where clause is used in the SELECT statement to filter rows based on a condition.
Having clause is used in the GROUP BY statement to filter groups based on a condition.
Where clause is used before grouping, having clause is used after grouping.
Where clause filters individual rows, having clause filters groups of rows.
Example: SELECT name, SUM(sales) FROM table WHERE sales > 1000 GROUP BY name...read more
Q11. Oops from c#, Asp.net page cycle events, difference between abstract class and interface, collections, difference between constant, read-only, what's instance variables, Solid principles, extension method, diff...
read moreInterview question for Senior Systems Engineer
Oops concepts in C#
ASP.NET page cycle events
Difference between abstract class and interface
Collections in C#
Difference between constant and read-only variables
Instance variables in C#
SOLID principles
Extension methods in C#
Difference between Hyperlink and LinkButton controls in ASP.NET
GridView events in ASP.NET
General questions in ADO.NET
Project details
Q12. One simple use case and how you implement write program sudo code
Implementing a program using sudo code for a simple use case
Identify the problem statement and requirements
Design the solution and choose the appropriate programming language
Write the sudo code using proper syntax and logic
Test and debug the program before implementation
Q13. When will you use stringbuilder and stringbuffer?
Stringbuilder and Stringbuffer are used to manipulate strings efficiently.
Use Stringbuilder when you need to modify a string frequently.
Use Stringbuffer when you need thread safety.
Both classes provide methods for appending, inserting, and deleting characters.
Example: Building a long string in a loop.
Example: Concatenating multiple strings.
Q14. What are evalution metrics for classification
Evaluation metrics for classification include accuracy, precision, recall, F1 score, and ROC curve.
Accuracy measures overall correctness of the model
Precision measures how many of the predicted positive cases are actually positive
Recall measures how many of the actual positive cases are correctly predicted
F1 score is the harmonic mean of precision and recall
ROC curve plots true positive rate against false positive rate
Examples: confusion matrix, AUC score
Q15. Which Object is challenging for you to develop?
Developing complex algorithms for machine learning models is challenging for me.
Creating models that can accurately predict outcomes
Balancing accuracy with computational efficiency
Ensuring the model is not overfitting or underfitting
Examples: image recognition, natural language processing
Q16. How to select the duplicate values in sql
To select duplicate values in SQL, use the GROUP BY clause and HAVING clause.
Use GROUP BY clause to group the data by the column that may have duplicates
Use HAVING clause to filter the groups that have more than one row
Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;
Q17. What is FM, what is BAPI, Difference between BAPI and BDC.
FM stands for Function Module, BAPI stands for Business Application Programming Interface. BAPI is a type of FM. BAPI is used for data transfer between SAP systems, BDC is used for data transfer between SAP and non-SAP systems.
FM stands for Function Module in SAP, which is a reusable function or subroutine that can be called by other programs.
BAPI stands for Business Application Programming Interface, which is a type of Function Module used for data transfer between SAP syste...read more
Q18. What is the difference between polymorphism and inheritance
Polymorphism is the ability of an object to take on many forms, while inheritance is the process of creating new classes from existing ones.
Polymorphism allows objects of different classes to be treated as if they were of the same class.
Inheritance allows a new class to be based on an existing class, inheriting its properties and methods.
Polymorphism is achieved through method overriding and method overloading.
Inheritance is achieved through the use of keywords like 'extends'...read more
Q19. What is the difference between constructor and destructor
Constructor is used to initialize an object while destructor is used to destroy an object.
Constructor is called when an object is created and can take arguments to initialize the object's state.
Destructor is called when an object is destroyed and is used to free up any resources allocated by the object.
Constructor has the same name as the class while destructor has the same name as the class preceded by a tilde (~).
Example: class Car { public: Car(string make, string model) {...read more
Q20. What’re exceptions and how can we deal with it
Exceptions are errors that occur during program execution. We can handle them using try-catch blocks.
Exceptions are thrown when an error occurs during program execution
We can handle exceptions using try-catch blocks
The try block contains the code that might throw an exception
The catch block contains the code that handles the exception
We can also use finally block to execute code regardless of whether an exception was thrown or not
Q21. Write a program to count the number of overs in a sting
Program to count the number of overs in a string
Define an over as 6 consecutive balls
Loop through the string and count the number of overs
Handle incomplete overs at the end of the string
Q22. What is your framework used for mobile automation
Appium is the framework used for mobile automation
Appium is an open-source tool for automating native, mobile web, and hybrid applications on iOS and Android platforms
It uses the WebDriver protocol to drive iOS and Android apps
Supports multiple programming languages like Java, Python, Ruby, etc.
Can run tests on simulators/emulators as well as real devices
Q23. How js works and it's advantages over other languages?
JavaScript is a versatile programming language known for its ability to run on the client side of web applications.
JavaScript is a high-level, interpreted language that allows for dynamic, client-side scripting on web pages.
It is versatile and can be used for a wide range of applications, from simple web development to complex server-side programming.
JavaScript has a large and active community, with a vast array of libraries and frameworks available for developers to use.
One ...read more
Q24. What is static block? Exception tree?Lambda experience?
Static block initializes static data members. Exception tree is a hierarchy of exceptions. Lambda is a functional interface.
Static block is used to initialize static data members before the class is loaded.
Exception tree is a hierarchy of exceptions where each exception is a subclass of Throwable.
Lambda is a functional interface that allows the use of functional programming concepts in Java.
Lambda expressions are used to implement functional interfaces.
Lambda expressions can ...read more
Q25. general structure of IT and work knowledge
The general structure of IT involves various components and work knowledge.
IT infrastructure includes hardware, software, networks, and data centers.
Work knowledge includes understanding operating systems, programming languages, and databases.
IT teams collaborate to design, implement, and maintain systems and networks.
Examples of work knowledge include proficiency in Linux, Java, and SQL.
IT professionals often specialize in areas like network administration, cybersecurity, or...read more
Q26. What are object oriented vs procedure oriented?
Object-oriented programming focuses on objects and their interactions, while procedure-oriented programming focuses on procedures and functions.
Object-oriented programming uses classes and objects to encapsulate data and behavior
Procedure-oriented programming uses functions to manipulate data
Object-oriented programming promotes code reusability and modularity
Procedure-oriented programming can lead to spaghetti code and is less modular
Examples of object-oriented programming la...read more
Q27. What are SMARTFORMS, Adobe forms?
SMARTFORMS and Adobe forms are tools used for creating and managing electronic forms.
SMARTFORMS is a tool provided by SAP for creating and managing electronic forms in SAP systems.
Adobe forms is a tool provided by Adobe for creating and managing electronic forms that can be used in various systems.
Both tools allow for the creation of dynamic forms that can be filled out electronically and submitted.
SMARTFORMS and Adobe forms can be used in various industries for different pur...read more
Q28. Explanation about Enhancements, BADI, BAPI, BDC.
Enhancements, BADI, BAPI, BDC are SAP technologies used for customizing and extending standard SAP functionality.
Enhancements are used to add custom code to standard SAP programs without modifying the original code.
BADI (Business Add-In) is a mechanism for adding custom code to standard SAP programs at specific points in the program flow.
BAPI (Business Application Programming Interface) is a set of standard interfaces provided by SAP for accessing and manipulating SAP data.
BD...read more
Q29. Explain the Reports (ALV, Module Pool, Dynamic).
Reports are used to display data in a structured format. ALV, Module Pool, and Dynamic are different types of reports.
ALV (ABAP List Viewer) is a standard SAP tool used to display data in a tabular format with various features like sorting, filtering, and grouping.
Module Pool reports are used to create interactive screens with input fields, buttons, and other UI elements to display data and allow user input.
Dynamic reports are created using ABAP code to generate a report on t...read more
Q30. Component vs directive Promise vs observable Life cycle hook Pipe Routing Data share
Key concepts in Angular development
Component vs directive: Components are the building blocks of Angular applications, while directives are used to add behavior to elements.
Promise vs observable: Promises are used for asynchronous operations that will return a single value, while observables are used for multiple values over time.
Life cycle hook: Angular provides lifecycle hooks that allow you to tap into specific points in a component's lifecycle, such as ngOnInit or ngOnDes...read more
Q31. How do you react when there is a prod issue?
I remain calm, analyze the issue, prioritize tasks, collaborate with team members, and work towards a resolution.
Remain calm and composed to think clearly
Analyze the issue to identify root cause
Prioritize tasks based on impact and urgency
Collaborate with team members for input and support
Work towards a resolution efficiently
Q32. what is the main use of Interfaces?
Interfaces are used to define a contract for classes to implement, allowing for polymorphism and loose coupling.
Interfaces define a set of methods that a class must implement, but do not provide the implementation details.
Interfaces allow for polymorphism, where objects of different classes that implement the same interface can be treated interchangeably.
Interfaces promote loose coupling between classes, as they only define the contract without specifying how it should be imp...read more
Q33. What is difference between Table and View?
Tables store data in rows and columns, while views are virtual tables created by a query.
Tables store actual data, while views store a query result
Tables can be modified directly, views are read-only
Views can combine data from multiple tables
Views can simplify complex queries by predefining joins and filters
Q34. Reverse a string and print wheather it's a palindrome or not
Reverse a string and check if it's a palindrome.
Use a loop to reverse the string.
Compare the reversed string with the original string to check if it's a palindrome.
Ignore spaces and punctuation while checking for palindrome.
Q35. What are the use cases for classification
Classification is used to categorize data into different groups based on certain criteria.
Classification is used in machine learning to predict the class of new data based on past observations.
It is used in image recognition to identify objects in an image.
In natural language processing, it is used to classify text into different categories such as spam or not spam.
Classification is also used in finance to predict the creditworthiness of a borrower.
It is used in biology to cl...read more
Q36. Difference between method overloading and method over riding
Method overloading is having multiple methods with the same name but different parameters. Method overriding is having a method in a subclass with the same name and parameters as a method in the superclass.
Method overloading is used to provide different ways of calling the same method with different parameters.
Method overriding is used to provide a specific implementation of a method in a subclass that is already defined in the superclass.
Method overloading is resolved at com...read more
Q37. how do you configure path externally in spring framework
To configure path externally in Spring Framework, use @PropertySource and @Value annotations.
Use @PropertySource to specify the external properties file
Use @Value to inject the property value into the bean
Example: @PropertySource("classpath:config.properties") @Value("${path}") private String path;
Make sure to include the necessary dependencies in the pom.xml file
Q38. Fetch a list of values from nested objects and find their average using stream api
Use stream API to fetch values from nested objects and find their average
Use flatMap to flatten the nested objects into a single stream
Use mapToInt to extract the values as integers
Use average method to calculate the average of the values
Q39. Which other backend languages I am aware of?
I am aware of Java, Python, C++, and Ruby as backend languages.
Java
Python
C++
Ruby
Q40. Capabilities need to pass for mobile automation
Capabilities needed for mobile automation include knowledge of mobile platforms, programming languages, testing frameworks, and automation tools.
Knowledge of mobile platforms such as iOS and Android
Proficiency in programming languages like Java, Swift, or Kotlin
Familiarity with testing frameworks like Appium or Espresso
Experience with automation tools such as Selenium or UI Automator
Q41. Difference between abstract class and interface.
Abstract class can have implementation while interface cannot. A class can implement multiple interfaces but can only inherit from one abstract class.
Abstract class can have constructors while interface cannot.
Abstract class can have non-abstract methods while interface can only have abstract methods.
Interfaces are used for multiple inheritance while abstract classes are used for single inheritance.
Example of abstract class: public abstract class Animal { public abstract void...read more
Q42. Detail explanation about SMARTFORMS and ADOBE forms.
SMARTFORMS and ADOBE forms are tools used for creating and managing electronic forms.
SMARTFORMS is a tool provided by SAP for creating and maintaining forms in SAP systems.
ADOBE forms are created using Adobe software like Adobe Acrobat or Adobe LiveCycle Designer.
SMARTFORMS are mainly used in SAP systems for generating forms like invoices, purchase orders, etc.
ADOBE forms are more versatile and can be used for creating interactive and dynamic forms with rich media content.
Bot...read more
Q43. Explain ALV reports, Interactive Reports and Module Pool programming.
ALV reports, Interactive Reports, and Module Pool programming are different ways to display data in SAP systems.
ALV reports are used to display data in a tabular format with various functionalities like sorting, filtering, and subtotaling.
Interactive Reports allow users to interact with the data displayed, such as drilling down into details or making changes directly in the report.
Module Pool programming is used to create interactive screens for data entry and display in SAP ...read more
Q44. Any coding snippet to provide solution
Yes, I can provide a coding snippet for the solution.
What is the problem statement?
What programming language is required?
What are the constraints and requirements?
What is the expected output?
Provide a sample input and output.
Q45. How to identify element of app
Identifying elements of an app involves analyzing its components and functionalities.
Examine the user interface to identify buttons, menus, and input fields.
Review the codebase to understand the different modules and classes used.
Utilize debugging tools to inspect the app's behavior and interactions.
Conduct user testing to gather feedback on specific elements.
Document the app's architecture and design to identify key elements.
Q46. What is ABAP (SAP)?
ABAP is a programming language used for developing applications in SAP systems.
ABAP stands for Advanced Business Application Programming.
It is used for developing custom reports, interfaces, and enhancements in SAP systems.
ABAP code runs on the SAP Application Server.
It is an object-oriented language and supports modular programming.
ABAP programs can be developed using the SAP GUI or Eclipse-based ABAP Development Tools.
Examples of ABAP programs include custom reports, data m...read more
Q47. What is SQL Joins? What is Index?
SQL Joins are used to combine data from two or more tables based on a related column.
Joins are used to retrieve data from multiple tables in a single query
Common types of joins are Inner Join, Left Join, Right Join, and Full Outer Join
Indexes are used to improve the performance of database queries by allowing faster data retrieval
Indexes can be created on one or more columns of a table
Examples of indexes include clustered index, non-clustered index, and unique index
Q48. How will you select the unique data in the record
Unique data in a record can be selected by using a combination of data analysis techniques and algorithms.
Identify key fields or attributes that can be used to uniquely identify each record
Use data profiling to understand the distribution of values in the dataset
Implement data cleansing techniques to remove duplicates
Utilize data matching algorithms to identify and select unique records
Consider using machine learning models for record deduplication
Q49. Explain about collection frame work in java? explain about HashSet.
Collection framework in Java provides a set of interfaces and classes to store and manipulate groups of objects. HashSet is a class that implements the Set interface.
HashSet does not allow duplicate elements
Elements are stored in a hash table using their hash codes
HashSet does not maintain insertion order
Example: HashSet
set = new HashSet (); set.add("apple"); set.add("banana");
Q50. How Angular works? Angular Routing SQL query
Angular is a JavaScript framework for building web applications.
Angular uses a component-based architecture to create reusable UI components.
It uses two-way data binding to keep the UI and data in sync.
Angular has a powerful routing system for creating single-page applications.
It can communicate with servers using HTTP requests and observables.
Angular also has a built-in testing framework for unit and integration testing.
Q51. Explain agile development
Agile development is an iterative approach to software development that emphasizes flexibility and collaboration.
Agile development involves breaking down a project into smaller, more manageable chunks called sprints.
Each sprint typically lasts 1-4 weeks and results in a working product increment.
Agile teams prioritize collaboration, communication, and adaptability over rigid processes and documentation.
Agile methodologies include Scrum, Kanban, and Extreme Programming (XP).
Q52. Types of inheritance and their explanation
Types of inheritance include single, multiple, multilevel, hierarchical, hybrid, and multipath inheritance.
Single inheritance involves a child class inheriting from a single parent class.
Multiple inheritance involves a child class inheriting from multiple parent classes.
Multilevel inheritance involves a child class inheriting from a parent class, which in turn inherits from another parent class.
Hierarchical inheritance involves multiple child classes inheriting from a single ...read more
Q53. How do you connect Mysql to your website
Mysql can be connected to a website using PHP or other programming languages.
Install Mysql on the server
Create a database and user in Mysql
Use PHP or other programming languages to connect to the database
Execute queries to retrieve or update data
Close the database connection when finished
Q54. Given a condition for analysing the logic to be used
The question is asking for a logical analysis based on a given condition.
Understand the condition provided and its implications
Identify the key components of the logic to be used
Consider different scenarios and possible outcomes
Use critical thinking and problem-solving skills to analyze the logic
Q55. What is executor service and its types
Executor service is a framework that manages threads and provides an easy way to execute tasks asynchronously.
Executor service is part of the java.util.concurrent package
It provides a way to manage threads and execute tasks asynchronously
Types of executor service include single-threaded, fixed thread pool, cached thread pool, and scheduled thread pool
Example: ExecutorService executor = Executors.newFixedThreadPool(5);
Example: executor.execute(new RunnableTask());
Q56. Difference between delete and drop in sql?
Delete is used to remove rows from a table, while drop is used to remove an entire table from the database.
DELETE is a DML command, while DROP is a DDL command.
DELETE statement is used with a WHERE clause to specify which rows to delete, while DROP statement is used to remove the entire table structure.
DELETE does not remove the table itself, only the rows within it, while DROP removes the table along with all its data and structure.
Q57. Explain oops concepts
OOPs concepts are the principles of Object-Oriented Programming that help in designing and implementing software systems.
Encapsulation: bundling of data and methods that operate on that data
Inheritance: creating new classes from existing ones
Polymorphism: ability of objects to take on multiple forms
Abstraction: hiding implementation details and showing only functionality
Example: A car is an object that encapsulates data like speed and methods like start() and stop()
Example: I...read more
Q58. What is Purpose of itil process
ITIL processes are designed to align IT services with business needs and improve efficiency.
ITIL processes provide a framework for managing IT services
They help to ensure that IT services are aligned with business needs
They improve efficiency and effectiveness of IT operations
Examples of ITIL processes include incident management, change management, and problem management
Q59. Explanation of one of the complex requirements.
Explanation of a complex requirement for a system
Break down the requirement into smaller components
Identify dependencies and constraints
Consider potential risks and challenges
Communicate effectively with stakeholders
Provide detailed documentation
Q60. what is OOPS concept in java?
OOPS concept in Java stands for Object-Oriented Programming System, which is a programming paradigm based on the concept of objects.
OOPS focuses on creating objects that contain both data and methods to manipulate that data.
Key principles of OOPS include Inheritance, Encapsulation, Polymorphism, and Abstraction.
Inheritance allows a class to inherit properties and behavior from another class.
Encapsulation involves bundling data and methods that operate on the data into a singl...read more
Q61. What is OS? How DHCP Works?
OS stands for Operating System. DHCP is a protocol used to assign IP addresses to devices on a network.
OS is the software that manages computer hardware and software resources.
DHCP assigns IP addresses to devices on a network automatically.
DHCP uses a client-server model, where the server assigns IP addresses to clients.
DHCP leases IP addresses to clients for a specific amount of time.
DHCP can also provide other network configuration information, such as DNS server addresses ...read more
Q62. What do you mean by throttling?
Throttling refers to the process of limiting the amount of data or requests that can be sent or received within a certain time frame.
Throttling is used to prevent overload on servers or networks.
It can be implemented through software or hardware.
Examples include API rate limiting and internet service providers limiting bandwidth.
Throttling can also be used to intentionally slow down certain processes or devices.
It is important to balance throttling with user experience and pe...read more
Q63. Write SQL queries
Answering SQL query writing question for Senior Systems Engineer position
Understand the database schema and table relationships
Use SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY clauses
Use JOINs to combine data from multiple tables
Use aggregate functions like COUNT, SUM, AVG, MAX, and MIN
Use subqueries to filter data based on results of another query
Q64. What are collects in java,
Collects in Java are interfaces and classes that provide a framework for working with collections of objects.
Collects provide a way to store and manipulate groups of objects
They include interfaces like List, Set, and Map, and classes like ArrayList and HashMap
Collects offer methods for adding, removing, and accessing elements in the collection
They also provide methods for sorting, searching, and filtering the collection
Examples of usage include storing a list of names, a set ...read more
Q65. Difference between slice and split in Javascript
slice() returns a shallow copy of a portion of an array into a new array, while split() splits a string into an array of substrings based on a specified separator.
slice() does not modify the original array, while split() returns a new array of substrings
slice() can take two parameters for start and end index, while split() takes a separator as a parameter
Example: var arr = [1, 2, 3, 4, 5]; arr.slice(1, 3) returns [2, 3]; 'hello world'.split(' ') returns ['hello', 'world']
Q66. Please describe about architecture of oracle
Oracle architecture is a multi-tiered architecture consisting of client, middle-tier, and database server.
Oracle architecture is based on the client-server model.
The client tier includes the user interface and application logic.
The middle tier includes the application server and web server.
The database server tier includes the Oracle database and related components.
Oracle architecture supports distributed computing and high availability.
Oracle architecture is highly scalable ...read more
Q67. Write a query to find 2nd highest salary.
Query to find 2nd highest salary in a database table.
Use a subquery to select the maximum salary excluding the highest salary
Order the salaries in descending order and limit the result to 1
Q68. Difference between ASP. Net and ASP. Net core
ASP.NET is a framework for building web applications on the .NET platform, while ASP.NET Core is a cross-platform, high-performance framework for building modern, cloud-based, internet-connected applications.
ASP.NET is Windows-only, while ASP.NET Core is cross-platform and can run on Windows, macOS, and Linux.
ASP.NET Core is open-source and modular, allowing developers to include only the necessary components in their applications.
ASP.NET Core has better performance and is op...read more
Q69. What is data binding in angular?
Data binding in Angular is a way to synchronize data between the model and view components.
Data binding allows for automatic updates to the view when the model changes and vice versa.
There are three types of data binding in Angular: Interpolation, Property binding, and Event binding.
Interpolation is used to display data from the component class in the view.
Property binding is used to set a property of a directive or component.
Event binding is used to respond to user events su...read more
Q70. What are the object in C++?
Objects in C++ are instances of classes that encapsulate data and behavior.
Objects are created using the 'new' keyword
They can be passed as arguments to functions
They can be used to access member variables and functions
Objects can be inherited from other classes
Q71. What is the MVC lifecycle?
MVC (Model-View-Controller) lifecycle is a process of handling user requests and generating responses in web applications.
The user sends a request to the controller
The controller receives the request and processes it
The controller updates the model based on the request
The view is updated based on the changes in the model
The updated view is sent back to the user as a response
Q72. What are filters in MVC?
Filters in MVC are used to intercept and modify HTTP requests and responses.
Filters are used to perform pre-processing and post-processing tasks on HTTP requests and responses.
They can be used for authentication, logging, caching, and exception handling.
Examples of filters include Authorization filters, Action filters, Result filters, and Exception filters.
Q73. Difference between BAPI and RFC
BAPI is a business object-oriented interface while RFC is a remote function call.
BAPI is used for business processes while RFC is used for remote communication between systems.
BAPI is a higher level of abstraction than RFC.
BAPIs are implemented as methods of business objects while RFCs are implemented as function modules.
BAPIs have a defined interface while RFCs do not necessarily have a defined interface.
Examples of BAPIs include BAPI_PO_CREATE1 for creating purchase orders ...read more
Q74. Define constructor and types
A constructor is a special method used to initialize objects in a class. There are two types: default and parameterized.
A constructor has the same name as the class it belongs to.
Default constructor is automatically created by the compiler if no constructor is defined.
Parameterized constructor takes arguments and is used to initialize object properties.
Constructors can be overloaded, allowing multiple constructors with different parameters.
Example: class Car { Car() { ... } C...read more
Q75. OOPS concepts with real world examples
OOPS concepts are fundamental principles in object-oriented programming that help in organizing and designing code efficiently.
Encapsulation: Bundling data and methods that operate on the data into a single unit. Example: a car object with properties like color and methods like start() and stop().
Inheritance: Allowing a class to inherit properties and behavior from another class. Example: a class Animal with subclasses like Dog and Cat inheriting common attributes like name a...read more
Q76. write program to find largest number from array
Program to find largest number from array of strings
Convert array of strings to array of integers
Use a loop to iterate through the array and compare each element to find the largest number
Return the largest number found
Q77. What is MVC and MVC life cycle
MVC stands for Model-View-Controller, a software design pattern for organizing code. MVC life cycle involves request handling and response generation.
Model represents the data and business logic
View displays the data to the user
Controller handles user input and updates the model
MVC life cycle involves routing the request to the appropriate controller, processing the request, updating the model, rendering the view, and sending the response
Q78. How to change fsmo roles
To change fsmo roles, use ntdsutil or PowerShell commands.
Open Command Prompt as an administrator
Type ntdsutil and press Enter
Type roles and press Enter
Type connections and press Enter
Type connect to server
and press Enter Type quit and press Enter
Type transfer
and press Enter Type quit and press Enter
Alternatively, use PowerShell commands like Move-ADDirectoryServerOperationMasterRole
Verify the role transfer using netdom query fsmo command
Q79. Real life examples of OOPS concepts
Real life examples of OOPS concepts include inheritance in genetics, encapsulation in security systems, and polymorphism in programming languages.
Inheritance: Genetic traits passed down from parents to offspring.
Encapsulation: Security system where only authorized users can access certain information.
Polymorphism: Overloading a method with different parameters in programming languages.
Q80. What is a proxy server?
A proxy server is an intermediary server between a client and the internet.
It acts as a gateway for requests from clients seeking resources from other servers.
It can be used for caching, filtering, and load balancing.
Examples include Squid, Nginx, and Apache.
It can enhance security by hiding the client's IP address.
Q81. Explain OOPS concept.
OOPS is a programming paradigm based on the concept of objects, which can contain data and code.
OOPS stands for Object-Oriented Programming System
It focuses on creating reusable code and modular programs
It involves the use of classes, objects, encapsulation, inheritance, and polymorphism
Example: A car can be represented as an object with properties like color, model, and methods like start, stop, and accelerate
Q82. What are different recovery models
Different recovery models are used in database management systems to control how transactions are logged and recovered.
Full recovery model: Allows for complete restore of the database to a specific point in time, using transaction log backups.
Simple recovery model: Only allows for full backups and does not support point-in-time recovery.
Bulk-logged recovery model: Minimally logs bulk operations to reduce log space usage.
Q83. Find no of occurrence in string
Count the number of occurrences of a specific substring in a given string.
Use the built-in function or loop through the string to count occurrences.
Consider case sensitivity when counting occurrences.
Example: 'hello hello world'.count('hello') = 2
Q84. What is multi-inheritance?
Multi-inheritance is the ability of a class to inherit properties and behavior from multiple parent classes.
Allows a class to inherit from more than one parent class
Can lead to the diamond problem where two parent classes have a common base class
Supported in some programming languages like C++ and Python
Example: A class can inherit properties from both a 'Vehicle' class and a 'Pet' class
Q85. tell about normalization
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down data into smaller, more manageable parts.
It helps in reducing data redundancy by storing data in a structured manner.
Normalization ensures data integrity by minimizing the chances of inconsistencies.
There are different levels of normalization such as 1NF, 2NF, 3NF, and BCNF.
Example: In a database, instead of storing customer detail...read more
Q86. What is Routing in angular
Routing in Angular is the process of navigating between different components or views in a single-page application.
Routing allows users to move between different parts of an application without reloading the entire page
Routes are defined in the app-routing.module.ts file using the RouterModule.forRoot() method
Each route maps a URL path to a component, which is then displayed when the path is accessed
Route parameters can be used to pass data between components
Angular's router ...read more
Q87. Which language you know?
I know multiple programming languages including Java, Python, and C++.
Proficient in Java, Python, and C++
Familiar with JavaScript, HTML, and CSS
Experience with SQL and NoSQL databases
Comfortable with Linux and Windows environments
Q88. Explain routing in Angular in depth
Routing in Angular is the process of navigating between different components based on the URL.
Angular uses the Angular Router module to handle routing in applications.
Routes are defined in the app-routing.module.ts file using the RouterModule.forRoot() method.
Routes can have path, component, redirectTo, pathMatch, and children properties.
RouterOutlet directive is used in the main app component to display the routed components.
RouterLink directive is used in templates to navig...read more
Q89. Architecture of your application
Our application follows a microservices architecture with containerization using Docker and orchestration with Kubernetes.
Microservices architecture
Containerization with Docker
Orchestration with Kubernetes
Q90. What is OOPS principles
OOPS principles refer to Object-Oriented Programming concepts like Inheritance, Encapsulation, Polymorphism, and Abstraction.
Inheritance: Allows a class to inherit properties and behavior from another class.
Encapsulation: Bundling data and methods that operate on the data into a single unit.
Polymorphism: Ability to present the same interface for different data types.
Abstraction: Hiding the complex implementation details and showing only the necessary features.
Q91. what is aws concepts.
AWS concepts refer to the fundamental principles and components of Amazon Web Services cloud platform.
AWS offers a wide range of cloud services such as computing power, storage options, and networking capabilities.
Key concepts include EC2 (Elastic Compute Cloud), S3 (Simple Storage Service), and VPC (Virtual Private Cloud).
AWS provides scalability, flexibility, and cost-effectiveness for businesses of all sizes.
Understanding AWS concepts is essential for designing, deploying,...read more
Q92. What is agile methodology
Agile methodology is a project management approach that emphasizes flexibility, collaboration, and incremental progress.
Agile methodology involves breaking down projects into smaller tasks or iterations
It prioritizes customer collaboration and responding to change over following a strict plan
Common practices in agile include daily stand-up meetings, sprint planning, and retrospectives
Examples of agile frameworks include Scrum, Kanban, and Extreme Programming
Q93. Coding of sorting techniques
Sorting techniques are essential for efficient data processing and retrieval.
Sorting algorithms can be classified as comparison-based or non-comparison-based.
Some popular comparison-based sorting algorithms are bubble sort, insertion sort, selection sort, merge sort, quicksort, and heapsort.
Non-comparison-based sorting algorithms include counting sort, radix sort, and bucket sort.
The choice of sorting algorithm depends on the size of the data set, the distribution of the data...read more
Q94. Explain Views.
Views are virtual tables that display data from one or more tables in a database.
Views are created using SELECT statements.
They can be used to simplify complex queries.
They can also be used to restrict access to sensitive data.
Views do not store data themselves, but rather display data from underlying tables.
Changes made to the underlying tables are reflected in the view.
Q95. What is inheritance in java
Inheritance is a mechanism in Java where one class acquires the properties and behaviors of another class.
Allows code reuse and saves time
Parent class is called super class and child class is called sub class
Sub class inherits all the non-private members of super class
Can override methods in super class
Example: class Car extends Vehicle
Q96. What are Oops concepts
Oops concepts refer to Object-Oriented Programming principles such as Inheritance, Encapsulation, Polymorphism, and Abstraction.
Inheritance: Allows a class to inherit properties and behavior from another class.
Encapsulation: Bundling data and methods that operate on the data into a single unit.
Polymorphism: Ability to present the same interface for different data types.
Abstraction: Hiding the complex implementation details and showing only the necessary features.
Q97. Difference between ArrayList and HashMap
ArrayList is a resizable array implementation while HashMap is a key-value pair storage with constant time complexity for basic operations.
ArrayList stores elements in an ordered sequence and allows duplicate values.
HashMap stores key-value pairs and does not allow duplicate keys.
Accessing elements in ArrayList is done by index, while accessing elements in HashMap is done by key.
ArrayList is not synchronized by default, while HashMap is not thread-safe.
Example: ArrayList
list...read more
Q98. What is oracke ebs finance
Oracle EBS Finance is a module within Oracle E-Business Suite that focuses on financial management and accounting.
Oracle EBS Finance helps organizations manage their financial processes, including accounts payable, accounts receivable, general ledger, and financial reporting.
It allows for automation of financial tasks, streamlining processes and improving accuracy.
Users can generate financial statements, track expenses, and manage budgets within the module.
Oracle EBS Finance ...read more
Q99. Explains Software Deployment Life Cycle.
Software Deployment Life Cycle involves planning, testing, deploying, and maintaining software.
Planning: Define deployment goals and requirements.
Testing: Ensure software is stable and meets requirements.
Deployment: Roll out software to users.
Maintenance: Update and support software post-deployment.
Q100. What are design patterns?
Design patterns are reusable solutions to common software design problems.
Design patterns provide a common language for developers to communicate about solutions to common problems.
They can improve the efficiency, maintainability, and scalability of software systems.
Examples include the Singleton pattern, Factory pattern, and Observer pattern.
Design patterns can be categorized into three groups: creational, structural, and behavioral patterns.
Top HR Questions asked in null
Interview Process at null
Top Senior Systems Engineer Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month