Decimal Point Analytics Software Development Engineer Interview Questions and Answers

Q1. Related To MVC view bag,filters, routing etc
Add your answer

Q1. Personal details and little bit from technical
Add your answer

Q1. Simple Array Coding Question
Add your answer

Q1. .Net MVC questions like Session Management, Dependency Injection.
Add your answer
Q2. OOPS concepts. Most of the questions were around Abstraction and Encapsulation
Add your answer

Q1. Salary Disucssion and Date of Joining
Add your answer

Q1. Basic c#and MVC architecture, partial view, singleton class
Add your answer
Q2. Index ,view, optimisation techniques in database
Ans. 
Indexing, viewing, and optimization techniques are essential for improving database performance.
• Use indexes to quickly retrieve data from tables

• Regularly analyze and optimize queries for better performance

• Utilize views to simplify complex queries and improve readability

• Consider partitioning tables for better manageability and performance

• Use tools like explain plans to analyze query performance
Answered by AI
Add your answer

Q1. Difference in MVC and ado.net, filters in MVC, resultset in mvc
Ans. 
MVC is a design pattern for organizing code in web applications, while ADO.NET is a data access technology for connecting to databases.
• MVC stands for Model-View-Controller and helps in separating concerns in web applications.

• ADO.NET is a data access technology in .NET framework for connecting to databases.

• Filters in MVC are used to add pre-processing or post-processing logic to controller actions.

• Resultset in MVC refer...read more
Answered by AI
Add your answer
Q2. Rank functions in SQL server
Ans. 
Functions in SQL server can be ranked based on their usage, complexity, and performance.
• Rank functions based on usage - COUNT, SUM, AVG, MAX, MIN

• Rank functions based on complexity - CASE, COALESCE, ISNULL

• Rank functions based on performance - ROW_NUMBER, RANK, DENSE_RANK
Answered by AI
Add your answer

Q1. Basic on .net like oops, dapper, etc
Add your answer

Q1. Typical questions about your experience, technical background and working knowledge relevant to their technical stack.
Add your answer
Q2. Tell me about your experience in network security.
Add your answer
Q3. Tell me about your experience in Java and Springboot.
Add your answer

1 coding test having a DP question and some spark based questions.

Q1. Fibonacci using DP
Ans. 
Fibonacci using Dynamic Programming
• Use an array to store calculated Fibonacci numbers to avoid redundant calculations

• Start with base cases of 0 and 1, then iterate to calculate subsequent Fibonacci numbers

• Time complexity can be reduced from exponential to linear using DP
Answered by AI
Add your answer
Q2. SQL questions ( ranks and partition)
Add your answer

Q1. Design based questions
Add your answer