Kellton Interview Questions and Answers

Q1. What is Sql joins, cte, Sp vs function, user defined types,
Ans. 
SQL joins are used to combine rows from two or more tables based on a related column between them.
• SQL joins are used to retrieve data from multiple tables based on a related column.

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• CTE (Common Table Expression) is a temporary result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.

• Stored Procedures (SP) are pre...read more
Answered by AI
View 2 more answers
Q2. C# interfces, opps concepts, DI, asp page life cycle
Add your answer
Q3. Ado. Net & entity frework difference
Ans. 
ADO.NET is a data access technology while Entity Framework is an ORM framework for data access in .NET applications.
• ADO.NET is a set of classes used to interact with data sources like databases directly.

• Entity Framework is an ORM framework that allows developers to work with data in terms of objects and classes.

• ADO.NET requires writing SQL queries manually, while Entity Framework allows querying data using LINQ.

• Entity ...read more
Answered by AI
Add your answer

Q1. How to manage memory management in Python?
Ans. 
Memory management in Python involves automatic memory allocation and deallocation through garbage collection.
• Python uses automatic memory management through garbage collection, so manual memory management is not required.

• Use tools like memory_profiler to identify memory leaks and optimize memory usage.

• Avoid creating unnecessary objects and use data structures efficiently to minimize memory usage.
Answered by AI
Add your answer
Q2. Difference between Async , Sync and multithread?
Ans. 
Async is non-blocking, Sync is blocking, Multithread allows multiple threads to run concurrently.
• Async allows the program to continue executing other tasks while waiting for a response, commonly used in web development with AJAX calls.

• Sync blocks the program until a task is completed, commonly used in simple sequential programs.

• Multithreading allows multiple threads to run concurrently, improving performance by utilizi...read more
Answered by AI
Add your answer
Q3. CI/CD pipeline deployment?
Ans. 
CI/CD pipeline automates software deployment, ensuring faster delivery and higher quality through continuous integration and continuous delivery.
• CI/CD stands for Continuous Integration and Continuous Deployment.

• Continuous Integration involves automatically testing and merging code changes into a shared repository.

• Continuous Deployment automates the release of code changes to production after passing tests.

• Tools like Je...read more
Answered by AI
Add your answer
Q4. How to revert last commit?
Ans. 
Use 'git revert' command to revert the last commit.
• Use 'git log' to find the commit hash of the last commit

• Run 'git revert ' to revert the last commit

• Commit the revert changes with a new commit message
Answered by AI
Add your answer
Q5. Difference between select_related vs prefetch_related with example?
Ans. 
select_related follows foreign key relationships and retrieves related objects in a single query, while prefetch_related retrieves related objects separately to avoid performance issues.
• select_related is used for accessing related objects in a single query, reducing database hits

• prefetch_related is used for accessing related objects separately to avoid performance issues

• select_related is more efficient for one-to-one o...read more
Answered by AI
Add your answer
Q6. What is decorater write example?
Ans. 
Decorator is a design pattern in software development that allows behavior to be added to individual objects, either statically or dynamically.
• Decorators are used to modify the behavior of functions or classes without changing their source code.

• In Python, decorators are implemented using the @ symbol followed by the decorator function name.

• Example: @decorator_function def some_function(): # function implementation

• ...read more
Answered by AI
Add your answer
Q7. How to optimise query?
Ans. 
Optimizing query involves indexing, minimizing data retrieval, using proper joins, and avoiding unnecessary functions.
• Use indexes on columns frequently used in WHERE clauses

• Minimize data retrieval by selecting only necessary columns

• Use proper joins (INNER JOIN, LEFT JOIN, etc.) instead of subqueries

• Avoid unnecessary functions in WHERE clauses
Answered by AI
Add your answer
Q8. What is normalisation?
Ans. 
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization is used to eliminate redundant data and ensure data dependencies are logical.

• It involves dividing a database into two or more tables and defining relationships between them.

• Normalization helps in reducing data redundancy, improving data integrity, and making data maintenance easier.

• There are diffe...read more
Answered by AI
Add your answer
Q9. How to increase performance?
Ans. 
To increase performance, optimize code, use efficient algorithms, parallel processing, caching, and database indexing.
• Optimize code by reducing unnecessary loops and improving data structures

• Use efficient algorithms like binary search instead of linear search

• Implement parallel processing to utilize multiple CPU cores

• Utilize caching to store frequently accessed data for faster retrieval

• Implement database indexing to spe...read more
Answered by AI
Add your answer
Q10. How to secure your API’s?
Ans. 
Securing APIs involves using authentication, authorization, encryption, and monitoring.
• Implement authentication mechanisms such as OAuth, JWT, or API keys to verify the identity of clients accessing the API.

• Use authorization to control access to different parts of the API based on roles and permissions.

• Encrypt data transmitted between clients and the API using HTTPS to prevent eavesdropping.

• Implement rate limiting and ...read more
Answered by AI
Add your answer
Q11. How single design patterns work?
Ans. 
Single design patterns work by providing a reusable solution to common problems in software development.
• Design patterns help in organizing code and making it more maintainable.

• They promote code reusability and flexibility.

• Examples of single design patterns include Singleton, Factory, and Observer.
Answered by AI
Add your answer

Q1. Questions from your resume.
Add your answer

Q1. Salary discussion and your tenure employments.
Add your answer

Q1. D/f b/w regression and retesting?
Ans. 
Regression testing is done to ensure that new code changes have not adversely affected existing functionality, while retesting is done to verify that a specific bug has been fixed.
• Regression testing is performed after code changes to ensure that existing functionality still works as expected.

• Retesting is performed to verify that a specific bug has been fixed.

• Regression testing is broader in scope and covers multiple fu...read more
Answered by AI
Add your answer
Q2. D/f b/w Put and Patch method in API?
Ans. 
Put method is used to create or update a resource, while Patch method is used to update a resource partially.
• Put method is idempotent, meaning multiple identical requests will have the same effect as a single request.

• Patch method is not necessarily idempotent, as multiple identical requests may have different effects.

• Put method requires the client to send the entire resource representation in the request body.

• Patch met...read more
Answered by AI
Add your answer

Q1. Can you provide details about your previous projects?
Ans. 
I have worked on various projects including developing a new software system for a manufacturing company and implementing a data analytics platform for a financial institution.
• Developed a new software system for a manufacturing company to streamline production processes

• Implemented a data analytics platform for a financial institution to improve decision-making

• Led a team in designing and deploying a cloud-based solution...read more
Answered by AI
Add your answer

Aptitude test was easy and I was passed in one attempt

Q1. Technical questions regarding the project done
Add your answer
Q2. Regarding agile and scrumprocess
Add your answer
Q3. Regarding rsume
Add your answer
Q4. Hr discussion ha done
Add your answer

Q1. Related to Your Work ex
Add your answer
Q2. Related to your profile
Add your answer