EffiaSoft Interview Questions and Answers

Q1. Java basics questions
Add your answer

Q1. Struts 1x questions and PL SQL
Add your answer

Online or offline classes which is better

Q1. Sql and excel and the company is good
Add your answer

Q1. Design Least recently used cache.
Ans. 
Design a Least Recently Used cache system.
• Implement a doubly linked list to keep track of the order of usage of cache items.

• Use a hashmap to store key-value pairs for quick access to cache items.

• When a new item is accessed, move it to the front of the linked list. If the cache is full, remove the least recently used item from the end of the list.
Answered by AI
Add your answer

A general topic was provided.

Basic aptitude questions.

Q1. Sql and dbms questions
Add your answer

Q1. What are optimisation techniques in stored procedure
Ans. 
Optimisation techniques in stored procedures improve performance by reducing execution time and resource usage.
• Use proper indexing on tables involved in the stored procedure

• Minimize the use of cursors and loops

• Avoid using SELECT * and fetch only necessary columns

• Avoid using temporary tables if possible

• Use SET NOCOUNT ON to stop the message indicating the number of rows affected by a T-SQL statement
Answered by AI
Add your answer
Q2. Analyse the condition in query and optimise it.
Ans. 
The candidate is asked to analyse and optimize a given condition.
• Identify the key components of the condition and their interactions

• Consider potential areas for improvement or inefficiencies

• Propose specific changes or strategies to optimize the condition
Answered by AI
Add your answer

Q1. Integer Array rotation for K time
Ans. 
Rotate an integer array K times
• Create a temporary array to store elements that will be rotated

• Use modulo operator to handle cases where K is larger than array length

• Update the original array with elements from the temporary array
Answered by AI
Add your answer
Q2. Find the missing number in series of array of distinct numbers?
Ans. 
The missing number in a series of distinct numbers can be found by identifying the pattern and determining the missing element.
• Identify the pattern in the series of numbers.

• Determine the logic or rule governing the sequence.

• Apply the logic to find the missing number.

• Example: Series - 2, 4, 6, 10, 12, 14, Missing number is 8.
Answered by AI
Add your answer