i
Eka Software Solutions
Filter interviews by
I applied via Naukri.com and was interviewed in Jul 2024. There were 2 interview rounds.
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
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
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
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.
Top trending discussions
posted on 2 Jan 2025
I applied via Referral
Print a specific pattern using any programming language.
A class in OOP is a blueprint for creating objects, defining their properties and behaviors.
Classes are templates for creating objects in OOP
They define the properties (attributes) and behaviors (methods) of objects
Objects are instances of classes, each with its own unique data
Inheritance allows classes to inherit properties and behaviors from other classes
Encapsulation ensures that the data is hidden and can only be a...
Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.
Abstract class can have constructors, fields, and methods, while interface cannot have any implementation.
A class can only extend one abstract class, but can implement multiple interfaces.
Abstract classes are used to define common characteristics of subclasses, while interfaces are used to define contracts for...
Joining is combining data from two or more tables based on a related column, while an inner join query retrieves only the matching records.
Joining is used to combine data from multiple tables in a database.
Inner join query retrieves only the records that have matching values in both tables.
Syntax for inner join: SELECT columns FROM table1 INNER JOIN table2 ON table1.column = table2.column;
Example: SELECT orders.order_i...
posted on 6 Sep 2024
I applied via Campus Placement and was interviewed in Aug 2024. There were 2 interview rounds.
1st round of the company was an online assessment with 40 questions,2 coding questions :- cake distribution problem, Palindrome and else there were 6-7 SQL questions and other were Aptitude questions (basic) whole test was for 1 hr.
Use ALTER TABLE to add a new column and then use MAX function to find the highest salary.
Use ALTER TABLE statement to add a new column to the table.
Use MAX function in SQL to find the maximum salary of employees.
Calculate the sum of digits of a given number.
Iterate through each digit of the number and add them together.
Use modulo operator to extract each digit.
Repeat until all digits are processed.
Example: For number 123, sum of digits = 1 + 2 + 3 = 6.
I applied via Referral and was interviewed in Sep 2024. There were 2 interview rounds.
posted on 7 Nov 2024
Mathematics,General Aptitute,three coding question
Face to face interview.Ask questions on Data structure and algorithms
posted on 11 Aug 2023
I applied via campus placement at Indira Gandhi Institute of Technology, Dhenkanal and was interviewed in Jul 2023. There were 4 interview rounds.
There are Verbal, logical reasoning, quantitative, coding questions (2 Qtns) and a descriptive essay on "How you used the pendamic duration for study" ( Minimum 200 words) required. And coding questions are DSA Medium level one was: " Find the maximum profit percentage during the buy and sell of stock of a company. ". Verbal round was mostly (4 -5 questions) on make meaning full sentence. All the first round test was conducted on "Xobin online test" platform.
Easy general logical theoretical questions
I applied via Naukri.com and was interviewed in May 2023. There were 3 interview rounds.
posted on 31 Jul 2023
I applied via Company Website and was interviewed in Jul 2023. There were 4 interview rounds.
Basic coding in Java. MySql, HTML.
Adavance coding in Java programming.
Tell me about yourself
Senior Software Engineer
111
salaries
| ₹8 L/yr - ₹28.8 L/yr |
Software Engineer
90
salaries
| ₹3.6 L/yr - ₹14.8 L/yr |
Senior Business Consultant
43
salaries
| ₹8.6 L/yr - ₹25 L/yr |
Business Analyst
41
salaries
| ₹5.3 L/yr - ₹15.9 L/yr |
Business Consultant
39
salaries
| ₹4.8 L/yr - ₹14.4 L/yr |
Ramco Systems
TCS
Infosys
Wipro