Eka Software Solutions Interview Questions, Process, and Tips

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

Html related typing all assignments all about client clear

Also create html file java related projects

All clients discuss the project

Q1. Always advise project
Add your answer
Q2. Html related questions
Add your answer
Q3. Java related information
Add your answer
Q4. .net related questions
Add your answer
Q5. All about questions prepare
Add your answer

Q1. Tell me more about you
Add your answer

Q1. Tell me about your experience
Add your answer

Q1. Location,package
Add your answer

Python codeing, Django

Objective Question, you have to score 60 %. There was a total of 15 questions. All the questions from core java and little programming Objective.

This round also Coding Questions. They Gave a repository to clone, and write a full implementation of that within 1 hrs. It was a Spring MVC framework, that perform crud operations. Write View, Controller, Services, Dao.

Q1. Salary Discussion, Why do you want to join our organization?
Add your answer
Q2. What is your expectation?
Add your answer
Q3. Salary Negotiation and previous salary.
Add your answer
Q4. When will you join our organization.
Add your answer
Q5. When is the last working day.
Add your answer