SQL Interview Questions and Answers - Part 12:
------------------------------------------------------------------

Q100. How can you return value from a stored procedure?
Q101. What is a temporary stored procedure? What is the use of a temp stored procedure?
Q102. What is the difference between recursive vs nested stored procedures?
Q103. What is the use of the WITH RECOMPILE option in the stored procedure? Why one should use it?
Q104. How can you ENCRYPT and DECRYPT the stored procedure?
Q105. How can you improve the performance of a stored procedure?
Q106. What is SCHEMABINDING in stored procedure? If all the stored procedures are bounded to the schema by default, then why do we need to do it explicitly?
Q107. How can you write a stored procedure which executes automatically when SQL Server restarts?
Q108. Is stored procedure names case-sensitive?
Q109. What is CLR stored procedure? What is the use of the CLR procedure?
Q110. What is the use of EXECUTE AS clause in the stored procedure?


https://www.techpointfunda.com/2022/08/sql-interview-part-12.html


#sqlinterviewquestions #mostfrequentlyaskedsqlinterviewquestions #sqlinterviewquestionsandanswers #interviewquestionsandanswers #techpointfundamentals #techpointfunda #techpoint #sql #database #interview


Please visit www.techpointfunda.com for more Interview Questions and Answers.

C# Interview Questions and Answers - Part 13:
------------------------------------------------------------------


Q131. What is TPL in the .Net? Why TPL is required in C#?
Q132. What is the difference between ForEach and Parallel.ForEach loop in C#?
Q133. What is the difference between Standard For Loop and Parallel.For Loop in C#?
Q134. What is the difference between task, process, and thread?
Q135. What is Multi-threading? What is the difference between Multi-threading vs MultiTasking or Multi-threading vs Concurrency?
Q136. What is the difference between Concurrency and Parallelism? Are they same as async programming?
Q137. What is asynchronous programming? What is the use of async and await keywords in C#?
Q138. What is a Task in C#? What is the difference between task and thread?
Q139. What is synchronization and why it is important?
Q140. What is the difference between Join and Lock synchronization?



https://www.techpointfunda.com/2022/08/csharp-interview-questions-part-13.html


#CSharpInterviewQuestionsAndAnswers #CSharpInterviewQuestions2022 #CSharpInterview #InterviewPreparation #InterviewQuestionsAndAnswers #techpointfundamentals #techpointfunda #techpoint #interview #csharpprogramming #csharp #csharpdeveloper #csharpdotnet


Please visit www.techpointfunda.com for more Interview Questions and Answers.

SQL Interview Questions and Answers - Part 13:
------------------------------------------------------------------

Q111. What is SQL Function? What are the different types of functions in SQL?
Q112. What is the difference between Deterministic and Non-Deterministic SQL Functions?
Q113. What are the different System SQL Functions?
Q114. What is User Defined Function (UDF) in SQL? What is the advantage of UDF in SQL?
Q115. What are the features and limitations of User-Defined SQL Functions (UDF)?
Q116. What are the different Scalar User-Defined SQL Functions?
Q117. What are the different Table-Valued UDF in SQL?
Q118. What is Schema Bound function in SQL? What is the advantage of schema-bound functions?
Q119. What is the difference between Stored Procedure and User-Defined Function in SQL?
Q120. What is the difference between Table-Valued Functions and View in SQL?


https://www.techpointfunda.com/2022/08/sql-interview-part-13.html


#sqlinterviewquestions #mostfrequentlyaskedsqlinterviewquestions #sqlinterviewquestionsandanswers #interviewquestionsandanswers #techpointfundamentals #techpointfunda #techpoint #sql #database #interview


Please visit www.techpointfunda.com for more Interview Questions and Answers.

C# Interview Questions and Answers - Part 14:
------------------------------------------------------------------

Q141. What is the difference between Mutex and Monitor?
Q142. What is Semaphore C#? How does the Semaphore work?
Q143. What is deadlock? How can you prevent deadlock in C#?
Q144. What do you mean by thread-safe? How can you share data between multiple threads?
Q145. How can you retrieve data from a thread? What is a callback method?
Q146. What is Annonumous Method in C#?
Q147. What is Lambda Expression in C#?
Q148. What is a thread? What is the thread life cycle or different states of a thread?
Q149. What is the difference between task.wait(), task.delay(), and thread.sleep() in C#?
Q150. What is string interpolation in C#?


https://www.techpointfunda.com/2022/08/csharp-interview-questions-part-14.html


#CSharpInterviewQuestionsAndAnswers #CSharpInterviewQuestions2022 #CSharpInterview #InterviewPreparation #InterviewQuestionsAndAnswers #techpointfundamentals #techpointfunda #techpoint #interview #csharpprogramming #csharp #csharpdeveloper #csharpdotnet


Please visit www.techpointfunda.com for more Interview Questions and Answers.

SQL Interview Questions and Answers - Part 14:
------------------------------------------------------------------

Q121. What is View in SQL?
Q122. What are the Advantages and Disadvantages of view?
Q123. What are the different types of views in SQL?
Q124. What is Schema Bounded View? What are its advantages?
Q125. What is Indexed View or Materialized View in SQL?
Q126. What is a Partitioned View? What is its use in SQL?
Q127. Can you UPDATE or DELETE the records from View? What is the updatable view?
Q128. Can you add the Primary Key Constraint in the View?
Q129. What is the difference between a View and Table?
Q130. What is the difference between View and Temp Table?


https://www.techpointfunda.com/2022/04/sql-interview-part-14.html


#sqlinterviewquestions #mostfrequentlyaskedsqlinterviewquestions #sqlinterviewquestionsandanswers #interviewquestionsandanswers #techpointfundamentals #techpointfunda #techpoint #sql #database #interview


Please visit www.techpointfunda.com for more Interview Questions and Answers.

C# Interview Questions and Answers - Part 15:
------------------------------------------------------------------

Q151. What is the difference between generic and non-generic collections? Why do we need generic collections?
Q152. What is ArrayList? What is the difference between array and ArrayList?
Q153. What is Dictionary? What is the difference between a List and Dictionary?
Q154. What is HashTable? What is the difference between HashTable and Dictionary?
Q155. What is Stack? What are the applications of Stack? What is the difference between the Peek() and Pop() operations?
Q156. What is Queue? What are the applications of Queue? What is the difference between Dequeue() and Peek() operations?
Q157. What is Heap? What are the applications of Heap?
Q158. What is Linked List in C#?
Q159. What is the difference between class and object?
Q160. What is the use of optional parameters? Can you overload two methods based on optional Parameters?


https://www.techpointfunda.com/2022/08/csharp-interview-questions-part-15.html


#CSharpInterviewQuestionsAndAnswers #CSharpInterviewQuestions2022 #CSharpInterview #InterviewPreparation #InterviewQuestionsAndAnswers #techpointfundamentals #techpointfunda #techpoint #interview #csharpprogramming #csharp #csharpdeveloper #csharpdotnet


Please visit www.techpointfunda.com for more Interview Questions and Answers.

SQL Interview Questions and Answers - Part 15:
------------------------------------------------------------------

Q131. What is a Trigger in SQL?
Q132. What are the Advantages and Disadvantages of Triggers in SQL?
Q133. What are the different types of Triggers available in SQL?
Q134. What is DML Trigger in SQL? What is the application of DML Triggers?
Q135. What is AFTER or FOR TRIGGER in SQL? What is the use of AFTER DML Trigger?
Q136. What is INSTEAD OF TRIGGER in SQL? How can you use the INSTEAD OF Trigger to update the VIEW?
Q137. What is DDL TRIGGER in SQL? What is the application of DDL Triggers?
Q138. What is LOGON TRIGGER in SQL? What is the application of LOGON Triggers?
Q139. What is the difference between Recursive Trigger and Nested Trigger in SQL?
Q140. What are the MAGIC TABLES in SQL? What is the use of INSERTED and DELETED tables in SQL?


https://www.techpointfunda.com/2022/09/sql-interview-part-15.html


#sqlinterviewquestions #mostfrequentlyaskedsqlinterviewquestions #sqlinterviewquestionsandanswers #interviewquestionsandanswers #techpointfundamentals #techpointfunda #techpoint #sql #database #interview


Please visit www.techpointfunda.com for more Interview Questions and Answers.

SQL Interview Questions and Answers - Part 15:
------------------------------------------------------------------

Q141. What is the Cursor in SQL?
Q142. What is the Cursor Life Cycle in SQL?
Q143. What are the different types of Cursors in SQL?
Q144. What is the Static Cursor or InSensitive Cursor in SQL?
Q145. What is the Dynamic Cursor in SQL?
Q146. What is the Forward Only Cursor or Firehouse Cursor in SQL? What is the difference between Forward-Only and Fast Forward Cursor?
Q147. What is the KeySet Cursor in SQL?
Q148. What are the advantages and applications of Cursors in SQL?
Q149. What are the disadvantages or limitations of Cursors in SQL?
Q150. What is the difference between Loop and Cursor?
Q151. How you can avoid the cursor in SQL? What are the different alternatives of Cursor in SQL?


https://www.techpointfunda.com/2022/09/sql-interview-part-16.html


#sqlinterviewquestions #mostfrequentlyaskedsqlinterviewquestions #sqlinterviewquestionsandanswers #interviewquestionsandanswers #techpointfundamentals #techpointfunda #techpoint #sql #database #interview


Please visit www.techpointfunda.com for more Interview Questions and Answers.

SQL Interview Questions and Answers - Part 17:
------------------------------------------------------------------

Q152. What is a Transaction in SQL?
Q153. What is TCL in SQL? What are the different TCL commands?
Q154. What are ACID properties in SQL?
Q155. What is the use of SAVEPOINT in Transaction?
Q156. What is the difference between COMMIT and SAVE transactions in SQL?
Q157. What is the use of @@TRANCOUNT in SQL?
Q158. What is the difference between TRANSACTION and DISTRIBUTED TRANSACTION in SQL?
Q159. What is a Two-Phase Commit (2PC) in SQL? Why it is required?
Q160. What is the SET XACT_ABORT option in SQL? How does it affect the transaction?


https://www.techpointfunda.com/2022/09/sql-interview-part-17.html


#sqlinterviewquestions #mostfrequentlyaskedsqlinterviewquestions #sqlinterviewquestionsandanswers #interviewquestionsandanswers #techpointfundamentals #techpointfunda #techpoint #sql #database #interview


Please visit www.techpointfunda.com for more Interview Questions and Answers.

SQL Interview Questions and Answers - Part 18:
------------------------------------------------------------------

Q161. What is Concurrency in SQL? What are the different concurrency problems in SQL?
Q162. What is a Dirty Read Problem in SQL? How can you avoid this Dirty Read Problem?
Q163. What is a Phantom Read Problem in SQL? How can you avoid this Phantom Read Problem?
Q164. What is a Non-Repeatable Read Problem in SQL? How can you avoid this Non-Repeatable Read Problem of SQL?
Q165. What is a Lost Update Problem in SQL? How can you avoid this Lost Update Problem of SQL?
Q166. How can you solve the Concurrency Problems in SQL? What are the different Concurrency Control Mechanisms available in SQL?
Q167. What is Transaction Isolation? What are the different Transaction Isolation Levels in SQL?
Q168. What is the difference between the Read Committed and Read Uncommitted Isolation Levels in SQL?
Q169. What is the Repeatable Read Isolation Level in SQL?
Q170. What is the difference between Serializable and Snapshot Isolation Levels in SQL?


https://www.techpointfunda.com/2022/09/sql-interview-part-18.html


#sqlinterviewquestions #mostfrequentlyaskedsqlinterviewquestions #sqlinterviewquestionsandanswers #interviewquestionsandanswers #techpointfundamentals #techpointfunda #techpoint #sql #database #interview


Please visit www.techpointfunda.com for more Interview Questions and Answers.

SQL Interview Questions and Answers - Part 19:
------------------------------------------------------------------

Q171. What is LOCK in SQL? Why locking is important in SQL if it causes performance overheads?
Q172. What is the Locking Hierarchy in SQL? What are the different resources that can have a lock?
Q173. What are the different types of lock modes in SQL?
Q174. What is Shared Lock (S) in SQL?
Q175. What is Exclusive Lock (X) in SQL?
Q176. What is Update Lock (U) in SQL?
Q177. What is Intent Lock (I) in SQL? What are the different types of Intent Lock?
Q178. What is Schema Lock (Sch) in SQL?
Q179. What is Bulk Update Lock (BU) in SQL?
Q180. What is the Key Range Lock in SQL?


https://www.techpointfunda.com/2022/09/sql-interview-part-19.html


#sqlinterviewquestions #mostfrequentlyaskedsqlinterviewquestions #sqlinterviewquestionsandanswers #interviewquestionsandanswers #techpointfundamentals #techpointfunda #techpoint #sql #database #interview


Please visit www.techpointfunda.com for more Interview Questions and Answers.

SQL Interview Questions and Answers - Part 20:
------------------------------------------------------------------

Q181. What is SQL Lock Compatibility? Can a resource have multiple locks at the same time?
Q182. What is Lock Escalation in SQL?
Q183. What is Dynamic Locking in SQL?
Q184. What is SQL Table Hint?
Q185. What is the difference between NOLOCK, and NOWAIT Table Hint in SQL?
Q186. What is the difference between READPAST and READUNCOMMITED Table Hint?
Q187. What is the difference between IGNORE_CONSTRAINTS and IGNORE_TRIGGERS table hint?
Q188. What is the use of INDEX Table Hint? What is the difference between INDEX(0) and INDEX(1) hint?
Q189. What is the difference between FORCESEEK and FORCESCAN Table Hint?
Q190. How can you check the occupied locks on a table or database?


https://www.techpointfunda.com/2022/10/sql-interview-part-20.html


#sqlinterviewquestions #mostfrequentlyaskedsqlinterviewquestions #sqlinterviewquestionsandanswers #interviewquestionsandanswers #techpointfundamentals #techpointfunda #techpoint #sql #database #interview


Please visit www.techpointfunda.com for more Interview Questions and Answers.

SQL Interview Questions and Answers - Part 21:
------------------------------------------------------------------

Q191. What is a deadlock in SQL? What is the difference between Deadlocking vs Blocking?
Q192. How can you detect and prevent deadlock in SQL?
Q193. What are the different tools that can be used to detect the deadlock?
Q194. If there is a table that is causing a deadlock most frequently. How can you minimize the deadlock on that table?
Q195. What is a Nested Transaction in SQL?
Q196. What is the use of the @@ROWCOUNT function in SQL?
Q197. What is Distributed Transaction in SQL?
Q198. Does Temp Table support TCL Commands? Can you use a Temp Table in Transaction?
Q199. Does Table Variable support TCL Commands? Can you use a Table Variable in the Transaction?
Q200. Does Table-Valued Type support TCL Commands? Can you use a Table-Valued Type in Transaction?


https://www.techpointfunda.com/2022/10/sql-interview-part-21.html


#sqlinterviewquestions #mostfrequentlyaskedsqlinterviewquestions #sqlinterviewquestionsandanswers #interviewquestionsandanswers #techpointfundamentals #techpointfunda #techpoint #sql #database #interview


Please visit www.techpointfunda.com for more Interview Questions and Answers.

SQL Interview Questions and Answers - Part 22:
------------------------------------------------------------------

Q201. How can you Handle Exceptions in SQL? Can you use the TRY/CATCH in SQL?
Q202. What is the TRY-CATCH Exception Handling Mechanism in SQL?
Q203. What is the @@ERROR function in SQL?
Q204. What is ERROR_MESSAGE() function in SQL?
Q205. What is the use of the RAISERROR () function in SQL?
Q206. What is the use of the THROW Statement in SQL?
Q207. What is the difference between the RAISERROR function and the THROW statement?
Q208. What are the Predefined Errors and their formats in SQL?
Q209. How can you generate user-defined custom error messages in SQL?
Q210. What is the Error Severity in SQL? What is its use?


https://www.techpointfunda.com/2022/10/sql-interview-part-22.html


#sqlinterviewquestions #mostfrequentlyaskedsqlinterviewquestions #sqlinterviewquestionsandanswers #interviewquestionsandanswers #techpointfundamentals #techpointfunda #techpoint #sql #database #interview


Please visit www.techpointfunda.com for more Interview Questions and Answers.

SQL Interview Questions and Answers - Part 23:
------------------------------------------------------------------

Q211. What is Dynamic SQL Query(D-SQL) in SQL? How it is different from Static SQL Query?
Q212. How can you run the Dynamic SQL Query? What is the difference between EXECUTE(), and sp_executesql() in SQL?
Q213. Can you use Dynamic SQL Query in Functions? Why?
Q214. Can you use the OUT parameter in a Dynamic SQL Query?
Q215. Can you return a value from the Dynamic SQL Query?
Q216. Can you use Temp Table in Dynamic SQL Query?
Q217. Can you use Transaction in Dynamic SQL Query?
Q218. What is the QUOTENAME() function in SQL?
Q219. What is SQL Injection? How can you prevent SQL Injection attacks?
Q220. Can you give me some Real Use Cases of Dynamic SQL Queries?


https://www.techpointfunda.com/2022/10/sql-interview-part-23.html


#sqlinterviewquestions #mostfrequentlyaskedsqlinterviewquestions #sqlinterviewquestionsandanswers #interviewquestionsandanswers #techpointfundamentals #techpointfunda #techpoint #sql #database #interview


Please visit www.techpointfunda.com for more Interview Questions and Answers.

C# Interview Questions and Answers - Part 18:
------------------------------------------------------------------

Q175. What is Routing? How does routing work in ASP .Net Core?
Q176. What is the difference between Route, RouteCollection, and Route Handler?
Q177. What is the difference between MapControllerRoute vs MapDefaultControllerRoute vs MapControllers in ASP .Net Core MVC?
Q178. What is Route URL Pattern in ASP .Net Core MVC?
Q179. What is Default Route? How can you define multiple routes in ASP .Net MVC Core?
Q180. What are the different types of routing in ASP .Net Core?
Q181. What is Conventional based Routing in ASP .Net Core?
Q182. What is Attribute-based Routing in ASP .Net Core?
Q183. What is the use of UseRouting() middleware in ASP .Net Core? How it is different from UseEndPoints()?



https://www.techpointfunda.com/2022/05/dotnet-core-interview-part-18.html


#CSharpInterviewQuestionsAndAnswers #CSharpInterviewQuestions2022 #CSharpInterview #InterviewPreparation #InterviewQuestionsAndAnswers #techpointfundamentals #techpointfunda #techpoint #interview #csharpprogramming #csharp #csharpdeveloper #csharpdotnet


Please visit www.techpointfunda.com for more Interview Questions and Answers.

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?




https://www.techpointfunda.com/2022/05/dotnet-core-interview-part-19.html


#CSharpInterviewQuestionsAndAnswers #CSharpInterviewQuestions2022 #CSharpInterview #InterviewPreparation #InterviewQuestionsAndAnswers #techpointfundamentals #techpointfunda #techpoint #interview #csharpprogramming #csharp #csharpdeveloper #csharpdotnet


Please visit www.techpointfunda.com for more Interview Questions and Answers.

SQL Interview Questions and Answers - Part 07:
------------------------------------------------------------------



Q50. What is the difference between DELETE and TRUNCATE command?
Q51. What is the difference between the WHERE clause and the HAVING clause in SQL Server?
Q52. What is the difference between COUNT(*), COUNT(col), and COUNT(1) in SQL?
Q53. What is the difference between UNION and UNION ALL in SQL?
Q54. How can you get the last inserted record in SQL? OR What is the difference between @@IDENTITY, SCOPE_IDENTITY(), and IDENT_CURRENT() in SQL?
Q55. What is the difference between ROW_NUMBER(), RANK(), and DENSE_RANK() in SQL?
Q56. What is the main difference between IN() and NOT IN() operators in SQL?
Q57. What is the difference between SQL INTERSECT and EXCEPT operator?
Q58. What is the difference between IN() and EXIST() operators?
Q59. What is the difference between NOT IN(), NOT EXISTS(), and EXCEPT operator?


https://www.techpointfunda.com/2022/07/sql-interview-part-07.html


#sqlinterviewquestions #mostfrequentlyaskedsqlinterviewquestions #sqlinterviewquestionsandanswers #interviewquestionsandanswers #techpointfundamentals #techpointfunda #techpoint #sql #database #interview


Please visit www.techpointfunda.com for more Interview Questions and Answers.

jQuery Interview Questions and Answers: ready() vs onload()
----------------------------------------------------------------

Q01. How can you check whether an HTML page is loaded or not?
Q02. What is the document.ready() function?
Q03. What is (window).on("load") function? How it is different from the ready function?
Q04. What is the difference between window.onload() vs. DOMContentLoaded event?
Q05. What is the window.onload() function?
Q06. What is the difference between $(document).ready(), window.onload() and $(window).load() methods?
Q07. What is the difference between window.addEventListener() vs window.onload() function?
Q08. What is the difference between window.onload and document.ready() methods?
Q09. When does window.onload triggers with Lazy Loaded Images and Scripts?


Please visit the below link for the answers:


https://www.crackjob.co.in/2023/11/jquery-ready-vs-onload.html


#crackjob #jqueryinterview #javascriptinterview #readyvsload #interview #onloadvsload #jqueryvsjavascript

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:

https://www.crackjob.co.in/2023/12/constructor-vs-ngoninit.html


#crackjob #interview #angularinterview #constructorvsngoninit #constructororder