
Infosys

4000+ Infosys Interview Questions and Answers
Q101. What is difference between procedural programming language and object oriented programming language ?
Procedural programming focuses on procedures and functions while object-oriented programming focuses on objects and classes.
Procedural programming is based on top-down approach while object-oriented programming is based on bottom-up approach.
Procedural programming is more suitable for small programs while object-oriented programming is more suitable for large programs.
Procedural programming is less secure while object-oriented programming is more secure.
Examples of procedural...read more
Q102. You have to take responsibility of the parking section of an event which has 500 cars. How will you manage the task given to you?
I will manage the parking section of the event by implementing a systematic approach and utilizing technology.
Create a parking plan and layout to efficiently accommodate 500 cars.
Assign dedicated parking spots for VIPs, disabled individuals, and event staff.
Implement a ticketing system or RFID technology to track and manage parking spaces.
Deploy parking attendants to guide drivers and ensure smooth traffic flow.
Utilize digital signage or mobile apps to provide real-time parki...read more
User threads are non-daemon threads that keep the program running until they complete, while Daemon threads are background threads that do not prevent the program from exiting.
User threads are non-daemon threads that keep the program running until they complete
Daemon threads are background threads that do not prevent the program from exiting
User threads are created using the Thread class, while Daemon threads are created by calling setDaemon(true) on a Thread object
Examples: ...read more
Q104. Explain about basic gating logic 'And' 'Or' 'Nand' 'Nor'? How to build Nand from other gates?
Basic gating logic includes And, Or, Nand, and Nor gates. Nand gate can be built using other gates.
And gate outputs true only when all inputs are true.
Or gate outputs true when at least one input is true.
Nand gate outputs the negation of the And gate.
Nor gate outputs the negation of the Or gate.
Nand gate can be built by combining an And gate followed by a Not gate.
Q105. Rearrange the Array Problem Statement
You are given an array/list NUM
of integers. Your task is to rearrange the elements of NUM
such that no two adjacent elements are the same, or determine if it is not possib...read more
The task is to rearrange an array such that no two adjacent elements are the same.
Iterate through the array and check if any adjacent elements are the same
If adjacent elements are the same, swap one of them with a different element
Repeat the process until all adjacent elements are different
Q106. Shortest Path in an Unweighted Graph
The city of Ninjaland is represented as an unweighted graph with houses and roads. There are 'N' houses numbered 1 to 'N', connected by 'M' bidirectional roads. A road conne...read more
The task is to find the shortest path from a starting house to a destination house in an unweighted graph representing a city.
Implement a function to find the shortest path from house 'S' to house 'T' in an unweighted graph.
Use a graph traversal algorithm like Breadth First Search (BFS) to find the shortest path.
Return a list of house numbers indicating the shortest path from 'S' to 'T'.
Check if the output path is valid and return 'Correct' if valid, otherwise 'Incorrect'.
Q107. Reverse Linked List Problem Statement
Given a Singly Linked List of integers, your task is to reverse the Linked List by altering the links between the nodes.
Input:
The first line of input is an integer T, rep...read more
Reverse a singly linked list by altering the links between nodes.
Iterate through the linked list and reverse the links between nodes
Use three pointers to keep track of the current, previous, and next nodes
Update the links between nodes to reverse the list
Return the head of the reversed linked list
Enable debugging logs in a Spring Boot application
Add 'logging.level.root=DEBUG' in application.properties file
Use '@Slf4j' annotation in the Java class to enable logging
Set logging level for specific packages or classes using 'logging.level.packageName=DEBUG'
Q109. As I am Non CS, why are you switching from Non IT to IT Industry?
I am passionate about technology and have always been interested in IT. I believe my skills and experience can be better utilized in the IT industry.
I have always had a strong interest in technology and IT
I enjoy problem-solving and working with computers
I believe my skills and experience align well with the demands of the IT industry
Q110. 1. Find the first occurrence of the target value in a sorted array. (Duplicates are allowed)
Find the first occurrence of target value in a sorted array with duplicates.
Use binary search to find the target value.
If found, check if the previous element is also the target value.
If not, return the index of the target value.
If yes, continue binary search on the left subarray.
Q111. return deliveries to vendor with reference to returns PO
To return deliveries to a vendor with reference to returns PO in SAP MM, follow these steps:
Create a returns purchase order (PO) referencing the original purchase order
Create a return delivery using transaction code VL10B
Enter the returns PO number as a reference in the return delivery
Post the return delivery to complete the process
The @SpringBootApplication annotation is used to mark a class as a Spring Boot application and enables auto-configuration and component scanning.
Enables auto-configuration by scanning the classpath for specific types and configuring beans based on their presence.
Enables component scanning to automatically discover and register Spring components such as @Component, @Service, @Repository, and @Controller.
Combines @Configuration, @EnableAutoConfiguration, and @ComponentScan anno...read more
Q113. How to create a Repository file/YUM client Configuration?
To create a Repository file/YUM client Configuration, follow these steps:
Create a new repository file in the /etc/yum.repos.d/ directory
Specify the repository name, base URL, enabled status, and other options in the file
Save the file and exit the editor
Run 'yum clean all' command to clear the cache
Run 'yum repolist' command to verify the repository configuration
DELETE removes specific rows from a table, while TRUNCATE removes all rows and resets auto-increment values.
DELETE is a DML command, while TRUNCATE is a DDL command.
DELETE can be rolled back, while TRUNCATE cannot be rolled back.
DELETE triggers ON DELETE triggers, while TRUNCATE does not trigger any triggers.
DELETE is slower as it maintains logs, while TRUNCATE is faster as it does not maintain logs.
Q115. How can you ease human life using machine learning or any other technology?
Machine learning can ease human life by automating tasks, improving healthcare, and enhancing personalization.
Automating repetitive tasks can save time and increase efficiency
Machine learning can improve healthcare by predicting diseases and identifying effective treatments
Personalization can be enhanced through recommendation systems and targeted advertising
Natural language processing can improve communication and accessibility for individuals with disabilities
Q116. 4.How to communicate between two rest API and how to implement security for rest API?
To communicate between two REST APIs, use HTTP requests and implement security measures such as authentication and encryption.
Use HTTP requests such as GET, POST, PUT, and DELETE to communicate between two REST APIs
Implement authentication measures such as OAuth or API keys to ensure secure communication
Use encryption techniques such as SSL or TLS to protect sensitive data during transmission
Consider using a message broker such as RabbitMQ or Kafka for asynchronous communicat...read more
Q117. What comes under assets and liabilities.
Assets are resources owned by a company while liabilities are obligations or debts owed by a company.
Assets include cash, accounts receivable, inventory, property, and equipment.
Liabilities include accounts payable, loans, and accrued expenses.
Assets are listed on the left side of the balance sheet while liabilities are listed on the right side.
The difference between assets and liabilities is known as equity or net worth.
Q118. Which language do you use in programming?
I primarily use Python for programming.
Python is versatile and easy to read, making it great for system engineering tasks.
I also have experience with languages like Java, C++, and Bash scripting.
Python's extensive libraries and frameworks make it ideal for automation and scripting tasks.
Q119. What is call by reference and why is it different from call by value?
Call by reference passes the memory address of a variable, while call by value passes a copy of the variable's value.
Call by reference allows the function to modify the original variable
Call by value does not affect the original variable
Example: int x = 5; function(x); //call by reference modifies x
Example: int y = 10; function(y); //call by value does not modify y
Runnable interface is used for running a task without returning a result, while Callable interface is used for running a task that returns a result and can throw an exception.
Runnable interface has a run() method that does not return a result.
Callable interface has a call() method that returns a result and can throw an exception.
Runnable tasks can be submitted to an ExecutorService for execution.
Callable tasks can be submitted to an ExecutorService as well, but they return a ...read more
Q121. What is DBMS.Difference between drop , delete and truncate in dbms
Drop, delete and truncate are SQL commands used to remove data from a database.
DROP command removes a table from the database
DELETE command removes specific rows from a table
TRUNCATE command removes all rows from a table
DROP and TRUNCATE are DDL commands while DELETE is a DML command
DROP and TRUNCATE cannot be rolled back while DELETE can be rolled back
Q122. what do you know about latest technologi in market,have you any idea about AI(Artificial Intelligence), tell me about about AI and where AI used
AI is a technology that enables machines to learn from experience and perform tasks that typically require human intelligence.
AI is used in various industries such as healthcare, finance, and transportation
AI can be used for natural language processing, image recognition, and predictive analytics
Examples of AI include virtual assistants like Siri and Alexa, self-driving cars, and fraud detection systems
AI has the potential to revolutionize industries and improve efficiency an...read more
MVC components include Model, View, and Controller. Model represents data, View displays data, and Controller handles user input.
Model: Represents data and business logic
View: Displays data to the user
Controller: Handles user input and updates the model and view accordingly
Q124. 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
Q125. Which is your favorite language? (c, c++,Java) how you will rate them out of 10?
My favorite language is Java and I would rate it 9 out of 10.
I prefer Java because of its platform independence and vast community support.
C and C++ are also good languages but require more attention to memory management.
Java's object-oriented approach and extensive libraries make it a versatile language.
Example: I have developed a web application using Java Spring framework.
Example: I have also worked on C++ projects for embedded systems.
Q126. What is exception Handling? And what is try, catch and throw?
Exception handling is a way to handle errors and unexpected events in a program.
Try block contains the code that might throw an exception
Catch block catches the exception thrown by the try block
Throw keyword is used to explicitly throw an exception
Exception handling helps in preventing program crashes and provides a way to gracefully handle errors
Example: try { //code that might throw an exception } catch (Exception e) { //code to handle the exception }
Q127. What are best practices to write trigger? What are execution order in salesforce? What are deployment techniques used in salesforce? What is min code coverage required while deployment? What is azure dev ops?
Best practices for writing triggers, execution order, deployment techniques, code coverage, and Azure DevOps.
Use trigger framework to avoid code duplication
Bulkify triggers to handle large data sets
Follow trigger order of execution
Use metadata API or change sets for deployment
Minimum code coverage is 75%
Azure DevOps is a cloud-based tool for managing software development projects
Q128. What software you can make from c language?
C language can be used to develop various software applications.
Operating systems like Unix, Linux, and Windows are written in C
Database systems like MySQL and PostgreSQL are written in C
Networking protocols like TCP/IP are implemented in C
Graphics and game engines like OpenGL and Unity are written in C
System utilities like compilers, debuggers, and interpreters are written in C
Q129. MergeSort Linked List Problem Statement
Sort a given singly linked list of integers using the 'Merge Sort' algorithm.
Input:
The first and only line of input contains the elements of the linked list separated b...read more
MergeSort algorithm is used to sort a singly linked list of integers in ascending order.
Implement the MergeSort algorithm to recursively divide the linked list into two halves, sort them, and then merge them back together.
Use a slow and fast pointer technique to find the middle of the linked list for splitting.
Ensure to handle the base cases of empty list or single node list.
Example: For input '10 3 5 -1', the output should be '3 5 10'.
Q130. Explain Oop concepts with examples ,what is static variable, conditions operator, arithmetic operator
OOP concepts include encapsulation, inheritance, polymorphism, and abstraction. Static variables are shared among all instances of a class.
Encapsulation: Bundling data and methods that operate on the data into a single unit (class)
Inheritance: Allowing a class to inherit properties and behavior from another class
Polymorphism: Ability for objects to be treated as instances of their parent class
Abstraction: Hiding the implementation details and showing only the necessary featur...read more
Q131. 1) Tell me about yourself 2) Different types Databases 3) Components Of web app 4) Program life cycle of CPP
Interview questions for System Engineer
Different types of databases include relational, NoSQL, graph, and document
Components of a web app include client-side scripting, server-side scripting, and database technology
Program life cycle of CPP includes editing, preprocessing, compiling, linking, and executing
Q132. Difference Between Comparator and Comparable. What is fully qualified domain name? What is the working principle for an ArrayList? How do you handle an exception? What is custom exception? What is the differenc...
read moreComparator is used to compare objects for sorting, while Comparable is implemented by objects to define their natural ordering.
Comparator is an external class, while Comparable is implemented by the object itself.
Comparator can compare objects of different classes, while Comparable can only compare objects of the same class.
Comparator uses the compare() method, while Comparable uses the compareTo() method.
Q133. If neither the port range in source NAT pools nor the default port range are configured, the default single port range is 1024 through 63,487.
Default single port range when neither port range in source NAT pools nor default port range are configured.
When neither port range in source NAT pools nor default port range are configured, the default single port range is 1024 through 63,487.
This range is used for outbound traffic initiated by the device.
It is important to configure the port range to avoid conflicts with other devices on the network.
For example, if multiple devices are using the same default port range, it ...read more
Q134. M-Coloring Problem Statement
Given an undirected graph as an adjacency matrix and an integer M
, determine whether you can color the vertices of the graph using at most M
colors such that no two adjacent vertice...read more
The M-Coloring problem involves coloring the vertices of a graph using at most M colors such that no two adjacent vertices share the same color.
Check if the graph can be colored using at most M colors without adjacent vertices sharing the same color.
Use backtracking or graph coloring algorithms to solve the problem efficiently.
Ensure that the number of colors used is less than or equal to M.
Consider constraints such as the number of test cases, vertices, and colors.
Provide a ...read more
Q135. What are the data structures you know and diff between tree and graph.
Data structures: trees and graphs. Difference between them.
Trees are a type of graph with a hierarchical structure
Graphs are a collection of nodes and edges that can be connected in any way
Trees have a single root node and each node has at most one parent
Graphs can have multiple disconnected components
Trees are used for hierarchical data like file systems, organization charts
Graphs are used for modeling relationships between objects like social networks, road networks
Q136. Which programming languages you are familiar with?
I am familiar with multiple programming languages.
I am proficient in Java and Python.
I have experience with C++, JavaScript, and SQL.
I am also familiar with HTML and CSS for web development.
I am constantly learning and expanding my knowledge of new languages and technologies.
Q137. How do you call a controllor method from javascript in visualforce page?
To call a controller method from JavaScript in a Visualforce page, use the actionFunction tag.
Create a controller method in the Apex class.
Add an actionFunction tag in the Visualforce page.
Call the actionFunction from JavaScript using its name.
Pass parameters to the controller method using the actionFunction tag.
Use the rerender attribute to update the page after the controller method is called.
Q138. How do load both parent and child records at a time using data loader?
Use data loader's parent-child functionality to load both parent and child records at once.
Create a CSV file with both parent and child records
Use the data loader's parent-child functionality to map the relationship between the two
Ensure that the parent records are loaded before the child records
Use the data loader's insert or upsert operation to load the data
Q139. 1)Explain project 2)what is constructor 3)what multiple inheritance 4) what is access modifier
Interview questions for System Engineer position
Project is a temporary endeavor to create a unique product or service
Constructor is a special method used to initialize objects
Multiple inheritance is the ability of a class to inherit properties and behavior from multiple parent classes
Access modifier is a keyword that determines the visibility and accessibility of a class, method, or variable
Q140. What is ledger. And how many types in there
A ledger is a book or computer program used to record financial transactions. There are two types of ledgers: general and subsidiary.
A ledger is used to keep track of financial transactions.
It can be in the form of a physical book or a computer program.
There are two types of ledgers: general and subsidiary.
The general ledger contains all the financial transactions of a company.
The subsidiary ledger contains specific accounts, such as accounts receivable or accounts payable.
Dangling pointer points to memory that has been deallocated, while void pointer is a pointer that has no specific data type.
Dangling pointer occurs when a pointer points to memory that has been freed or deleted.
Void pointer is a pointer that can point to any data type.
Example: int *ptr = NULL; ptr = malloc(sizeof(int)); free(ptr); // ptr is now a dangling pointer
Example: void *ptr; int num = 10; ptr = # // ptr is a void pointer pointing to an integer
Q142. What is the difference between scrum master and product manager
Scrum Master focuses on facilitating the scrum process while Product Manager focuses on product development.
Scrum Master is responsible for ensuring the scrum process is followed and removing any obstacles that may hinder the team's progress.
Product Manager is responsible for developing the product roadmap, defining product features, and ensuring the product meets customer needs.
Scrum Master is a facilitator while Product Manager is a decision-maker.
Scrum Master works closely...read more
Q143. Give the logic to write a program to find all the prime numbers between any two given numbers.
Program to find all prime numbers between two given numbers.
Take input of two numbers from user
Loop through the range of numbers between the two given numbers
Check if each number is prime or not
Print all the prime numbers found
Q144. What all geographies have you worked upon? What is the key difference between the client from APAC, AMER, and ASGR?
I have worked in APAC, AMER, and ASGR geographies.
APAC stands for Asia-Pacific and includes countries like China, Japan, India, and Australia.
AMER stands for Americas and includes countries like the United States, Canada, and Brazil.
ASGR stands for Europe, Middle East, and Africa and includes countries like the United Kingdom, Germany, and South Africa.
The key difference between clients from these geographies is their cultural, business, and regulatory environments.
APAC clien...read more
Q145. Why can't I use an assignment in an expression?
Assignments do not return a value and cannot be used in expressions.
Assignments are used to store a value in a variable, but they do not return a value that can be used in an expression.
Expressions are used to evaluate a value, but an assignment does not evaluate to a value.
For example, you cannot use an assignment in a conditional statement like if(x = 5), as it will always evaluate to true.
Q146. What is the difference between do-while, while, for loop?
do-while, while, and for loops are used for iteration in programming, but differ in their syntax and conditions.
while loop checks the condition before executing the code block
do-while loop executes the code block once before checking the condition
for loop is used for iterating over a sequence of values
for loop has three parts: initialization, condition, and increment/decrement
Example: while(i < 10){...}, do{...}while(i < 10), for(i=0; i<10; i++){...}
Q147. What is truncate and delete command?
Truncate and delete are SQL commands used to remove data from a table.
Truncate removes all data from a table and resets the identity column
Delete removes specific rows from a table based on a condition
Truncate is faster than delete as it doesn't log individual row deletions
Delete can be rolled back, but truncate cannot
Example: TRUNCATE TABLE myTable; DELETE FROM myTable WHERE id = 1;
Q148. What is Oops and Explain the Four Pillars?
Oops stands for Object-Oriented Programming System. The four pillars are Inheritance, Encapsulation, Abstraction, and Polymorphism.
Oops stands for Object-Oriented Programming System
The four pillars are Inheritance, Encapsulation, Abstraction, and Polymorphism
Inheritance allows a class to inherit properties and behavior from another class
Encapsulation refers to the bundling of data with the methods that operate on that data
Abstraction focuses on hiding the implementation detai...read more
Q149. Technical questions:1)difference between definition and initialization.2)what is recursion function
Answering technical questions on definition, initialization, and recursion function.
Definition is the act of declaring a variable, while initialization is the act of assigning a value to that variable.
Recursion function is a function that calls itself until a base condition is met.
Example of definition: int x;
Example of initialization: int x = 5;
Example of recursion function: int factorial(int n) { if (n == 0) return 1; else return n * factorial(n-1); }
Q150. Palindrome Partitioning Problem Statement
You are given a string S
. Your task is to partition S
such that every substring of the partition is a palindrome. Your objective is to return all possible palindrome pa...read more
Partition a string into palindromes
Use backtracking to generate all possible palindrome partitions
Check if each substring is a palindrome before adding to the partition
Return all valid partitions as an array of strings
Q151. What is Amazon Web services how do you use cloud computing in daily life
Amazon Web Services (AWS) is a cloud computing platform that provides a wide range of services to individuals and businesses.
AWS offers services such as computing, storage, databases, and analytics.
Cloud computing allows for easy access to data and applications from anywhere with an internet connection.
AWS can be used for personal storage, website hosting, and business operations.
Examples of AWS services include Amazon S3 for storage, Amazon EC2 for computing, and Amazon RDS ...read more
Q152. Any Situation : Ex: One small island,only one person,island is full of dry grass and it is firing,then how he will escape
The person can escape the island by creating a firebreak or finding a body of water.
Create a firebreak by clearing a path of grass around oneself to prevent the fire from spreading.
Look for a body of water such as a lake, river, or ocean to escape the fire.
If no water source is available, try to find a sheltered area with less dry grass to wait for the fire to pass.
Use any available tools or materials to help create a firebreak or signal for help.
A View is a complete page while a Partial View is a reusable component in MVC.
A View represents a complete page in MVC which can include layout, content, and other views.
A Partial View is a reusable component that can be rendered within a View or another Partial View.
Partial Views are useful for creating modular and reusable components in MVC applications.
Example: A View may contain the overall layout of a website, while a Partial View may represent a sidebar or a navigation ...read more
Q154. 2. What is the difference between checked and unchecked exceptions and state their examples?
Checked and unchecked exceptions differ in their handling and requirement for try-catch blocks.
Checked exceptions are checked at compile time and require handling in a try-catch block.
Unchecked exceptions are not checked at compile time and do not require handling.
Examples of checked exceptions include IOException and SQLException.
Examples of unchecked exceptions include NullPointerException and ArrayIndexOutOfBoundsException.
Q155. What is the first thing you'll consider while starting statutory audit?
The first thing to consider while starting statutory audit is understanding the client's business and industry.
Understand the client's business and industry
Identify the key risks and controls
Assess the materiality of the financial statements
Plan the audit approach and procedures
Consider any regulatory requirements or changes
Review prior year's audit work
Communicate with the client and their management team
Session interface in Hibernate is used to create, read, update, and delete persistent objects.
Session interface is used to interact with the database in Hibernate.
It represents a single-threaded unit of work.
It provides methods for CRUD operations like save, update, delete, and get.
Session is created using SessionFactory object.
Example: Session session = sessionFactory.openSession();
Q157. Why do we need normalization in DBMS? What are its advantages and disadvantages?
Normalization in DBMS is important to reduce data redundancy and improve data integrity.
Normalization helps in organizing data in a structured manner.
It reduces data redundancy and improves data integrity.
It helps in efficient storage and retrieval of data.
Normalization can also help in avoiding update anomalies.
However, over-normalization can lead to complex queries and slower performance.
Q158. What is VLAN, VTP, which VTP mode is normally used in switches, STP, OSPF states, Ip classes and range, importance of subnetting, NAT, classification of cisco routers and few troubleshooting questions. f5 load...
read moreAnswering questions related to VLAN, VTP, STP, OSPF, IP classes and range, subnetting, NAT, Cisco routers, and F5 load balancer.
VLAN is a virtual LAN that allows network administrators to group devices together based on their function or team.
VTP is VLAN Trunking Protocol that manages VLAN configuration consistency across a network.
Server mode is normally used in switches for VTP.
STP is Spanning Tree Protocol that prevents network loops by blocking redundant paths.
OSPF states...read more
Q159. How would you create a spring boot application from scratch for web and database operations.write steps one by one
Creating a Spring Boot application for web and database operations
Create a new Spring Boot project using Spring Initializr
Add necessary dependencies for web and database operations in pom.xml
Create a database schema and configure database connection in application.properties
Create entity classes and corresponding repositories
Create REST controllers for web operations
Test the application using Postman or any other REST client
Q160. How much year experience and tell me the how to maintain the site electrical equipment, like DG, Transformer, Ups, LT & HT panel.
To maintain site electrical equipment like DG, Transformer, Ups, LT & HT panel, I have 5 years of experience.
Regularly inspect and clean the equipment to ensure proper functioning.
Perform preventive maintenance tasks such as lubrication, tightening connections, and checking for any signs of wear or damage.
Conduct regular testing and calibration of equipment to ensure accuracy and efficiency.
Monitor and record equipment performance, noting any abnormalities or deviations.
Troub...read more
Q161. One of the pseudocodes that came was this: #include int main() { int a = 100; printf("%0 %x", a); } Find the output.
This question tests the candidate's knowledge of C programming language and output formatting.
The code initializes an integer variable 'a' with value 100.
The printf statement uses two format specifiers: '%0' and '%x'.
The '%0' specifier is invalid and will not print anything.
The '%x' specifier prints the value of 'a' in hexadecimal format.
The output will be '64' in hexadecimal format.
Q162. how does an aeroplane flies?what is the mechanism etc
An airplane flies by generating lift through its wings and using engines to propel it forward.
Airplane wings are designed to create lift by creating a difference in air pressure above and below the wing.
The engines provide the necessary thrust to move the airplane forward and maintain its speed.
The pilot controls the airplane's altitude and direction by adjusting the angle of the wings and the amount of thrust from the engines.
The airplane's weight and the air resistance it e...read more
Q163. What is the resource database and system database in sql server
The resource database is a read-only system database that stores system objects and metadata for SQL Server. System databases are essential for the functioning of SQL Server.
The resource database is hidden and cannot be accessed directly by users or administrators.
It contains all the system objects that are included with SQL Server, such as system views and stored procedures.
The resource database is used to upgrade system objects when applying SQL Server updates or service pa...read more
Q164. Differentiate between C++ and Java? What are programming principles and pointers
C++ is a compiled language with pointers, while Java is interpreted with garbage collection.
C++ is faster and more efficient than Java due to its compiled nature.
Java is more secure and portable than C++ due to its interpreted nature.
C++ uses pointers to directly access memory, while Java uses references to objects.
Programming principles include encapsulation, inheritance, and polymorphism.
Pointers are variables that store memory addresses, used for direct memory access and m...read more
Standard Java pre-defined functional interfaces include Function, Consumer, Predicate, Supplier, etc.
Function: Represents a function that accepts one argument and produces a result. Example: Function<Integer, String>
Consumer: Represents an operation that accepts a single input argument and returns no result. Example: Consumer<String>
Predicate: Represents a predicate (boolean-valued function) of one argument. Example: Predicate<Integer>
Supplier: Represents a supplier of result...read more
Q166. What is control structures? What is loops? What is for loop?
Control structures are used to control the flow of a program. Loops are a type of control structure that allow for repeated execution of code.
Control structures are used to make decisions and control the flow of a program.
Loops are a type of control structure that allow for repeated execution of code.
A for loop is a type of loop that is used to iterate over a sequence of values.
For example, a for loop can be used to iterate over the elements of an array or the characters in a...read more
Q167. Python what type of language? Fathor of python?
Python is a high-level, interpreted, and general-purpose programming language. Guido van Rossum is the creator of Python.
Python is a high-level language, meaning it provides a level of abstraction from the hardware.
It is an interpreted language, which means it does not need to be compiled before running.
Python is a general-purpose language, suitable for various applications such as web development, data analysis, and automation.
Guido van Rossum, a Dutch programmer, is known a...read more
Q168. Write a program for prime numbers and what DML and DDL comments
Program to find prime numbers with DML and DDL comments
Create a program that checks if a number is prime or not
Use a loop to iterate through numbers and check for divisibility
Add DML comments to explain the logic of the code
Add DDL comments to describe the structure of the program
Q169. What is polymorphism. What are spring annotations. What functions are used in web services. How hashmap works.
Polymorphism is the ability of an object to take on many forms. Spring annotations are used to simplify the configuration of Spring applications. Web services use functions like GET, POST, PUT, and DELETE. Hashmap is a data structure that stores key-value pairs.
Polymorphism allows objects to be treated as instances of their own class or as instances of their parent class.
Spring annotations are used to define the behavior of Spring components and simplify the configuration pro...read more
Q170. What coding language do you know?
I know multiple coding languages including Java, Python, and C++.
Java
Python
C++
Q171. An example of end to end interface scenario implemented by you in your project
Implemented an end to end interface scenario for order to cash process
Created a sales order in SAP ECC system
Sent the sales order to SAP PI system using IDoc
Transformed the IDoc to XML format using SAP PI mapping
Sent the XML message to third-party system using SOAP adapter
Received the response message from third-party system
Transformed the response message to IDoc format using SAP PI mapping
Sent the IDoc back to SAP ECC system
Verified the sales order status in SAP ECC system
Q172. 6) what are different data types, Variables. For loop, While loop.
Data types include integers, floats, strings, and booleans. Variables store data. For loops iterate a set number of times. While loops iterate until a condition is met.
Data types include int, float, string, and bool
Variables store data and can be assigned values
For loops iterate a set number of times based on a range or sequence
While loops iterate until a condition is met
Example: int x = 5; float y = 3.14; string name = 'John'; bool isTrue = true;
Q173. What is Exception handling and difference between throw and throws keyword
Exception handling is a mechanism to handle runtime errors. throw is used to throw an exception while throws is used to declare an exception.
Exception handling is used to handle runtime errors and prevent the program from crashing.
throw keyword is used to throw an exception explicitly.
throws keyword is used to declare an exception that can be thrown by a method.
throw keyword is used inside a method while throws keyword is used in the method signature.
Example: public void meth...read more
Q174. Computer science have how many languages?
Computer science has numerous programming languages.
There are over 700 programming languages in use today.
Some popular languages include Java, Python, C++, and JavaScript.
Languages can be categorized as low-level, high-level, or scripting languages.
Each language has its own syntax, rules, and purpose.
New languages are constantly being developed to meet evolving needs.
Q175. OOPS concepts. What is are the different access modifiers with examples? Explain your project. And more, I don't remember rest.
Access modifiers in OOPS and project explanation
Access modifiers control the visibility of class members
Public: accessible from anywhere
Private: accessible only within the class
Protected: accessible within the class and its subclasses
Project: accessible within the same package
Example: public class Car { private int speed; protected String model; }
My project involved developing a web application for managing inventory
Used Java, Spring framework, and MySQL database
Implemented C...read more
Q176. What is oops? What is polymorphism? and types. What is Abstraction ? explain SDLC? What is DBMS? diff b/w truncate, delete and drop. What is Join? types And general HR questions
Answers to technical and HR questions for System Engineer interview
OOPs stands for Object-Oriented Programming which is a programming paradigm based on the concept of objects
Polymorphism is the ability of an object to take on many forms. There are two types of polymorphism: compile-time and runtime
Abstraction is the process of hiding implementation details while showing only the necessary information to the user
SDLC stands for Software Development Life Cycle which is a proces...read more
Q177. How do you get data integrity between source and destination, how you perform loading technique.
Data integrity is ensured through ETL testing and loading techniques.
Perform ETL testing to ensure data accuracy and completeness.
Use data profiling to identify data quality issues.
Perform data mapping to ensure correct data transfer.
Use checksums to verify data integrity.
Perform data validation to ensure data consistency.
Use error handling and logging to track and resolve issues.
Use incremental loading to improve performance and reduce errors.
Q178. Does java use call by value or call be reference?
Java uses call by value.
Java passes a copy of the value of a variable to a method, not the actual variable itself.
Changes made to the parameter inside the method have no effect on the original variable.
However, if the parameter is an object reference, the reference is passed by value, so changes to the object itself will be reflected outside the method.
Q179. what do you think of data science and its future
Data science is a rapidly growing field that uses algorithms and techniques to extract insights and knowledge from data.
Data science involves analyzing large amounts of data to uncover patterns, trends, and insights.
It plays a crucial role in decision-making processes for businesses, governments, and organizations.
Data science uses a combination of statistics, machine learning, and programming to make sense of complex data sets.
The future of data science looks promising with ...read more
Q180. What is database Types of database Breaks What is array Oops concepts Inheritance Polymorphism etc
A database is a collection of data that is organized in a way that allows for easy retrieval and manipulation.
Types of databases include relational, NoSQL, object-oriented, and graph databases.
Arrays are a data structure that stores a collection of elements of the same type.
Object-oriented programming concepts include inheritance, polymorphism, and encapsulation.
Inheritance allows for the creation of new classes based on existing classes.
Polymorphism allows for the use of a s...read more
Q181. What are the key tools that are used for an effective transition
The key tools for an effective transition include project management software, communication tools, documentation templates, and training materials.
Project management software helps in planning, organizing, and tracking the transition process.
Communication tools like email, instant messaging, and video conferencing facilitate effective communication between team members and stakeholders.
Documentation templates provide a standardized format for capturing transition plans, proc...read more
Q182. What is the SQL query to retrieve the person with the highest salary?
Use SQL query with MAX function to retrieve person with highest salary.
Use SELECT statement to retrieve data
Use MAX function to find the highest salary
Use WHERE clause to filter out the person with highest salary
Q183. How to copy files from 1 folder to other
To copy files from one folder to another, use the copy command in the command prompt or drag and drop the files.
Open the source folder and the destination folder in separate windows
Select the files you want to copy in the source folder
Right-click on the selected files and click on 'Copy' or use the 'Ctrl+C' shortcut
Go to the destination folder and right-click on an empty space
Click on 'Paste' or use the 'Ctrl+V' shortcut
Alternatively, open the command prompt and use the 'copy...read more
Q184. Why java language is platform-independent?
Java is platform-independent due to its bytecode and virtual machine architecture.
Java code is compiled into bytecode, which can run on any platform with a Java Virtual Machine (JVM).
JVM acts as an interpreter, translating bytecode into machine code specific to the platform it is running on.
This allows Java programs to be written once and run on any platform with a JVM installed.
For example, a Java program written on a Windows machine can run on a Linux machine without any mo...read more
Q185. What should be the Test cases of a Music Player?
Test cases for a Music Player
Test playback of different file formats
Test volume control functionality
Test shuffle and repeat options
Test playlist creation and management
Test search functionality
Test interruption handling (e.g. phone call)
Test compatibility with different headphones/speakers
Test battery consumption
Test user interface and user experience
Q186. 1.what is java 2.why platform independent 3.what is jvm ,jdk and jre 4.do we require jvm or jre to run java code or both we required 5.what is java.lang 6.libraries 7.what is dbms ,rdbm and its example 8.what i...
read moreJava is a high-level, object-oriented programming language used for developing applications and software.
Java is platform-independent due to its bytecode and JVM.
JVM, JDK, and JRE are essential components of Java.
JVM is responsible for executing Java bytecode.
JDK is a software development kit used for developing Java applications.
JRE is a runtime environment required to run Java applications.
java.lang is a package that contains fundamental classes and interfaces.
Libraries in ...read more
Q187. 3)Do you know about programming languages and which language you use recently and why?
Yes, I am familiar with programming languages and have recently used Python for its versatility and ease of use.
I have experience with Python, Java, C++, and SQL
Python is my recent choice due to its readability, flexibility, and vast libraries
I have used Python for data analysis, automation, and web development projects
MVC architecture in Spring separates the application into three main components: Model, View, and Controller.
Model represents the data and business logic of the application.
View is responsible for displaying the data to the user.
Controller acts as an intermediary between Model and View, handling user input and updating the Model accordingly.
Spring MVC framework provides support for implementing MVC architecture in web applications.
Annotations like @Controller, @RequestMapping...read more
Q189. Suppose there are two tables: A Customer table and an Order table. The Order table has a column OrderID CustomerID, OrderStatus, and TotalAmount. The Customer table has the columns CustomerID, CustomerName, Pho...
read moreQuery to print CustomerID, CustomerName, OrderStatus, and TotalAmount excluding orders placed in August.
Join Customer and Order tables on CustomerID
Filter out orders placed in August using WHERE clause
Select CustomerID, CustomerName, OrderStatus, and TotalAmount columns
Q190. What is data base and their types why we use db jions conditions
A database is a collection of organized data that can be easily accessed, managed, and updated. There are different types of databases such as relational, NoSQL, and object-oriented databases.
Types of databases include relational databases (e.g. MySQL, Oracle), NoSQL databases (e.g. MongoDB, Cassandra), and object-oriented databases (e.g. db4o).
We use database joins to combine rows from two or more tables based on a related column between them.
Database joins help in retrievin...read more
Q191. What is the difference between C++and java ? Which one do you think better and why?
C++ is a compiled language while Java is an interpreted language. Both have their own advantages and disadvantages.
C++ is faster and more efficient than Java due to its compiled nature.
Java is more platform-independent and has better memory management.
C++ is commonly used for system-level programming while Java is used for web and mobile applications.
Choosing between the two depends on the specific project requirements and goals.
Q192. What kind of database you used in projects
I have experience working with various databases including SQL Server, Oracle, and MySQL.
I have worked with SQL Server extensively and have experience in writing complex queries and stored procedures.
I have also worked with Oracle and have experience in creating and managing tables, indexes, and views.
I have used MySQL for smaller projects and have experience in designing and implementing databases.
I am familiar with database design principles and normalization techniques.
I h...read more
To delete a table in SQL, you can use the DROP TABLE statement.
Use the DROP TABLE statement followed by the table name to delete the table.
Make sure to backup any important data in the table before deleting it.
Ensure that you have the necessary permissions to delete the table.
Q194. 2. Find the maximum subarray sum given an array with positive and negative integers.
Find the maximum subarray sum in an array with positive and negative integers.
Use Kadane's algorithm to find the maximum subarray sum.
Initialize two variables, one for current maximum and one for global maximum.
Iterate through the array and update the variables accordingly.
Return the global maximum.
Example: [-2, 1, -3, 4, -1, 2, 1, -5, 4] returns 6 (subarray [4, -1, 2, 1])
Q195. What is difference between inner join and outer join?
Inner join returns only the matching rows from both tables while outer join returns all rows from both tables.
Inner join only returns the rows that have matching values in both tables.
Outer join returns all rows from both tables, even if there are no matching values.
Left outer join returns all rows from the left table and matching rows from the right table.
Right outer join returns all rows from the right table and matching rows from the left table.
Full outer join returns all ...read more
Q196. What are the difference between multiple web servers?
Multiple web servers differ in their hardware, software, and configuration.
Hardware differences include CPU, RAM, and storage capacity.
Software differences include operating system, web server software, and scripting languages.
Configuration differences include load balancing, caching, and security settings.
Examples of web servers include Apache, Nginx, and IIS.
Q197. How to Recover the root password if its missed or deleted?
To recover root password, boot into single-user mode and reset the password.
Reboot the system and press 'e' at the GRUB menu to edit the boot options.
Add 'single' or 'init=/bin/bash' to the end of the 'linux' line and press F10 to boot.
Run 'passwd' command to reset the root password.
Reboot the system and login with the new password.
Q198. How check available physical volumes, Volume groups and Logical Volumes?
To check available physical volumes, volume groups, and logical volumes, you can use the 'pvdisplay', 'vgdisplay', and 'lvdisplay' commands.
Use 'pvdisplay' command to display information about physical volumes.
Use 'vgdisplay' command to display information about volume groups.
Use 'lvdisplay' command to display information about logical volumes.
These commands provide detailed information about the available physical volumes, volume groups, and logical volumes on the system.
You...read more
Q199. what is recursion ? what is inheritance? what is heap? write a code to find the largest element in an array?
Recursion is a process in which a function calls itself. Inheritance is a mechanism in OOP where a class inherits properties of another class. Heap is a region of memory used for dynamic memory allocation.
Recursion can be used to solve problems that can be broken down into smaller sub-problems.
Inheritance allows for code reuse and helps in creating a hierarchy of classes.
Heap is used for dynamic memory allocation in languages like C and C++.
Code to find largest element in an ...read more
Q200. Is Python language a case sensitive?
Yes, Python is a case sensitive language.
Variable names 'myVar' and 'myvar' are different in Python.
Keywords like 'if', 'else', 'while' are case sensitive.
Function names and method names are also case sensitive.
Top HR Questions asked in Infosys
Interview Process at Infosys

Top Interview Questions from Similar Companies






Reviews
Interviews
Salaries
Users/Month