Project Source code

DB Interview questions

Position - Associate Developer
Package - 26LPA

1st Round 🔥
1. What are the new features introduced in Java 8.
https://www.baeldung.com/java-8-new-features

2. Sort a student class list based on the student age in descending order.
https://www.educative.io/answers/how-to-sort-a-list-of-user-defined-objects-in-java

3. Write a logic to detect a loop in linked list and remove the loop
https://www.google.com/amp/s/www.geeksforgeeks.org/detect-loop-in-a-linked-list/amp/

4. Design HashMap put method.
https://www.turing.com/kb/implementing-hashmap-in-java

5. How to divide a monolithic application to Microservice
https://martinfowler.com/articles/break-monolith-into-microservices.html

6. Why String is immutable
https://www.google.com/amp/s/www.geeksforgeeks.org/java-string-is-immutable-what-exactly-is-the-meaning/amp/

7. How Redis Works and what are the different caching strategies.
https://codedamn.com/news/backend/advanced-redis-caching-techniques

8. How to add a list in redis cache and how to access the data again
https://redis.io/glossary/lists-in-redis/

9. What are the design pattern spring boots internally use
https://www.baeldung.com/spring-framework-design-patterns

10. How spring Auto configuration features works
https://www.marcobehler.com/guides/spring-boot-autoconfiguration

11. How to enable hibernate caching
https://www.baeldung.com/hibernate-second-level-cache

12. Lazy loading vs Eager Loading
https://www.imperva.com/learn/performance/lazy-loading/

13. Asked me to improve one SQL query
https://developernation.net/blog/12-ways-to-optimize-sql-queries-in-database-management/



2nd Round 🔥
1. Implements a search engine, something like Google. Low Level Coding
https://medium.com/@maxi.gkd/building-a-search-engine-using-a-trie-data-structure-cb79475d8a3d

2. How Pulisher Subscribe modal works
https://www.geeksforgeeks.org/what-is-pub-sub/

3. How to restrict an API call to be called from users who have required roles and permission
https://www.baeldung.com/role-and-privilege-for-spring-security-registration

4. Request Scope in spring boot
https://www.baeldung.com/spring-bean-scopes#:~:text=The%20request%20scope%20creates%20a,for%20a%20particular%20WebSocket%20session.
5. How to exclude a dependency
https://www.baeldung.com/mvn-plugin-dependency-exclusion

6. How to pass JWT token in rest api call
https://www.toptal.com/spring/spring-security-tutorial

7. logic to execute a method after every one hour without using Cron job
https://stackoverflow.com/questions/10748212/how-to-call-function-every-hour-also-how-can-i-loop-this#:~:text=Create%20a%20Timer%20object%20and,timer.

while(1==1) {
//Your code here
try{
Thread.sleep(3600000);
}
catch (Exception e) {}
}

8. Difference between scheduled and cached thread pool
https://www.linkedin.com/pulse/types-thread-pool-executors-aniket-nandan?utm_source=share&utm_medium=member_android&utm_campaign=share_via
___

❤️ Please add more peoples to this telegram channel . follow @coder_baba

100+ Practice Questions

❍ C/C++
❍ Python
❍ JavaScript
❍ Java
❍ C#
❍ Golang

➊ Simple Numbers

➀ Find a digit at a specific place in a number
➁ Find count of digits in a number
➂ Find the largest digit
➃ Find the 2nd largest digit
➄ Find the kth largest digit
➅ Find the smallest digit
➆ Find the 2nd smallest digit
➇ Find the kth smallest digit
➈ Find generic root (sum of all digits) of a number
➉ Reverse the digits in a number
➀➀ Rotate the digits in a number
➀➁ Is the number a palindrome?
➀➂ Find sum of 'n' numbers
➀➃ Check if a number is perfect square
➀➄ Find a number in an AP sequence
➀➅ Find a number in a GP sequence
➀➆ Find a number in fibonacci sequence
➀➇ Check number divisibility by 2, 3, 5, 9
➀➈ Check if a number is primary or not
20. Given a number, print all primes smaller than it
➁➀ Check if a number is circular prime or not
➁➁ Find all prime factors of a number
➁➂ Find the GCD of 2 numbers
➁➃ Find the LCM of 2 numbers
➁➄ Find the factorial of a number
➁➅ Find the exponentiation of a number

➋ Unit Conversion

➀ Number Base (Binary, Octal, Hexadecimal, Decimal)
➁ Weight (gram, kg, pound)
➂ Height (cm, m, inch, feet)
➃ Temperature (centigrade, fahrenhite)
➄ Distance (km, mile)
➅ Area (m², km², acre)
➆ Volume (ltr, gallon)
➇ Time (sec, min, hour)
➈ Currency

➌ Calculator

➀ Loan EMI Calculator
➁ Fixed Deposit Returns Calculator
➂ Interest Calculator
➃ BMI Calculator
➄ Item Price (considering tax, discount, shipping)
➅ Tip Calculator

➍ Geometry

➀ Find distance between 2 points
➁ Given 2 sides of a right angle triangle, find the 3rd
➂ Find 3rd angle of a triangle when 2 are given
➃ Area of a triangle when 3 sides are given
➄ Area of a right angle triangle
➅ Perimeter of a Square
➆ Area of a Square
➇ Perimeter of a Rectangle
➈ Area of a Rectangle
➉ Circumference of a Circle
➀➀ Area of a Circle
➀➁ Circumference of a Semi-Circle
➀➂ Area of a Semi-Circle
➀➃ Area of a Ring
➀➄ Circumference of an Ellipse
➀➅ Area of an Ellipse
➀➆ Suface Area of a Sphere
➀➇ Volume of a Sphere
➀➈ Surface Area of a Hemisphere
20. Volume of a Hemisphere
➁➀ Surface area of a Cube
➁➁ Volume of a Cube
➁➂ Surface area of a Cylinder
➁➃ Volume of a Cylinder

➎ Vector

➀ Find Scalar Multiplication of a vector
➁ Find addition/subtraction of vectors
➂ Find magnitude of a vector
➃ Find an unit vector along a given vector
➄ Find dot product of 2 vectors
➅ Find cross product of 2 vectors
➆ Check if 2 vectors are orthogonal

➏ Matrix

➀ Find the determinant of a matrix
➁ Find Scalar Multiplication of a matrix
➂ Find addition/subtraction of matrices
➃ Find the transpose of a matrix
➄ Find if 2 matrices are orthogonal
➅ Find inverse of a 2x2 and 3x3 matrix

➐ Set

➀ Find Union of 2 sets
➁ Find Intersection of 2 sets
➂ Find the Difference of 2 sets
➃ Find the Symmetric Difference of 2 sets
➄ Find if a set is subset/superset of another set
➅ Find if 2 sets are disjoints

➑ Special Numbers

➀ Strong Number
➁ Perfect Number
➂ Armstrong Number
➃ Harshad Number
➄ Kaprekar Number
➅ Lychrel Number
➆ Narcissistic Decimal Number
➇ Lucus Number
➈ Catalan Number
➉ Duck Number
➀➀ Ugly Number
➀➁ Abundant Number
➀➂ Deficient Number
➀➃ Automorphic Number
➀➄ Magic Number
➀➅ Friendly Pair Numbers
➀➆ Neon Number
➀➇ Spy Number
➀➈ Happy Number
20. Sunny Number
➁➀ Disarium Number
➁➁ Pronic Number
➁➂ Trimorphic Number
➁➃ Evil Number
➁➄ Amicable Pairs

⬘ If you want to excel in programming, practice a lot.

⬙ Problems based on numbers are easy to start with and they help in improving your analytical skills.

follow @coder_baba

Top 50 Linux Commands You Must Know as a Regular User...

1. ls - view contents of directory (list)
2. pwd - path of the current directory
3. cd - change directoryn
4. mkdir - make new directory
5. mv - move files / rename files
6. cp - copy files
7. rm - remove files
8. touch - create blank new file
9. rmdir - delete directory
10. cat - list content of file to terminal
11. clear - clear terminal window
12. echo - move data into a file
13. less - Read text file one screen at a time
14. man - show manual of Linux commands
15. sudo - enables you to perform tasks that require administrative or root permissions
16. top - task manager in terminal
17. tar - used to archive multiple files into a tarball
18. grep - used to searching words in specific files
19. head - view first lines of any text file
20. tail - view last lines of any text file
21. diff - compares the contents of two files line by line
22. kill - used for killing unresponsive program
23. jobs - display all current jobs along with their statuses
24. sort - is a command line utility for sorting lines of text files
25. df - info about system disk
26. du - check how much space a file or directory takes
27. zip - to compress your files into a zip archive
28. unzip - to extract the zipped files from a zip archive
29. ssh - a secure encrypted connection between two hosts over and insecure network
30. cal - shows calendar
31. apt - command line tool for interaction with packaging system
32. alias - custom shortcuts used to represent a command
33. w - current user info
34. whereis - used to locate the binary, source, manual page files
35. whatis - used to get one-line man page description
36. useradd - used to create a new user
37. passwd - used to changing password of current user
38. whoami - print current user
39. uptime - print current time when machine starts
40. free - print free disk space info
41. history - print used commands history
42. uname - print detailed information about your Linux system
43. ping - to check connectivity status to a server
44. chmod - to change permissions of files and directories
45. chown - to change ownership of files and directories
46. find - using find searches for files and directories
47. locate - used to locate a file, just like the search command in Windows
48. ifconfig - print ip address stuff
49. ip a - similar to ifconfig but shortest print
50. finger - gives you a short dump of info about a user

Follow @coder_baba
#coderbaba #linux #cmd

Don't overwhelm to learn Git,🙌

Git is only this much👇😇

1.Core:
• git init
• git clone
• git add
• git commit
• git status
• git diff
• git checkout
• git reset
• git log
• git show
• git tag
• git push
• git pull

2.Branching:
• git branch
• git checkout -b
• git merge
• git rebase
• git branch --set-upstream-to
• git branch --unset-upstream
• git cherry-pick

3.Merging:
• git merge
• git rebase

4.Stashing:
• git stash
• git stash pop
• git stash list
• git stash apply
• git stash drop

5.Remotes:
• git remote
• git remote add
• git remote remove
• git fetch
• git pull
• git push
• git clone --mirror

6.Configuration:
• git config
• git global config
• git reset config

7. Plumbing:
• git cat-file
• git checkout-index
• git commit-tree
• git diff-tree
• git for-each-ref
• git hash-object
• git ls-files
• git ls-remote
• git merge-tree
• git read-tree
• git rev-parse
• git show-branch
• git show-ref
• git symbolic-ref
• git tag --list
• git update-ref

8.Porcelain:
• git blame
• git bisect
• git checkout
• git commit
• git diff
• git fetch
• git grep
• git log
• git merge
• git push
• git rebase
• git reset
• git show
• git tag

9.Alias:
• git config --global alias.<alias> <command>

10.Hook:
• git config --local core.hooksPath <path>

✅ Add more peoples to this groups 🙌
#coderbaba #git follow @coder_baba

📚 Company-Specific DSA Material: LeetCode Questions 📚

📚 Company-Specific DSA Material: LeetCode Questions 📚👇