Celigo SDE Interview Questions and Answers

30 min exam online test with easy and medium leetcode questions. Precisely Bulls and Cow problem and remove K digits leetcode questions

Q1. Design book my show
Add your answer
Q2. How will structure data base
Ans. 
Structuring a database involves organizing data into tables, defining relationships, and setting up constraints.
• Identify entities and attributes to create tables

• Define relationships between tables using keys

• Set up constraints like primary keys, foreign keys, and unique constraints

• Normalize data to reduce redundancy and improve efficiency

• Consider indexing for faster data retrieval

• Use data types appropriate for each colu
Answered by AI
Add your answer

Q1. What is oops concepts
Ans. 
Object-oriented programming concepts that focus on data encapsulation, inheritance, polymorphism, and abstraction.
• Encapsulation: Bundling data and methods that operate on the data into a single unit (class).

• Inheritance: Ability of a class to inherit properties and behavior from another class.

• Polymorphism: Ability to present the same interface for different data types.

• Abstraction: Hiding the complex implementation detai...read more
Answered by AI
Add your answer

Q1. 1. I was asked to create bst from preorder and inorder 2. Basic OOPs concepts 3. Question on finding the highest profit after selling the stocks
Add your answer
Q2. 4. Question from projects
Add your answer

Q1. Questions on React, virtual DOM and basic questions on javascript DSA questions included Linked List reversal and find a cycle in linked list
Add your answer

Asked about Parking LOT coding question in VM

Q1. About yourself?
Add your answer
Q2. Delegates
Add your answer
Q3. Linq
Add your answer
Q4. ORMs
Add your answer
Q5. OOPS
Add your answer

Q1. Very fundamental questions were out of programming language like what is Like class vs object, instances vs object, why do we rather write our code in OOPS supported languages than procedural programming l...read more
Add your answer
Q2. In the context of Dot Net Framework, What is DotNet vs Dot Net Framework? Why do use it? What is role of DI,Service Lifetime scope ?
Ans. 
DotNet is a platform while Dot Net Framework is a software framework built on top of it.
• DotNet is a platform that provides a runtime environment for executing applications.

• Dot Net Framework is a software framework built on top of DotNet platform.

• Dot Net Framework provides a set of libraries and tools for developing and running applications.

• Dependency Injection (DI) is a design pattern used to implement Inversion of Con...read more
Answered by AI
Add your answer
Q3. Explain Task Parallel Library
Ans. 
Task Parallel Library is a .NET framework that enables parallel processing of tasks.
• TPL provides a higher-level abstraction for parallelism than traditional threading models.

• It includes features like Task and Task classes, Parallel.ForEach and Parallel.Invoke methods.

• TPL can improve performance by utilizing multiple cores and processors.

• TPL also includes cancellation and exception handling mechanisms.

• Example: Parallel....read more
Answered by AI
Add your answer