HCLTech Associate General Manager Interview Questions and Answers for Experienced

SQL joins are used to combine data from two or more tables based on a related column.

• Joins are used to retrieve data from multiple tables in a single query

• Common types of joins include inner join, left join, right join, and full outer join

• Joins are performed based on a related column between the tables

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column

Oops concepts are the fundamental principles of object-oriented programming.

• Abstraction: Hiding implementation details and showing only necessary information.

• Encapsulation: Binding data and functions together in a single unit.

• Inheritance: Acquiring properties and behavior of a parent class by a child class.

• Polymorphism: Ability of an object to take many forms or have multiple behaviors.

• Example: A car is an object that ...read more

Linked lists are a data structure consisting of nodes that point to the next node in the list.

• Each node contains a value and a pointer to the next node.

• Linked lists can be singly or doubly linked.

• Insertion and deletion are efficient, but random access is not.

• Examples include a queue, stack, and adjacency list.

A collection framework is a set of classes and interfaces that provide a way to store and manipulate groups of objects.

• It provides implementations of commonly used data structures like lists, sets, maps, etc.

• It allows for easy manipulation of data stored in these structures.

• Examples include Java's Collection and Map interfaces and their implementations like ArrayList, HashSet, and HashMap.