i
Data Template Infotech
Filter interviews by
A self join query is used to join a table to itself in a SQL query.
Self join is used when a table needs to be joined with itself to compare rows within the same table.
It requires aliasing the table with different names to distinguish between the two instances of the same table.
Commonly used in hierarchical data structures or when comparing related rows in a table.
Group by query is used to group data based on a specific category.
Use the GROUP BY clause in SQL to group data based on a specific column
Aggregate functions like COUNT, SUM, AVG can be used with GROUP BY to perform calculations on grouped data
Example: SELECT category, COUNT(*) FROM products GROUP BY category
Top trending discussions
Fizz buzz question and array related
posted on 4 Mar 2021
I applied via LinkedIn and was interviewed in Sep 2020. There were 4 interview rounds.
C++ program to implement queue using linked list and class
Create a class for queue and node
Implement enqueue, dequeue, and display functions
Use pointers to link nodes in the linked list
posted on 21 Sep 2023
I applied via Campus Placement and was interviewed in Mar 2023. There were 4 interview rounds.
Computer Networks, SQL, DBMS, aptitude questions on trains, boats , profit and loss. 2 coding questions. Total duration was 1.5 hrs.
I applied via Approached by Company and was interviewed before Jul 2022. There were 3 interview rounds.
I applied via Referral and was interviewed before Feb 2022. There were 4 interview rounds.
Easy level questions on string, linked list and array
TCP is a connection-oriented protocol while UDP is connectionless.
TCP provides reliable, ordered, and error-checked delivery of data while UDP does not guarantee any of these.
TCP is slower but more reliable while UDP is faster but less reliable.
TCP is used for applications that require high reliability and accuracy such as email, file transfer, and web browsing while UDP is used for applications that require speed and ...
A nibble swap program in C
Nibble swap means swapping the 4-bit halves of a byte
Use bitwise operators to perform the swap
Example: unsigned char x = 0xAB; x = ((x & 0x0F) << 4) | ((x & 0xF0) >> 4);
Reverse a linked list in C language.
Create three pointers: current, previous, and next.
Traverse the linked list and change the direction of the pointers.
Return the new head of the reversed linked list.
API call in C
Include the necessary header files
Create a URL string with the required parameters
Use the curl library to make the API call
Handle the response data appropriately
posted on 14 Sep 2023
I applied via Campus Placement and was interviewed in Sep 2023. There were 4 interview rounds.
Duration:30 min
Question from percentage,ratios ,HCF/LCM etc.,
Logical reasoning, English
Reverse a string by grouping 'm' characters together
Iterate through the string in groups of 'm' characters
Reverse each group of 'm' characters
Concatenate the reversed groups to get the final reversed string
I applied via Internshala and was interviewed in Oct 2023. There was 1 interview round.
Data structure is a way of organizing and storing data in a computer so that it can be accessed and used efficiently.
Data structures can be linear (arrays, linked lists) or non-linear (trees, graphs)
Common operations on data structures include insertion, deletion, and searching
Examples of data structures include stacks, queues, hash tables, and binary trees
posted on 23 Aug 2024
I applied via Campus Placement and was interviewed in Jul 2024. There was 1 interview round.
Question based on array string linkedlist
based on 2 interviews
Interview experience
based on 5 reviews
Rating in categories
Software Engineer
152
salaries
| ₹1.9 L/yr - ₹8 L/yr |
Senior Software Engineer
43
salaries
| ₹6 L/yr - ₹20 L/yr |
Software Developer
25
salaries
| ₹2.4 L/yr - ₹5.5 L/yr |
Technical Lead
21
salaries
| ₹12 L/yr - ₹33 L/yr |
Associate Software Engineer
13
salaries
| ₹1.8 L/yr - ₹3.4 L/yr |
PC Solutions
AFour Technologies
360 Degree Cloud Technologies
Affine