Codilar Technologies Interview Questions and Answers

SQL query to find 2nd maximum salary from employee table

• Use ORDER BY and LIMIT to get the second highest salary

• SELECT salary FROM employee ORDER BY salary DESC LIMIT 1, 1

A LinkedList is a linear data structure where each element is a separate object with a reference to the next element.

• Create a Node class with data and next pointer

• Initialize LinkedList with a head node pointing to null

• Implement methods like insert, delete, search, and traverse

• Example: Node class {int data; Node next;}

• Example: Insert method to add a new node at the end of the list

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 if necessary

• Repeat until no swaps are needed

• Time complexity: O(n^2)

• Space complexity: O(1)

• Example: [5, 3, 8, 2, 1] -> [3, 5, 2, 1, 8] -> [3, 2, 1, 5, 8] -> [2, 1, 3, 5, 8] -> [1, 2, 3, 5, 8]

ECMA6 introduced new features like arrow functions, classes, and let/const declarations compared to ECMA5.

• ECMA6 introduced arrow functions for more concise syntax: const add = (a, b) => a + b;

• ECMA6 added classes for object-oriented programming: class Person { constructor(name) { this.name = name; } }

• ECMA6 introduced let/const declarations for block-scoped variables: let x = 5; const y = 10;

Yes, I am committed to giving my best effort and delivering 100% in all tasks.

• I am dedicated to meeting deadlines and exceeding expectations

• I have a strong work ethic and strive for excellence in all my work

• I am willing to put in extra effort and work long hours if needed