Crack Job

SQL Merge Statement - EVIL or DEVIL:

Q01. What is the MERGE Statement in SQL? Q02. Why separate MERGE statements if we have already INSERT, UPDATE, and DELETE commands? Q03. What are the different databases that support the SQL MERGE Statement? Q04. What are the different MERGE Statement Scenarios for DML? Q05. What are the different supported MERGE Statement Clauses in MSSQL? Q06. What will happen if more than one row matches the MERGE Statement? Q07. What are the fundamental rules of SQL MERGE Statement? Q08. What is the use of the TOP and OUTPUT clauses in the SQL Merge Statement? Q09. How can you use the Merge Statement in MSSQL? Q10. How does the SQL MERGE command work in MSSQL? Q11. How can you write the query for the SQL Merge? Q12. Is SQL MERGE Statement Safe to use?

Angular Interview Questions and Answers: Part 14

Q160. How can you register a service at Component Level in Angular? Q161. How can you register a service at the Module Level in Angular? Q162. What is the difference between providing services in Modules vs Components? Q163. How can you register a service into another service in Angular? Q164. What is the Service Scope in Angular? Q165. What is the difference between the service registered as root vs platform type in the ProvidedIn property of Angular? Q166. What is the difference between a service registered as "root" vs "any" type in the ProvidedIn property of Angular? Q167. What is the difference between providedIn: root vs forRoot() pattern in Angular? Q168. What are the different ways to create Singleton Services in Angular? Q169. What is an Element Injector Tree in Angular? Q170. What is the Merge Injector in Angular?

Please visit the following link for the Answers of the above Angular Interview Questions:

SQL Merge Statement - EVIL or DEVIL:

Q01. What is the MERGE Statement in SQL? Q02. Why separate MERGE statements if we have already INSERT, UPDATE, and DELETE commands? Q03. What are the different databases that support the SQL MERGE Statement? Q04. What are the different MERGE Statement Scenarios for DML? Q05. What are the different supported MERGE Statement Clauses in MSSQL? Q06. What will happen if more than one row matches the MERGE Statement? Q07. What are the fundamental rules of SQL MERGE Statement? Q08. What is the use of the TOP and OUTPUT clauses in the SQL Merge Statement? Q09. How can you use the Merge Statement in MSSQL? Q10. How does the SQL MERGE command work in MSSQL? Q11. How can you write the query for the SQL Merge? Q12. Is SQL MERGE Statement Safe to use?

C# Interview Questions and Answers - Part 19:

Q184. What is the difference between Routing in ASP .Net Core 2.0 and ASP .Net Core 3.0? Q185. What is End Point? What is End Point Routing in ASP .Net Core? Q186. How does the End Point Routing work in ASP .Net Core MVC? Q187. How can you define endpoints in ASP .Net Core? Q188. What is UseEndpoints() middleware in ASP .Net MVC Core? Q189. What is POST Tunneling Middleware in ASP .NET Core? What is UseHttpMethodOverride() middleware in ASP .Net Core? Q190. How can you enforce HTTPS in ASP .NET Core Project? Q191. What is OWIN? How can you use OWIN in ASP .NET Core? Q192. What is SignalR in ASP .NET Core? Q193. What is a Secret Manager in ASP .Net Core?

Dynamic Data Sorting in SQ L( Dynamic Order By Clause in SQL)

How can you sort the data based on the parameterized column names in SQL?

How can you write a stored procedure that accepts column name as input parameter and returns data sorted based on the the provided column?

Difference Between Constructor vs NgOnInit in Angular:

Q01. What is the order precedence of the constructor and ngOnInit() execution in Angular? Q02. What is a constructor in Angular? Q03. What is ngOnInit() in Angular? Q04. What is the Lifecycle hook in Angular? Q05. What is the difference between constructor vs ngOnInit() in Angular?

Please visit the following link for the answers:

Difference Between Constructor vs NgOnInit in Angular:

Q01. What is the order precedence of the constructor and ngOnInit() execution in Angular? Q02. What is a constructor in Angular? Q03. What is ngOnInit() in Angular? Q04. What is the Lifecycle hook in Angular? Q05. What is the difference between constructor vs ngOnInit() in Angular?

Please visit the following link for the answers:

Difference Between React vs. Angular:

Q01. What is Angular? Q02. What is React? Q03. What is the difference between React vs. Angular? Q04. What are the similarities between React and Angular? Q05. Why one should use React over Angular or vice-versa? Q06. What does React have over Angular? Q07. What does Angular have over React?

Angular Interview Questions and Answers: Part 12

This is the 12th part of the Angular Interview Questions and Answers Series. In this part we will discuss the answers of the following Angular Questions:

Q136. What is data binding in Angular? Which type of data binding does Angular use? Q137. What are the different types of data binding used in Angular? Q138. What is Property Binding in Angular? What is the use of [] or square box in Angular? Q139. What is Attribute Binding in Angular? What is the difference between Property Binding vs Attribute Binding in Angular? Q140. What is the difference between colspan vs. colSpan (camel case) in Angular? Q141. What is String Interpolation in Angular? Q142. What is Event Binding in Angular? What is the use of $event payload in Angular? Q143. What is a Template Reference Variable in Angular? Q144. What is the difference between Property Binding vs. Event Binding? Q145. Can you use angular interpolation in the place of property binding? Q146. What is two-way data binding in Angular? What are the disadvantages of two-way data binding? Q147. What is the difference between (change) vs. (ngModelChange) events in Angular? Q148. What is the difference between [ngModel] vs. [(ngModel)] in Angular?

Please visit the following link for the Answers of the above Angular Interview Questions:

Dependency Inversion Principle of SOLID Principle:

Q01. What is Dependency Inversion Principle (DIP) of SOLID? Q02. What is Inversion of Control (IoC)? Q03. What is Dependency Injection (DI)? Q04. What is IoC Container? Q05. What is Coheson vs Coupling?

Different Types of SQL JOINs:

Tech Point's Available Posts List: