Derivco Intermediate Software Engineer interview questions

** C# ** Delegate => A delegate is a type that represents references to methods with a particular parameter list and return type Yield => used in loops for IEnumerable it will return for each iteration (statefull iteration) Difference Abstract class and interface => Abstract will have implementation and sub-classes can override. Interface just contract Conflict between 2 interfaces => create a third interface with that property and these 2 interface should implement the new interface Difference continue and break Access modifiers => internal, public, protected, private OOP principals => Encapsulation, Abstraction, Inheritance, Polymorphism SOLID principles What is Queue messaging service => async service to service Sinchronization c# => Synchronization in C# is a mechanism that makes sure only one process or thread accesses the critical section of the program Explain Await and Async Difference between "await task" and task.await Difference thread and process => One or more threads run in the context of the process anonymous function c# => An anonymous function is an "inline" statement or expression . Can use anonymous method or lambda to create an anonymous function What is Singleton Pattern => only allows a single instance of itself to be created ** Client ** What is CSS How to trobleshoot an error if app spins and get stuck Problem above having acess to the server Difference local and session storage Typescript Ranges of errors => 1xx informal, 2xx sucess, 3xx redirects, 4xx client error, 5xx server error Error 503 => server unavailable Difference among 1, 2 and 3 equals (===) => 3 compares type Difference between undefined and null javascript => undefined is a value and null is considered as object What is a Web Component => Web components are a set of web platform APIs that allow you to create new custom, reusable, encapsulated HTML tags to use in web pages and web apps. What is DOM => The Document Object Model (DOM) is the data representation of the objects that comprise the structure and content of a document on the web. This guide will introduce the DOM, look at how the DOM represents an HTML document in memory and how to use APIs to create web content and applications 2 way binding in javascript => set state react hooks Promisse => A promise is an object that may produce a single value some time in the future SQL Merge command => source and target table to update/insert/delete in same statement Which are the joins in SQL Server => inner, left, right, cross, full What are triggers and down side of them Ways of handling error in store procedures Difference clustered and non-clustered index What is an execution plan begin tran and rollback in nested procedure