Manhattan home Design Interview Questions and Answers

Printing reverse of string without inbuilt function and start printing from last index.

• Iterate through the string from last index to first index and append each character to a new string.

• Use a loop to iterate through the string and concatenate each character to the new string.

• Print the new string in reverse order.

Printing reversed words in a string without using inbuilt functions

• Split the string into words using space as delimiter

• Iterate through each word and reverse it

• Print the reversed words in the original order

Use SQL JOIN to combine data from two tables into a single table format.

• Use the JOIN keyword in SQL to combine data from two tables based on a related column.

• Specify the columns you want to retrieve from each table in the SELECT statement.

• Use the ON keyword to specify the column from each table that should be used for the join condition.

• You can use different types of joins such as INNER JOIN, LEFT JOIN, RIGHT JOIN, or FULL JOIN based on your requirements.

SQL query to retrieve number of students grouped by streams

• Use the GROUP BY clause to group students by their streams

• Use the COUNT function to retrieve the number of students in each group

• Example: SELECT stream, COUNT(student_id) FROM students_table GROUP BY stream

Use nested loops to print a right-angled triangle of numbers based on input.

• Use two nested loops to control the rows and columns of the triangle.

• Increment the number to be printed in each row.

• Example: If input is 5, the output would be: 1, 12, 123, 1234, 12345

A Spring Boot project can be created to develop an API by setting up a new Spring Boot project, defining API endpoints, and implementing the necessary logic.

• Create a new Spring Boot project using Spring Initializr

• Define API endpoints using @RestController annotation

• Implement the logic to return specified data in the API endpoints

• Use @GetMapping, @PostMapping, @PutMapping, @DeleteMapping annotations to map HTTP methods to controller methods

SQL is a programming language used for managing and manipulating relational databases.

• SQL stands for Structured Query Language

• It is used to communicate with databases to perform tasks such as querying data, updating data, and creating tables

• Common SQL commands include SELECT, INSERT, UPDATE, DELETE

• SQL is used in various database management systems such as MySQL, PostgreSQL, Oracle

• Knowledge of SQL is essential for data analysis and data manipulation tasks

Multitasking involves performing multiple tasks simultaneously, while multiprocessing involves executing multiple processes on multiple CPUs.

• Multitasking is commonly seen in operating systems where multiple applications run concurrently on a single CPU.

• Multiprocessing is utilized in systems with multiple CPUs to execute multiple processes simultaneously.

• Multitasking can lead to context switching overhead, while multiprocessing can improve overall system performance.

• Examples o...read more