<aside> 💡

Raw Questions Provided by Sir

</aside>

SQL / DBMS

Column 1 Column 2
1. Write a query for update. 2. SQL joins. Write a query for inner join.
3. What are joins and types? 4. Outer joins.
5. What is union? 6. What is SQL?
7. Why we use database? 8. How to communicate with database?
9. Inner join. 10. Self join.
11. @JoinColumn, CascadeTypes. 12. Joins and Types of joins.
13. MySQL query: (FindById, FindAll, Where Condition). 14. Difference between delete and truncate.
15. CRUD operations.

Java / OOPS

Column 1 Column 2
1. OOPS - four types and explain in detail. 2. ArrayList.
3. OOPS implementation in your project. 4. HashMap.
5. Sets. 6. Java 8 and 11 features.
7. Exceptions: checked and unchecked exceptions, and asked to write a sample logic for it. 8. Try and CatchException: explain and example.
9. Write one simple exception handling code in notepad. 10. Difference between Class and Interface.
11. Method Overloading vs Method Overriding. 12. What is exception handling and how to handle exceptions and errors?
13. Lambda functions. 14. What is polymorphism and example?
15. What is inheritance? 16. How do we achieve polymorphism?
17. Use of exception handling in real-time scenario. 18. How do we achieve interface?
19. Access specifier. 20. Method overriding and overloading.
21. In Java which class is final (String class)? 22. Stream API, Lambda function.
23. Collections. 24. Difference between ArrayList and HashSet.
25. List vs ArrayList vs HashSet. 26. HashSet vs Set.
27. Which collection is used to remove duplicates and how? 28. Array vs ArrayList.
29. How to compare two objects. 30. Definition of Class and Object.

Software Engineering

Column 1 Column 2
1. About SDLC. 2. SDLC life cycle - waterfall model, agile model.
3. Your project following which model (Agile model).

Spring

Column 1 Column 2
1. @Autowired annotation. 2. Explain in detail how you connected to your backend.
3. Types of CascadeTypes. 4. Did you implement OOPS concepts in your project? – yes.
5. Explain file application.properties. 6. What annotations did you use in your project?
7. Explain pom.xml file. 8. Which type of Java version has been used in your project?
9. What is @Service, @Autowired and why we use them? 10. Explain all the annotations used in the controller.
11. Where did you write the database connectivity drivers? 12. In pom.xml, what is <starter-jpa> dependence for?
13. Why do we need to use Spring Boot, where we have alternatives like Spring MVC, J2EE? 14. How can we connect Angular and backend?
15. What is @RestController? 16. What is Spring and Spring Boot?
17. What is JPARepository? 18. What are the inbuilt methods in JPARepository?
19. What is @Service and why we use it? 20. Application properties.
21. How you connect the backend data to frontend? 22. Why we use /url in backendUrl?
23. Spring Boot features. 24. All @Annotations and why we are using them.
25. PutMapping vs DeleteMapping. 26. PostMapping vs GetMapping.
27. Annotations used in Spring? 28. How does the JPA work?
29. What is dependency injection and its types? 30. What is @PathVariable?
31. What is spring-boot-starter-web in pom.xml? 32. Explain about delete mapping and why we use /id.
33. Spring Boot version. 34. Use of @SpringBootApplication.
35. Use of Tomcat server. 36. What is the purpose of starter dependency?
37. Use of ORM. 38. Object of class will be created before @Autowired is used or not? If not, why?
39. Type of database used. 40. What is the purpose of ArrayList?
41. How to add data into ArrayList? 42. HTTP protocol.
43. What is the purpose of @GetMapping and @PostMapping? 44. Can I post data using @GetMapping? If no, why?
45. What is an interface? 46. How you got save, delete, findByID?
47. Why do you use interface in JpaRepository instead of class? 48. Why do you use Postman instead of browser link?
49. Which database you had used in your project? 50. What is Entity?
51. Use of @RequestBody. 52. Use of service layer.
53. Difference between Spring and Spring framework. 54. What is JPA Repository and Hibernate?
55. What is @Repository? 56. You have used a new keyword in Spring Boot?
57. Why we use association in Spring Boot? Explain. 58. Why we used component?
59. When the object is created, is it before or after using @Autowired? 60. JAVA version and Spring Boot version used in project?
61. Where JPA is used in your project? 62. What is ORM?
63. In pom.xml, what are dependencies you used and what is their purpose? 64. Is encapsulation used in your project?
65. Hibernate. 66. Is it required to use Tomcat in your project?
67. What is the difference between JPA and JDBC? 68. @PostMapping.
69. If you want to add through @GetMapping, will it work or not? 70. What is used save in method?
71. What is the difference between flush() and delete()? 72. Annotations @Repository, @Service, @RestController.
73. JsonIgnore. 74. Drivers, connectors for database.
75. What is Constructor, Interface? 76. Uses of these annotations - @RestController, @Repository, @JpaRepository, @Autowired, @Service, @PostMapping, @GetMapping.
77. What are stereotype annotations? 78. Show the output in Postman (post, get).
79. For getAll() method, run it in SQL and display data. 80. What are the versions of Java and Spring Boot you used in the project?
81. What are the dependencies used in the project? 82. What is the difference between JPA and JDBC?
83. How @PostMapping annotation restricts to get values? 84. Use of findAll.
85. Difference between Java 8 & Java 11. 86. Why do we use JpaRepository?
87. Difference between Spring and Spring Boot. 88. What is ServletInitializer and its uses?
89. If we don’t add @Service, what will happen? 90. Dependency injection.
91. What is constructor injection?

Angular

Column 1 Column 2
1. What is .ts file? 2. Explain Angular workflow.
3. What is ngOnInit? 4. What is @Component?
5. How to install Angular? 6. How you have created Angular project in workspace?
7. What is Observable and why is it used? 8. Add the data using frontend and show me the data in database tables.
9. What is a Subscribe()? Why are you using this? 10. Why we are using injectable in service?
11. Difference between TS and JS. 12. Observable vs Subscribe.
13. Explain how component is created in Angular. 14. What are files created in component?
15. What is CSS, HTML, TS? 16. Why we use validators?
17. Perform delete operations in Angular.