Software Developer

What is Atomicity in DBMS? (Learn)

A few images were given along with a pattern. From the provided images, determine the next image.

A few number sequences were given along with the next possible sequence.

Many questions were based on time-work, profit-loss, speed-time, blood relation, and direction-based questions (like if you walk 30 degrees north then turn to the south and then to left and then 40 degrees right and now tell in which direction you are standing compared to the starting point).

A few query problems were given along with SQL queries to solve the problem.

Q1: Create a new table with the same structure as an existing table (Employee). (Learn)

Q2: Find the 3rd maximum salary from the employee table along with the department from the department table. (Practice)

What is DDL? (Learn)

Difference between private, public and protected. (Learn)

Given an array ‘arr’ of size ‘n’ find the largest element in the array.

Example:

Input: 'n' = 5, 'arr' = [1, 2, 3, 4, 5]

Output: 5

Explanation: From the array {1, 2, 3, 4, 5}, the largest element is 5.

Questions covered were active-passive voice, synonym-antonyms, jumble sentences, and choosing the correct word.

Difference between DDL, and DML. (Learn)

Difference between 1NF, and 2NF. (Learn)

What is deadlock and how to avoid it? (Learn)

What is the waterfall model? (Learn)

There is a wedding ceremony at NinjaLand. The bride and groom want everybody to play a game and thus, they have blindfolded the attendees. The people from the bride’s side are holding odd numbers and people from the groom’s side are holding the even numbers. For the game to start quickly, all the bride’s side people should come first, followed by the groom’s side people in the same order.

The attendees of the wedding with their numbers are given in the form of a Singly Linked List, arranged randomly.

A singly linked list is a type of linked list that is unidirectional; that is, it can be traversed in only one direction from head to the last node (tail).

Example:

The attendees holding numbers from 1, 4, 3 are shown: 

As the organizers are busy, you have to arrange all the people by arranging the bride’s side people first followed by the groom’s side people sequentially.

Note:

For the above example 1 -> 4 -> 3, 1 -> 3 -> 4 is the only correct answer, i.e nodes should be grouped sequentially. Hence, 3 -> 1 -> 4 is the wrong answer as we have to preserve the same order.

Difference between a class and an object. (Learn)

I was asked to provide an introduction of myself.

The HR asked about the technologies I am familiar with and mentioned the technologies that new joiners will work on.

What are your preferred locations?