#techpointfundamentals

[techpointfundamentals]

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]

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

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

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:

[techpointfundamentals]

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

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:

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

[techpointfundamentals]

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:

[techpointfundamentals]

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:

[techpointfundamentals]

Angular Interview Questions and Answers: Part 08

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

Q084. What is the difference between Annotations vs. Decorators in Angular? Q085. What are the different types of Decorators in Angular? Q086. What are Class Decorators in Angular? What are the different types of class decorators in Angular? Q087. What are Method Decorators? What are the different types of method decorators in Angular? Q088. What are Property Decorators or Field Decorators? What are the different types of property decorators in Angular? Q089. What is the difference between @HostBinding vs. @HostListener decorators in Angular? Q090. What are Parameter Decorators in Angular? What are the different types of parameter decorators in Angular? Q091. What is @NgModule Decorator in Angular? Q092. What is @Component Decorator in Angular? Q093. What is @Injectable Decorator in Angular? Q094. What is @Directive Decorator in Angular? What are the different types of directives in Angular? Q095. What is @Pipe Decorator in Angular?

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

[techpointfundamentals]

[techpointfundamentals]

Angular Interview Questions and Answers: Part 13

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

Q149. What is Dependency Injection in Angular? What are the advantages of Dependency Injection? Q150. What are the different components of the Angular Dependency Injection Framework? How does dependency injection work in Angular? Q151. What do you mean by Hierarchical Dependency Injection in Angular? Q152. What is an Injector Tree? What are the different types of Injector Hierarchies in Angular? Q153. What is ModuleInjector Tree in Angular? How can you register services at the module level? Q154. What is the use of @Injectable decorator in Angular? What is root-level Service Registration? Q155. What is the root Module Injector in Angular? Q156. What is PlatforInjector in Angular? What is the difference between platform vs. root injector? Q157. What is the NullInjector in Angular? Q158. What is the difference between the @Injectable() vs @ngModule() service injector? Q159. What is the difference between Lazy Loaded vs Eagerly Loded service provider scope?

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

#angularpart13 #angularinterviewquestions #mostfrequentlyaskedangularquestions #angularfresherinterviewquestions #angularexperiencedinterviewquestions #commonangularinterviewquestions #angularinterview2023 #techpointfundamentals #techpointfunda #techpoint #crackjob #techpointblog

[techpointfundamentals]

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?

Please subscribe to the channel for more videos like this: https://www.youtube.com/c/TechPointFundamentals?sub_confirmation=1

[techpointfundamentals]

Angular Interview Questions and Answers: Part 11

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

Q122. What are Directives in Angular? When to use directive? Q123. What are the different types of directives in Angular? Q124. What is the use of the *ngFor directive? What is the difference between the *ngFor vs. ngForOf directive in Angular? Q125. What is the index property in *ngFor directive? What is the use of index property in *ngFor directive? Q126. What is the purpose of *ngFor trackBy in Angular? Q127. What is the use of the *ngIf directive in Angular? Q128. What is the difference between the *ngIfElse vs. *ngIf directive in SQL? Q129. How can you use both *ngFor and *ngIf directives together on the same element? Q130. What is the difference between the *ngIf directive vs. hidden property in Angular? Q131. What is the use of the *ngSwitch directive? Q132. What is the difference between the *ngStyle vs. *ngClass directive in Angular? Q133. What is the use of ng-template in Angular? Q134. What is the use of the ngModel directive in Angular? What is the "banana-in-a-box" syntax in Angular? Q135. What is the difference between the (ngModel) vs [ngModel] vs [(ngModel)] directive in Angular?

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

[techpointfundamentals]

Retrieving Data from Dynamic Schema in SQL:

What is three part identifier in SQL? What is schema name in SQL? How can you check schema names in SQL? How can you write a stored procedure that accepts schema name as input parameters and returns data from the provided schema only?

Please subscribe to the channel for more videos like this:

https://www.youtube.com/c/TechPointFundamentals?sub_confirmation=1

[techpointfundamentals]

Tech Point's Available Posts List:

Please find our all the available posts here:

[techpointfundamentals]

Different Types of SQL JOINs:

Q01: What is INNER JOIN? Q02: What is NON-ANSI JOIN? Q03: What is ANSI JOIN? Q04: What is SELF JOIN? Q05: What is OUTER JOIN? Q06: What is LEFT OUTER JOIN? Q07: What is RIGHT OUTER JOIN? Q08: What is FULL OUTER JOIN? Q09: What is CROSS JOIN? Q10: What is the difference between FULL JOIN vs CROSS JOIN?