Acuity Knowledge Partners Interview Questions and Answers

Pessimistic locking is when a resource is locked for a long time, while optimistic locking is when a resource is locked only when it is being modified.

• Pessimistic locking involves locking a resource for a long time to prevent other users from accessing it.

• Optimistic locking involves locking a resource only when it is being modified, allowing other users to access it in the meantime.

• Pessimistic locking is useful when conflicts are likely to occur, while optimistic locking is u...read more

Check if two strings are anagrams of each other

• Create a character count array for both strings

• Compare the character count arrays

• If they are equal, the strings are anagrams

REST endpoints for a ticket booking system

• GET /events - get list of available events

• GET /events/{id} - get details of a specific event

• POST /events/{id}/tickets - book tickets for an event

• GET /bookings - get list of all bookings

• GET /bookings/{id} - get details of a specific booking

• PUT /bookings/{id} - update a booking

• DELETE /bookings/{id} - cancel a booking

Java performance and query optimization in Oracle

• Use prepared statements to avoid SQL injection and improve performance

• Use indexes to speed up query execution

• Avoid using SELECT * and only select necessary columns

• Use connection pooling to reuse database connections

• Use caching to reduce database round trips

• Tune database parameters like buffer cache and shared pool size

• Use profiling tools to identify performance bottlenecks

To make a Java class immutable, use final keyword and initialize all fields in constructor.

• Use final keyword for class and all fields

• Initialize all fields in constructor

• Do not provide setter methods

• Make sure to return a new instance in any method that modifies the state