i
Infosys
Work with us
Filter interviews by
Truncate, delete, and drop 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
Drop removes the entire table from the database
Truncate and drop cannot be rolled back, while delete can be
Truncate is faster than delete as it does not log individual row deletions
Bubble sort is a simple sorting algorithm that repeatedly steps through the list, compares adjacent elements and swaps them if they are in the wrong order.
Compare adjacent elements and swap them if they are in the wrong order
Repeat this process until the list is sorted
Time complexity is O(n^2)
Space complexity is O(1)
Example: [5, 3, 8, 4, 2] -> [3, 5, 4, 2, 8] -> [3, 4, 2, 5, 8] -> [3, 2, 4, 5, 8] -> [2, 3, 4, 5, 8...
Python provides a built-in module 'threading' to implement threads.
Import the 'threading' module
Create a new thread using the 'Thread' class
Define the target function for the thread
Start the thread using the 'start()' method
Join the thread using the 'join()' method
Use locks to synchronize access to shared resources
Set, list, and tuple are data structures in Python with different properties.
A set is an unordered collection of unique elements.
A list is an ordered collection of elements that can be modified.
A tuple is an ordered collection of elements that cannot be modified.
Sets are useful for operations like union, intersection, and difference.
Lists are useful for storing and accessing data in a specific order.
Tuples are use...
Calculate average of an array.
Loop through the array and add all the elements
Divide the sum by the length of the array
Return the average
ACID properties are a set of properties that ensure database transactions are processed reliably.
ACID stands for Atomicity, Consistency, Isolation, and Durability.
Atomicity ensures that a transaction is treated as a single, indivisible unit of work.
Consistency ensures that a transaction brings the database from one valid state to another.
Isolation ensures that concurrent transactions do not interfere with each oth...
IP address is a unique identifier assigned to devices on a network. DNS is a system that translates domain names to IP addresses.
IP address stands for Internet Protocol address
It is a numerical label assigned to each device connected to a network
It serves as a unique identifier for the device
DNS stands for Domain Name System
It is a system that translates domain names to IP addresses
For example, www.google.com is t...
I applied via Campus Placement and was interviewed in Jul 2022. There were 3 interview rounds.
No aptitude test in this round.
3 codes were given and we gave to solved them.
I applied via Company Website and was interviewed in Nov 2021. There were 3 interview rounds.
Thei round name is Certification round. This round consists of 25 mcqs and 2 coding questions. Test duration is 3 hours. We need to get more than 65 percent to clear this round.
This round name is Advantage Round. This round is optional. But if we clear this round we will interviewed for the DSE role. If clear only 1st round we will be interviewed for System engineer role.
Bubble sort is a simple sorting algorithm that repeatedly steps through the list, compares adjacent elements and swaps them if they are in the wrong order.
Compare adjacent elements and swap them if they are in the wrong order
Repeat this process until the list is sorted
Time complexity is O(n^2)
Space complexity is O(1)
Example: [5, 3, 8, 4, 2] -> [3, 5, 4, 2, 8] -> [3, 4, 2, 5, 8] -> [3, 2, 4, 5, 8] -> [2, 3, 4, 5, 8] (so...
Truncate, delete, and drop 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
Drop removes the entire table from the database
Truncate and drop cannot be rolled back, while delete can be
Truncate is faster than delete as it does not log individual row deletions
Set, list, and tuple are data structures in Python with different properties.
A set is an unordered collection of unique elements.
A list is an ordered collection of elements that can be modified.
A tuple is an ordered collection of elements that cannot be modified.
Sets are useful for operations like union, intersection, and difference.
Lists are useful for storing and accessing data in a specific order.
Tuples are useful f...
IP address is a unique identifier assigned to devices on a network. DNS is a system that translates domain names to IP addresses.
IP address stands for Internet Protocol address
It is a numerical label assigned to each device connected to a network
It serves as a unique identifier for the device
DNS stands for Domain Name System
It is a system that translates domain names to IP addresses
For example, www.google.com is transl...
Python provides a built-in module 'threading' to implement threads.
Import the 'threading' module
Create a new thread using the 'Thread' class
Define the target function for the thread
Start the thread using the 'start()' method
Join the thread using the 'join()' method
Use locks to synchronize access to shared resources
ACID properties are a set of properties that ensure database transactions are processed reliably.
ACID stands for Atomicity, Consistency, Isolation, and Durability.
Atomicity ensures that a transaction is treated as a single, indivisible unit of work.
Consistency ensures that a transaction brings the database from one valid state to another.
Isolation ensures that concurrent transactions do not interfere with each other.
Du...
I applied via Prepinsta and was interviewed in Sep 2021. There were 2 interview rounds.
Round duration - 180 minutes
Round difficulty - null
The first round was Hackwithinfy. This is a coding round and consists of 3 questions- 1 Easy, 1 Medium and 1 Hard. I was able to solve one question completely and passed 14% of the test cases of another question in this round.
Binary search, permutation and dynamic programming based interview question on stone piles.
The easy question involves splitting stones from one pile to the other two piles.
The medium question involves permutations of a given set of elements.
The hard question involves dynamic programming.
Test cases involve checking if it is possible to obtain two piles with given number of stones after splitting.
The output should be YES...
Round duration - 30 - 45 minutes
Round difficulty - null
After completing an easy question completely and another medium question 14%, I got shortlisted for the Interview.
I am a digital system engineer with experience in designing and implementing complex systems.
I have a degree in Electrical Engineering
I have worked on projects involving FPGA and microcontroller programming
I am proficient in programming languages such as Verilog, VHDL, and C
I have experience in designing and testing digital circuits
I am familiar with various digital communication protocols such as SPI, I2C, and UART
Technical questions on OOPS, Multi Threading, and Exceptional Handling in Java.
OOPS concepts include inheritance, polymorphism, and encapsulation.
Multi Threading allows for concurrent execution of multiple threads.
Exceptional Handling is used to handle errors and exceptions in code.
Examples of exceptions include NullPointerException and ArrayIndexOutOfBoundsException.
Interview question on sorting an array using quick sort and solving fibonacci problem using recursion.
Demonstrate your coding skills by providing both brute force and optimized solutions.
Practice coding problems beforehand to be prepared for technical interviews.
Be comfortable with online compilers and screen sharing.
Quick sort example: https://www.geeksforgeeks.org/quick-sort/
Fibonacci recursion example: https://www.g...
What people are saying about Infosys
I applied via Company Website and was interviewed before Oct 2020. There were 3 interview rounds.
I applied via Amcat and was interviewed before Jul 2021. There were 2 interview rounds.
Refer R S Agarwal book for apptitude
A C program to perform arithmetic operations on fractional numbers.
Use float or double data type to store fractional numbers.
Use scanf() to take input from the user.
Perform arithmetic operations like addition, subtraction, multiplication, and division.
Use printf() to display the result.
I applied via Recruitment Consulltant and was interviewed before Feb 2021. There were 3 interview rounds.
1.It covers all aptitude topics, and English sentences
2.Essay writing
3.Coding
I applied via Naukri.com and was interviewed before Mar 2021. There were 3 interview rounds.
I come from a supportive family that values education and hard work, which has greatly influenced my career path in technology.
Parents: My parents are both educators, instilling a love for learning and curiosity in me from a young age.
Siblings: I have a younger sister who is pursuing a degree in computer science, and we often collaborate on tech projects together.
Family Values: Our family emphasizes the importance of p...
I bring a unique blend of technical skills, problem-solving abilities, and a passion for innovation that aligns with your team's goals.
Strong technical skills: Proficient in languages like Python and Java, demonstrated by developing a web application that improved user engagement by 30%.
Problem-solving mindset: Successfully resolved a critical bug in a production system under tight deadlines, ensuring minimal downtime.
...
I expect a competitive salary based on my skills, experience, and industry standards, ideally in the range of $X to $Y.
Research industry standards: For example, Glassdoor or Payscale can provide insights into average salaries for similar roles.
Consider your experience: If you have 5 years of experience, you might expect a higher salary than someone just starting.
Factor in location: Salaries can vary significantly based...
I excel in problem-solving and teamwork, but I sometimes struggle with time management under tight deadlines.
Strength: Strong problem-solving skills - I enjoy tackling complex coding challenges, like optimizing algorithms for better performance.
Strength: Effective teamwork - I thrive in collaborative environments, having successfully led a project with cross-functional teams.
Weakness: Time management - I occasionally u...
Yes, I have technical certifications and I am proficient in multiple programming languages and development tools.
I have certifications in Java and Python
I am proficient in Java, Python, C++, and JavaScript
I have used development tools such as Eclipse, Visual Studio Code, and PyCharm
I applied via Company Website and was interviewed before Jan 2021. There were 2 interview rounds.
I applied via Job Portal and was interviewed before Dec 2019. There was 1 interview round.
based on 1 interview experience
Difficulty level
Duration
based on 1 review
Rating in categories
Technology Analyst
55.8k
salaries
| ₹4.8 L/yr - ₹11.2 L/yr |
Senior Systems Engineer
53.7k
salaries
| ₹2.5 L/yr - ₹6.3 L/yr |
Technical Lead
35k
salaries
| ₹7.3 L/yr - ₹20 L/yr |
System Engineer
32.5k
salaries
| ₹2.4 L/yr - ₹5.3 L/yr |
Senior Associate Consultant
31k
salaries
| ₹6.3 L/yr - ₹17 L/yr |
TCS
Wipro
Cognizant
Accenture