CMS Computers Limited (INDIA) Software Developer Interview Questions, Process, and Tips

Write a custom finder method to find the second highest salary.

• Sort the salaries in descending order.

• Retrieve the second element from the sorted list.

• Handle edge cases such as when there are duplicate salaries or less than two salaries.

I use Git for versioning.

• Git is a distributed version control system.

• It allows multiple developers to work on the same project simultaneously.

• Git tracks changes to files and allows for easy collaboration and code merging.

• It provides features like branching, tagging, and history tracking.

• Examples of Git hosting platforms are GitHub, GitLab, and Bitbucket.

Loops in Java 7 vs Loops in Streams

• Java 7 loops use imperative programming style, while streams use functional programming style

• Java 7 loops require explicit iteration, while streams handle iteration internally

• Streams provide built-in methods for filtering, mapping, and reducing data

• Streams can be parallelized for improved performance

• Java 7 loops are generally more efficient for simple iterations

PostgreSQL is an open-source relational database management system known for its robustness, scalability, and extensibility.

• PostgreSQL is commonly referred to as Postgres.

• It is a powerful and feature-rich database system.

• PostgreSQL supports various data types, including JSON, arrays, and user-defined types.

• It provides advanced features like transactions, concurrency control, and data integrity.

• PostgreSQL is widely used...read more