#techpointfunda

[techpointfundamentals]

SQL Merge Statement - EVIL or DEVIL

sql merge, merge statement, merge command, table merge in sql, evils of merge, crack job, tech point fundamentals, sql merge query, devils of merge

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?

Please visit the following link for the answers:

[crackjob]

Difference Between Interface vs. Abstract Class in .Net Core

difference between abstract class vs interface in .net core, interface vs abstract class in .net core, .net core interface, abstract class,

Interface vs. Abstract Class in .Net Core:

Q01. What is the use of Abstract Class and Interface in .Net? Q02. What is Abstract Class in .Net? Q03. What is Interface in .Net? Q04. What are the current fundamental rules of using Abstract Class in .Net? Q05. What are the things that are allowed in an Abstract Class? Q06. What are the things that are not allowed in an Abstract Class? Q07. What is the difference between the traditional Interface and the current .Net Core Interface? Q08. What are the new features allowed in the current .Net Core Interface?? Q09. What are the features that are not allowed in the .Net Core Interface? Q10. What are the similarities between Abstract Class and C# 8 Interface? Q11. What is the difference between Abstract Class and Interface? Q12. If both Abstract Classes and Interfaces are used for abstraction, what distinguishes them? Q13. What are the recent features introduced for the interface in .Net?

[techpointfundamentals]

SQL Temporary Table | Temp Table | Global vs Local Temp Table

sql temp table, temporary table interview question, local temp table, global temp table, temp table vs table variable, temp table vs derived

SQL Temporary Table | Temp Table | Global vs Local Temp Table

Q01. What is a Temp Table or Temporary Table in SQL? Q02. Is a duplicate Temp Table name allowed? Q03. Can a Temp Table be used for SELECT INTO or INSERT EXEC statement? Q04. What are the different ways to create a Temp Table in SQL? Q05. What is the difference between Local and Global Temporary Table in SQL? Q06. What is the storage location for the Temp Tables? Q07. What is the difference between a Temp Table and a Derived Table in SQL? Q08. What is the difference between a Temp Table and a Common Table Expression in SQL? Q09. How many Temp Tables can be created with the same name? Q10. How many users or who can access the Temp Tables? Q11. Can you create an Index and Constraints on the Temp Table? Q12. Can you apply Foreign Key constraints to a temporary table? Q13. Can you use the Temp Table before declaring it? Q14. Can you use the Temp Table in the User-Defined Function (UDF)? Q15. If you perform an Insert, Update, or delete operation on the Temp Table, does it also affect the underlying base table? Q16. Can you TRUNCATE the temp table? Q17. Can you insert the IDENTITY Column value in the temp table? Can you reset the IDENTITY Column of the temp table? Q18. Is it mandatory to drop the Temp Tables after use? How can you drop the temp table in a stored procedure that returns data from the temp table itself? Q19. Can you create a new temp table with the same name after dropping the temp table within a stored procedure? Q20. Is there any transaction log created for the operations performed on the Temp Table? Q21. Can you use explicit transactions on the Temp Table? Does the Temp Table hold a lock? Does a temp table create Magic Tables? Q22. Can a trigger access the temp tables? Q23. Can you access a temp table created by a stored procedure in the same connection after executing the stored procedure? Q24. Can a nested stored procedure access the temp table created by the parent stored procedure? Q25. Can you ALTER the temp table? Can you partition a temp table? Q26. Which collation will be used in the case of Temp Table, the database on which it is executing, or temp DB? What is a collation conflict error and how you can resolve it? Q27. What is a Contained Database? How does it affect the Temp Table in SQL? Q28. Can you create a column with user-defined data types (UDDT) in the temp table? Q29. How many concurrent users can access a stored procedure that uses a temp table? Q30. Can you pass a temp table to the stored procedure as a parameter?

[techpointfundamentals]

Angular Interview Questions and Answers - Part 14

angular interview questions, most frequently asked angular questions, angular fresher interview questions, angular experienced interview que

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:

Angular Interview Questions and Answers - Part 14

angular interview questions, most frequently asked angular questions, angular fresher interview questions, angular experienced interview que

[techpointfundamentals]

Difference Between React vs. Angular

react interview questiosn and answer, react vs. angular, angular vs. react, similerties between angular and react, difference between angular vs react

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?

#crackjob  #techpoint #techpointfunda #techpointfundamentals #reactvsangular #angularvsreact #angularinterview #reactinterview

[techpointfundamentals]

Angular Interview Questions and Answers - Part 12

angular interview questions, most frequently asked angular questions, angular fresher interview questions, angular experienced interview que

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:

Angular Interview Questions and Answers - Part 12

angular interview questions, most frequently asked angular questions, angular fresher interview questions, angular experienced interview que

#angularpart12 #angularinterviewquestions #mostfrequentlyaskedangularquestions #angularfresherinterviewquestions #angularexperiencedinterviewquestions #commonangularinterviewquestions #angularinterview2023 #techpointfundamentals #techpointfunda #techpoint #techpointblog

[techpointfundamentals]

Angular Interview Questions and Answers - Part 10

angular interview questions, most frequently asked angular questions, angular fresher interview questions, angular experienced interview que

Angular Interview Questions and Answers: Part 10

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

Q110. What are the Components in Angular? How can you create a component in Angular? Q111. What are Modules in Angular? What are the advantages of modules in Angular? Q112. What is declarable in Angular? Where it is defined in Angular? Q113. What are the different types of Modules in Angular? Q114. What is the difference between RootModule vs FeatureModule in Angular? Q115. What is CommonModule in Angular? What is the difference between CommonModule vs BrowserModule in Angular? Q116. What will happen if browserModule is used in a Feature Module? Q117. What will happen if you import the same module twice in Angular? How can you avoid circular module dependency in Angular? Q118. What is the difference between a Component vs. Module in Angular? Q119. What is the difference between Component vs. Directive in Angular? Q120. What is the difference between NgModule vs. JavaScript Module? Q121. How does Angular find components, directives, and pipes in a template? What is a template reference?

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

Angular Interview Questions and Answers - Part 10

angular interview questions, most frequently asked angular questions, angular fresher interview questions, angular experienced interview que

[techpointfundamentals]

Angular Interview Questions and Answers - Part 09

angular interview questions, most frequently asked angular questions, angular fresher interview questions, angular experienced interview que

Angular Interview Questions and Answers: Part 09

Q096. What are the differences between @Component vs. @NgModule vs. @Directive decorator in Angular? Q097. What is @Inject Decorator in Angular? Q098. What is the difference between @Inject() vs. @Injectable() in Angular? Q099. What is @Input Decorator in Angular? Q100. What is @Output Decorator in Angular? Q101. What is Content Projection in Angular? What is the use of ng-content in Angular? Q102. What is the difference between @ContentChild vs. @ContentChildren decorators in Angular? Q103. What is the difference between @ViewChild vs. @ViewChildren decorator in Angular? Q104. What is the use of @HostBinding Decorator in Angular? How it is different from @HostListener? Q105. What is @Host Decorator in Angular? What is the difference between @Host vs. @Self decorator? Q106. What is the use of @Self Decorator in Angular? Q107. What is the use of @SkipSelf Decorator in Angular? Q108. What is @Optional Decorator in Angular? What is the use of @Optional Decorator in Angular? Q109. What is the difference between @Self vs. @SkipSelf vs. @Optional decorator in Angular?

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

Angular Interview Questions and Answers - Part 09

angular interview questions, most frequently asked angular questions, angular fresher interview questions, angular experienced interview que