i
ITC Infotech
Filter interviews by
I applied via Monster and was interviewed in May 2024. There was 1 interview round.
To select the 3rd highest salary from the employee table, you can use a SQL query with the 'LIMIT' and 'OFFSET' keywords.
Use a SQL query like 'SELECT salary FROM employee ORDER BY salary DESC LIMIT 1 OFFSET 2' to get the 3rd highest salary.
The 'ORDER BY' clause sorts the salaries in descending order, 'LIMIT 1' limits the result to 1 row, and 'OFFSET 2' skips the first two rows.
Make sure to adjust the 'OFFSET' value if
Put is used to create or replace a resource, while patch is used to update a resource partially.
Put is idempotent, meaning multiple identical requests will have the same effect as a single request
Patch is not idempotent, as multiple identical requests may have different effects
Put requires the client to send the entire updated resource, while patch only requires the specific changes to be sent
The == operator checks for reference equality, while the equals method checks for value equality in strings.
Use == to check if two string variables refer to the same object in memory.
Use equals() method to check if two string variables have the same sequence of characters.
Example: String str1 = "hello"; String str2 = "hello"; str1 == str2 will return false, but str1.equals(str2) will return true.
String can be declared using double quotes, single quotes, or the String constructor.
Declare using double quotes: String str1 = "Hello";
Declare using single quotes: String str2 = 'World';
Declare using String constructor: String str3 = new String("Java");
String builder is not synchronized, while String buffer is synchronized.
String builder is faster than String buffer because it is not synchronized.
String buffer is thread-safe, while String builder is not.
String builder is preferred for single-threaded applications, while String buffer is preferred for multi-threaded applications.
Convert array to ArrayList of strings
Create a new ArrayList<String>
Use Arrays.asList() method to convert array to ArrayList
Example: String[] array = {"apple", "banana", "orange"}; ArrayList<String> list = new ArrayList<>(Arrays.asList(array));
Top trending discussions
I applied via Approached by Company and was interviewed before Mar 2023. There was 1 interview round.
I applied via Referral and was interviewed before Dec 2023. There was 1 interview round.
Agile methodologies are a set of principles and practices that prioritize flexibility, collaboration, and continuous improvement in software development.
Agile methodologies focus on iterative development, where requirements and solutions evolve through collaboration between self-organizing cross-functional teams.
They emphasize adaptability to change, with a focus on delivering working software frequently and responding...
Test scenarios for a banking application involve testing various functionalities and features to ensure they work correctly and securely.
Testing user authentication and authorization processes
Testing fund transfer functionality, including different types of transfers (e.g. interbank, intrabank)
Testing bill payment functionality
Testing account balance display and transaction history accuracy
Testing security measures suc...
I applied via Company Website and was interviewed in Sep 2023. There was 1 interview round.
API is a general term for any interface that allows communication between different software systems, while SOAP API is a specific type of API that uses the SOAP protocol for communication.
API is a general term for any interface that allows communication between different software systems
SOAP API is a specific type of API that uses the SOAP protocol for communication
API can use various protocols like REST, SOAP, GraphQ...
Artifacts in agile methodology are tangible by-products of the development process that provide documentation and information for the team.
Artifacts include user stories, product backlog, sprint backlog, burndown charts, and release plans.
They help in communication, planning, and tracking progress throughout the project.
Examples of artifacts are wireframes, prototypes, test cases, and design documents.
Artifacts are ess...
API testing involves testing the functionality, reliability, performance, and security of APIs.
API testing ensures that the API functions correctly, returns the expected results, and handles errors properly.
It involves testing different types of APIs such as REST, SOAP, and GraphQL.
API testing can be done manually or using automated tools like Postman, SoapUI, or JMeter.
Common features of API testing include endpoint t...
I applied via Campus Placement and was interviewed before Dec 2020. There were 4 interview rounds.
I applied via Campus Placement and was interviewed before Oct 2020. There were 3 interview rounds.
I applied via Campus Placement and was interviewed before Feb 2021. There were 3 interview rounds.
General aptitude
Let us C, Java
I applied via Company Website and was interviewed in Dec 2020. There was 1 interview round.
I appeared for an interview before Dec 2020.
Round duration - 45 minutes
Round difficulty - Hard
All mcqs should answer with in time limit should have a lot of practice to solve in exam
You have two water jugs with capacities X
and Y
liters respectively, both initially empty. You also have an infinite water supply. The goal is to determine if it is possible to...
The Water Jug Problem involves determining if a specific amount of water can be measured using two jugs of different capacities.
Start by considering the constraints and limitations of the problem.
Think about how the operations allowed can be used to reach the target measurement.
Consider different scenarios and test cases to come up with a solution.
Implement a function that takes the capacities of the jugs and the targe...
Round duration - 60 minutes
Round difficulty - Easy
Easy and just basic questions very easy round
Given two sparse matrices MAT1
and MAT2
of integers with dimensions 'N' x 'M' and 'M' x 'P' respectively, the goal is to determine the resulting matrix produced by their multipl...
Implement a function to multiply two sparse matrices and return the resulting matrix.
Create a function that takes two sparse matrices as input and returns the resulting matrix after multiplication.
Iterate through the non-zero elements of the matrices to perform the multiplication efficiently.
Ensure to handle the sparse nature of the matrices to optimize the multiplication process.
Consider the constraints provided to en...
Tip 1 : preapre core subjects
Tip 2 : be confident and answer clearly
Tip 3 : be strong with projects
Tip 1 : good projects in ml and ai
Tip 2 : practical experience
based on 1 interview
Interview experience
Associate Information Technology Consultant
5.1k
salaries
| ₹3.8 L/yr - ₹15 L/yr |
Lead Consultant
4.5k
salaries
| ₹9 L/yr - ₹35 L/yr |
Associate Consultant
906
salaries
| ₹2.5 L/yr - ₹17.5 L/yr |
Software Engineer
501
salaries
| ₹3.5 L/yr - ₹14.1 L/yr |
Senior Software Engineer
385
salaries
| ₹6.5 L/yr - ₹25.5 L/yr |
Wipro
EPAM Systems
L&T Technology Services
Coforge