Filter interviews by
Stored procedures are used to perform a set of actions, while functions return a single value.
Stored procedures are precompiled and stored in a database, while functions are compiled and executed at runtime.
Functions can be used in SQL statements, while stored procedures cannot be used in SQL statements.
Functions can be called from stored procedures, but stored procedures cannot be called from functions.
Functions can b...
REST is lightweight and flexible, while SOAP is more structured and standardized.
REST uses HTTP protocols and supports multiple data formats.
SOAP uses XML and requires a WSDL file for communication.
REST is better for mobile and web applications, while SOAP is better for enterprise-level applications.
REST is faster and easier to implement, while SOAP has more security features.
REST is stateless, while SOAP is stateful.
Filtering a list in JavaScript and C#
In JavaScript, use the filter() method to create a new array with all elements that pass the test implemented by the provided function.
In C#, use LINQ to filter a list using the Where() method.
Both languages require a callback function or lambda expression to define the filtering criteria.
Responsive web pages can be created by using flexible grids, media queries, and responsive images.
Use CSS frameworks like Bootstrap or Foundation
Design with mobile-first approach
Use relative units like em or rem instead of pixels
Use media queries to adjust layout based on screen size
Optimize images for different screen sizes
posted on 3 Jan 2025
I applied via Naukri.com and was interviewed in Dec 2024. There were 2 interview rounds.
I applied via Approached by Company and was interviewed in Dec 2024. There were 2 interview rounds.
I applied via Approached by Company and was interviewed in Oct 2024. There were 4 interview rounds.
Codility Test General C# and SQL
Create a class Employees with fields FirstName LastName, DoB, and Gender. Return avg age of employees and avg age by genders.
Create a class Employees with fields FirstName, LastName, DoB, and Gender
Calculate the average age of all employees
Calculate the average age by genders
I am familiar with design patterns such as Singleton, Factory, Observer, and MVC.
Singleton pattern ensures a class has only one instance and provides a global point of access to it.
Factory pattern creates objects without specifying the exact class of object that will be created.
Observer pattern defines a one-to-many dependency between objects so that when one object changes state, all its dependents are notified and up...
Optimizing SQL queries involves using indexes, minimizing data retrieval, avoiding unnecessary joins, and optimizing query structure.
Use indexes on columns frequently used in WHERE clauses
Minimize data retrieval by selecting only necessary columns
Avoid unnecessary joins by using EXISTS or IN clauses instead
Optimize query structure by using appropriate joins and subqueries
Types of indexes include clustered, non-clustered, unique, composite, and filtered indexes.
Clustered index: Physically reorders the data in the table based on the index key.
Non-clustered index: Contains a sorted list of references to the table data rows.
Unique index: Ensures that no two rows have the same values in the indexed columns.
Composite index: Index that is created on multiple columns.
Filtered index: Index that...
Yes, I have read SQL Execution Plans to optimize query performance.
I have analyzed SQL Execution Plans to identify bottlenecks in queries.
I have used SQL Execution Plans to optimize query performance by understanding how the database engine executes queries.
I have made query optimization recommendations based on SQL Execution Plans.
I have experience with tools like SQL Server Management Studio to view and analyze Execu
I applied via Campus Placement
It was a MCQ test on CS Fundamentals. We have to answer 50 questions in 40 minutes. Accuracy is must. Company have its own cutoff and it's usually high. So try to gain maximum marks as possible. The results were announced in 1.5 hrs. The selected candidates will be appearing for the coding challenge.
There are 5 questions. 1 easy , 3 medium, 1 hard. You should solve atleast 4 questions to get shortlisted for the interview. Results are announced in 2-3 hours. Take a look at these questions. One of the questions from the coding challenge will be asked in the interview.
4 member team interview
I applied via Job Portal and was interviewed in Oct 2024. There was 1 interview round.
I applied via Company Website and was interviewed in Jun 2024. There were 3 interview rounds.
Coding Test consists of 3 Problem Question (2 Logical questions and 1 SQL Query ) and Around 20 MCQS
Platform - CoderByte
30 Aptitude Question
3 Mail Writing Question
Solved a sorting problem by implementing quicksort algorithm.
Implemented quicksort algorithm to efficiently sort the array.
Used recursion to divide the array into smaller subarrays and sort them individually.
Optimized the algorithm by choosing a pivot element strategically to minimize comparisons.
The 3rd question based on SQL query likely refers to a specific query or scenario related to SQL.
Understand the context of the query being asked about
Analyze the structure and purpose of the SQL query
Explain the expected output or result of the query
Code to reverse digits of a number
Use modulo operator to extract the last digit of the number
Multiply the result by 10 and add the next digit until all digits are reversed
Handle negative numbers separately by converting to positive before reversing
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
The Hiring team and the trial team is very supportive, and the trial assignment was challenging and enjoyable. At First round the assignment is for design the Ai chat to Human chat process, that was very challenging, and I think best lesson I get from the assignment. and 2nd assignment to design and case study of the helplama website and i give best from my side and the team was very supportive and the work environment also best.
based on 5 reviews
Rating in categories
Software Developer
15
salaries
| ₹1.2 L/yr - ₹6 L/yr |
Software Engineer
5
salaries
| ₹3.7 L/yr - ₹6.3 L/yr |
Senior Software Developer
3
salaries
| ₹5.5 L/yr - ₹8.1 L/yr |
Exl India
Amazon Sellers Services
Primus Global Technologies
GAMMON INDIA