Dynamic Programming
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 dynamic …
Data Binding, Validation
Thursday, June 13, 2024 in Spring Interview Questions
Data Binding, Validation Data Binding @RequestParam @GetMapping("/search") public List<Item> searchItems( @RequestParam(name = "query") String query, @RequestParam(name = "page", required = false, defaultValue = …
Create Database And Tables And Insert Data
Thursday, June 13, 2024 in SQL Server Interview Questions
Create Database And Tables And Insert Data -- Create Database CREATE DATABASE MyDb; GO -- Specify Database USE MyDb; GO -- Create Table CREATE TABLE Departments ( ID INT IDENTITY(1,1) PRIMARY KEY, FullName VARCHAR(255) NOT NULL ); GO -- Create Table …
Request Mapping
Thursday, June 13, 2024 in Spring Interview Questions
Request Mapping @GetMapping @GetMapping("/users") public ResponseEntity<List<User>> getUsers() { List<User> users = // Fetch users return ResponseEntity.ok(users); } @PostMapping @PostMapping("/users") public …
Isolation Level
Thursday, June 13, 2024 in SQL Server Interview Questions
Isolation Level Isolation level refers to the degree to which a transaction is isolated from modifications made by other transactions eg. SET TRANSACTION ISOLATION LEVEL REPEATABLE READ; Concurrency problem in SQL database Dirty Reads Reading …
Collection
Thursday, June 13, 2024 in Java Interview Questions
Collection A collection in Java is a framework that provides an architecture to store and manipulate a group of objects Collection Ordering Duplicates Null Values Key Characteristics ArrayList Ordered (index) Yes Yes Resizable array and good for …
Bit Manipulation
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 bit …
Stored Procedure vs Function
Thursday, June 13, 2024 in SQL Server Interview Questions
Stored Procedure vs Function Feature Stored Procedure Function Usage Use for complex processing (involve DML, transaction and exception handling) Use for computations Database Modifications Yes (INSERT, UPDATE, DELETE) No Syntax Use EXEC to run Used …
Graph
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 graph intro A …
final vs finally vs finalize
Thursday, June 13, 2024 in Java Interview Questions
final vs finally vs finalize final finally finalize Usage Prevents modification (variables), overriding (methods), or inheritance (classes) Use in try-catch-finally blocks Method invoked by the garbage collector before an object is reclaimed, used …