Graduate Engineer Trainee

You are given an integer ‘N’. You have to print the value of Factorial of ‘N’. The Factorial of a number ‘N’ is defined as the product of all numbers from 1 to ‘N’.

For Example:

Consider if ‘N’ = 4, the Factorial of 4 will be the product of all numbers from 1 to 4, which is 1 * 2 * 3 * 4 = 24. Hence, the answer is 24.

What are the three levels of data abstraction?(Learn)

What do you understand by query optimization?(Learn)

You are given a string 'str' of length 'N'.

Your task is to reverse the original string word by word.

There can be multiple spaces between two words and there can be leading or trailing spaces but in the output reversed string you need to put a single space between two words, and your reversed string should not contain leading or trailing spaces.

Example :

If the given input string is "Welcome to Coding Ninjas", then you should return "Ninjas Coding to Welcome" as the reversed string has only a single space between two words and there is no leading or trailing space.

Difference between inner join and outer join.(Learn)

Keys in DBMS.(Learn)

Three Schema Architecture.(Learn)

Normalization.(Learn)

Write an SQL query to find the names of employees starting with ‘A’.

How can you fetch common records from two tables?

Write the SQL query to get the third maximum salary of an employee from a table named employees.

Given the following tables:

sql> SELECT * FROM runners;
+----+--------------+
| id | name         |
+----+--------------+
|  1 | John Doe     |
|  2 | Jane Doe     |
|  3 | Alice Jones  |
|  4 | Bobby Louis  |
|  5 | Lisa Romero  |
+----+--------------+

sql> SELECT * FROM races;
+----+----------------+-----------+
| id | event          | winner_id |
+----+----------------+-----------+
|  1 | 100 meter dash |  2        |
|  2 | 500 meter dash |  3        |
|  3 | cross-country  |  2        |
|  4 | triathalon     |  NULL     |
+----+----------------+-----------+

What will be the result of the query below:
SELECT * FROM runners WHERE id NOT IN (SELECT winner_id FROM races)

How were you able to solve your coding question?

Are you okay with relocation?

Do you agree with the bond period of the company?

Explain your weakness and strengths?