i
ITC Infotech
Filter interviews by
I applied via Naukri.com and was interviewed in Apr 2022. There were 3 interview rounds.
Indexing in SQL Server database
Indexing improves query performance by creating a structure that allows for faster data retrieval
Clustered and non-clustered indexes are the two types of indexes in SQL Server
Clustered indexes determine the physical order of data in a table while non-clustered indexes create a separate structure
Indexing should be done strategically to avoid over-indexing which can slow down data modificat...
I applied via Naukri.com and was interviewed before Oct 2022. There were 3 interview rounds.
Top trending discussions
I applied via Campus Placement and was interviewed in Oct 2020. There were 4 interview rounds.
Dictionary is a collection of key-value pairs in Python.
Keys must be unique and immutable.
Values can be of any data type.
Access values using keys.
Add or modify values using keys.
Use dict() constructor or {} to create a dictionary.
Example: {'name': 'John', 'age': 30}
Example: dict(name='John', age=30)
posted on 2 May 2021
Method overloading is having multiple methods with the same name but different parameters. Method overriding is having a subclass method with the same name and parameters as a superclass method.
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 a supe...
I applied via Naukri.com
I appeared for an interview in Nov 2020.
I applied via Youtube and was interviewed before Dec 2020. There were 4 interview rounds.
JIT stands for Just-In-Time compiler in Java. It is important for improving the performance of Java applications.
JIT compiles Java bytecode into native machine code at runtime
It optimizes frequently executed code segments for faster execution
JIT reduces the startup time of Java applications
Examples of JIT compilers in Java include HotSpot and JRockit
Yes, I am open to exploring other technologies like cloud.
I have some experience with cloud technologies like AWS and Azure.
I am interested in learning more about cloud computing and its applications.
I believe that having knowledge of different technologies can make me a more well-rounded engineer.
I appeared for an interview before May 2021.
Round duration - 180 Minutes
Round difficulty - Easy
It was an coding + mcq+ english round
Given an array or list of integers 'ARR', identify the second largest element in 'ARR'.
If a second largest element does not exist, return -1.
ARR = [2,...
The task is to find the second largest element in an array of integers.
Iterate through the array and keep track of the largest and second largest elements.
Initialize the largest and second largest variables with the first two elements of the array.
Compare each element with the largest and second largest variables and update them accordingly.
Return the second largest element at the end.
Handle the case where no second la...
Round duration - 30 Minutes
Round difficulty - Easy
it was technical round
Given an integer array 'ARR' of size 'N' containing numbers from 0 to (N - 2). Each number appears at least once, and there is one number that appears twice. Yo...
Given an array of size N containing numbers from 0 to (N-2), find and return the duplicate number.
Iterate through the array and keep track of the frequency of each number using a hashmap.
Return the number with a frequency of 2.
Round duration - 20 Minutes
Round difficulty - Easy
It was an hr round. this was just after the tech round.
Tip 1 : Stay focused
Tip 2 : Practice coding questions.
Tip 3 : View previous interviews of the companies
Tip 1 : Don't lie on resume
Tip 2 : Just write in format that is catchy
based on 1 interview experience
Difficulty level
Duration
based on 9 reviews
Rating in categories
Associate Information Technology Consultant
5.1k
salaries
| ₹4.3 L/yr - ₹14.4 L/yr |
Lead Consultant
4.6k
salaries
| ₹16.4 L/yr - ₹30 L/yr |
Associate Consultant
958
salaries
| ₹2.5 L/yr - ₹18.5 L/yr |
Software Engineer
514
salaries
| ₹5.1 L/yr - ₹12 L/yr |
Senior Software Engineer
400
salaries
| ₹12.3 L/yr - ₹22.5 L/yr |
TCS
Mphasis
L&T Technology Services
Coforge