Posts in 2024
  • @RestController, @Service, @Repository, @Component

    Thursday, June 13, 2024 in Spring Interview Questions

    @RestController, @Service, @Repository, @Component Presentation Layer @RestController Marks a class as a Spring MVC controller Service Layer @Service Marks a class as a service layer component for defining business logic Persistence Layer @Repository …

    Read more

  • Join vs Subquery

    Thursday, June 13, 2024 in SQL Server Interview Questions

    Join vs Subquery JOIN Subquery JOIN is combining rows from two or more tables based on related columns A subquery is a SELECT query that is nested within another DML statement Generally, joins are highly optimized Generally, correlated subquery is …

    Read more

  • Garbage Collection

    Thursday, June 13, 2024 in Java Interview Questions

    Garbage Collection Garbage Collection (GC) in Java is a form of automatic memory management The garbage collector identifies which objects are no longer being used by the application

    Read more

  • Backtracking

    Thursday, June 13, 2024 in LeetCode Notes

    Starred by 25+ users, GitHub Repo: LeetCode Pattern 500 offers: 500 solutions for LeetCode problems in Python and Java 17 notes on essential concepts related to data structures and algorithms 130 patterns for solving LeetCode problems backtracking …

    Read more

  • @Value

    Thursday, June 13, 2024 in Spring Interview Questions

    @Value @Value(”${key:default}”) on variable can get key-value pair’s value from application.properties

    Read more

  • Stack vs Heap

    Thursday, June 13, 2024 in Java Interview Questions

    Stack vs Heap Stack Heap Store Method calls, primitive types, reference to objects Objects Management Automatic Manual or Automatic (Garbage Collector)

    Read more

  • Stack And Queue

    Thursday, June 13, 2024 in LeetCode Notes

    Starred by 25+ users, GitHub Repo: LeetCode Pattern 500 offers: 500 solutions for LeetCode problems in Python and Java 17 notes on essential concepts related to data structures and algorithms 130 patterns for solving LeetCode problems stack and …

    Read more

  • DROP vs TRUNCATE vs DELETE

    Thursday, June 13, 2024 in SQL Server Interview Questions

    DROP vs TRUNCATE vs DELETE DROP TRUNCATE DELETE Remove an entire object from the database 1. Remove all rows from a table without logging individual row deletions or firing triggers. 2. Identity sequence reset to its seed value Remove specific rows …

    Read more

  • @PostConstruct

    Thursday, June 13, 2024 in Spring Interview Questions

    @PostConstruct @PostConstruct allows to perform initialization tasks on a bean right after all its necessary dependencies have been injected by Spring but before the bean is put to use The method annotated with @PostConstruct must have no parameters, …

    Read more

  • WHERE vs HAVING

    Thursday, June 13, 2024 in SQL Server Interview Questions

    WHERE vs HAVING WHERE HAVING Filter individual rows based on conditions involving column values Filter groups of rows based on conditions involving aggregated values Must used after GROUP BY Contain aggregate function Used in SELECT, UPDATE, or …

    Read more