Lloyds Technology Centre Senior Software Engineer Interview Questions, Process, and Tips

Find k closest elements in an array

• Sort the array based on the absolute difference between each element and the target element

• Return the first k elements from the sorted array

Pagination in SQL allows for displaying a subset of query results at a time.

• Use LIMIT and OFFSET clauses in SQL queries to implement pagination.

• LIMIT specifies the maximum number of rows to return.

• OFFSET specifies the number of rows to skip before starting to return rows.

Threads and tasks are both used in multiprocessing, but have different characteristics and use cases.

• Threads are lightweight processes within a single process, sharing memory space. They are managed by the operating system.

• Tasks are units of work that can be executed asynchronously. They are typically managed by a task scheduler.

• Threads are suitable for parallel processing and improving performance, while tasks are use...read more

ViewBag is used to pass data from controller to view, while TempData is used to pass data between controller actions.

• ViewBag is a dynamic property that allows you to pass data from controller to view

• TempData is a dictionary object that allows you to pass data between controller actions

• ViewBag is not type-safe and requires typecasting, while TempData is type-safe

• ViewBag data is lost if redirection occurs, while TempData

Abstract classes can have both abstract and non-abstract methods, while interfaces can only have abstract methods.

• Abstract classes can have constructors, fields, and non-abstract methods.

• Interfaces can only have abstract methods and constants.

• A class can implement multiple interfaces but can only inherit from one abstract class.