SUNBEAM Institute of Information Technology Placement Initiative ee ie aes ee) What is HTTP protocol? What are contents of request and response? Why HTTP is called as connection-less protocol? Why itis called as stateless protocol? What is state management? Explain server side and client side state management objects, Which are HTTP request methods? Explain difference between GET and POST methods. What is difference between HTTP and HTTPS? What is SSL? What is AJAX? How it is used with and without jQuery? What is DOM? Explain in context of HTML page. What is jQuery? How to call REST services using jQuery? ‘What do you mean by responsive web UI? What is grid system in bootstrap? 10, What are key components of bootstrap? 111, What is React? What are the major features of React? 12, What are the advantages and limitations of React? 13, What is JSX? How to loop inside JSX? 14, How to create components in React? When to use a Class Component over a Function Component? What are Pure Components? 15, What is the difference between state and props? Why you can’t update props in React? 16, What is the difference between HTML and React event handling? 17. What is Virtual DOM? How it works? 18, What are the lifecycle methods of React? 19. What are Higher-Order components? 20. What are render props? 21, What is React Router? 22, How to perform automatic redirect after login in React? 23, What is Redux? What are the core principles of Redux? 24, What is an action in Redux? Can | dispatch an action in reducer? 25, What do you mean by reactive programming? How it works? 26. How to invoke REST services in React? 27. How to implement REST services in Express? Explain CRUD operations (on database) using REST services. 28, What is event loop in Node JS? Why Node JS is single-threaded? ‘SunBeam Institute of Information Technology, Pune, Karad@ SUNBEAM vé = Institute of Information Technology DAC - Core Java Placement Initative What is wrapper class? What is their use? Which are methods of java.lang.Object class? Which are native methods of object class? What is the need of package? Which types are allowed to declare in package? Why we can not declare multiple public classes in single Java file? What is the difference between import and static import? How can we pass argument to the method by reference? Explain with example? What is the difference between checked and unchecked exception? Which are the advantages and disadvantages of generics? What is difference between Comparable and Comparator? What is difference between ArrayList and Vector? How to use Listiterator? What is fail-fast and failsafe iterator? What is serialization and deserialization? What is significance of SerialVersionUID? What is relation between Thread start{) and run() method? When we shiould create thread by implementing Runnable and extending Thread class? What is functional interface? Which functional interfaces are predefined and where they are used? What is significance of filter(), map(), flatMMap() and reduce() operations? in which scenarios they are used? SunBeam Institute of Information Technology, Pune, Karad6 sunBeam /& Institute of Information Technology Placement iniiative Pen: rad Explain Servlet & JSP life cycle? What is difference between Redirect and RequestDispatcher scenario? ‘What is session tracking? How to do it in java? What is hibernate? Explain hibernate architecture. Explain hibernate entity life cycle? ‘What is the difference between get() and load() of hibernate? How can we call stored procedure in hibernate? ‘What is JOC and Dependancy injection? ‘What is auto-wiring? Which are the types of auto wiring? What if prototype bean Is auto-wired in a singleton bean? Explain spring bean life cycle. Explain spring bean scopes. ‘What is use of @Transactional? Why it should be used on service layer? Explain Spring MVC life cycle? What is the difference between SOAP and REST? What is significance of RestController? ‘What is Spring Boot? What do you mean by opinionated defaults? Haw auto-configuration works? What is significance of @CrossOrigin? How it works? SunBeam Institute of Information Technology, Pune, Karad.@ sunBeam — Institute of Information Technology are Placement Iniative DAC - Advanced Software Development Method. What are the differences between Agile and traditional project management (Waterfal]? What are the roles in Scrum? Explain their duties. Explain terms story, task, epic and sprint. What is their relation? Which are some of the most popular DevOps tools (mention at least 5)? What is their use? Is there a difference between Agile and DevOps? If yes, please explain. What is Cl, CT, CD pipeline? What is role of jenkins? Explain selenium, How it can be used for testing web pages? What is docker? What are advantages of docker? What is docker compose? What are its advantages? 1. What is kubernetes? What do you mean by container orchestration? |. Explain purpose of GIT. Explain commands to clone, pull and push code. How we can use GIT to create & merge branch? What is micro-service? How is its advantage over monolithic application? What is UML? Explain use case diagram, class diagram and sequence diagram. ‘SunBeam Institute of Information Technology, Pune, Karad@ SUNBEAM ve a" Institute of Information Technology Pa Pracement It ‘Which are the components of .net framework? What is assembly? What is manifest? ‘What is GAC? How it handles DLL hell problem? Whats the difference between sealed override and abstract override? What is delegate? Explain the types of delegate? What the difference is between finalize and dispose? Where using keyword is used? Explain ASP.NET architecture with IS7. Explain steps of ADO.NET program, Explain MVC application life cycle? Explain what is routing in MVC? What are the three segments for routing important?What is default route? What are Filters in MVC? Explain action filters . What are the methods of handling an Error in MVC? Differences between Razor and ASPX View Engine in MVC? - Explain NET core features and architecture. SunBeam Institute of Information Technology, Pune, Karad Page 106 SUNBEAM => Institute of Information Technology " DAC - Database Techn What is normalization? What is its need? Explain 1NF , 2NF .3NF and BCNF in detail. Explain entity relationship diagram and Explain all types of relationships with examples? }. Which are different types of joins in SQL? Give examples. What is stored procedure? What are advantages of stored procedure? How stored function is different than stored procedure? . What is difference between CHAR, VARCHAR and TEXT? Does data type matter while creating index? Explain ACID properties of transaction. What is use of transaction?’ What is table level locking and row level locking? What is optimistic locking and pessimistic locking? Write a query to find third highest salary of employee (on EMP table) using sub-queries and without using sub-queries. 10. Write a query to print name of employee and his manager. Also print manager’s manager. 11, What is use of views? How to limit DML operations on views to the given criteria? 12. What is normalization? Explain 1-NF, 2-NF, 3-NF and BCNF in detail. 13. What is NoSQL database? What are its advantages and limitations? 14, Explain BASE transactions and CAP theorem. 15, Explain types of NoSQL databases. Where they can be used? 16. Write queries to perform CRUD operations on mongo database. ee ‘SunBeam Institute of Information Technology, Pune, Karad6 sunBesam Institute of Information Technology Pea Placement Iniative What is time complexity and space complexity? What is best case, worst case and average case time complexity? Implement quick sort. Implement heap sort What is hashtable? Implement hashtable using chaining method. What is load factor of hashtable? How itis related to collision handling technique? Write a program to convert infix expression into postfix and then solve it? How to use stack to find a path between two points in a maze game? How to display a singly linear linked list in reverse order (without modifying contents)? How to reverse a singly linear linked list using recursion and without recursion? How to check if given singly linear linked list is palindrome or not? Time complexity should be O(n) and space complexity should be (1). Implement add last, traverse and search function in a generic (for any data type) doubly linked list. 12, Implement binary search tree in-order and post-order using recursion and without recursion? 13. What are different methods of implementing graph? Explain with diagram and code snippet. 14, How to implement BFS and DFS algorithm on graph? 15. What is minimum spanning tree and its applications? Implement Prim's MST algorithm, SunBeam Institute of Information Technology, Pune, Karad6 SUNBEAM — Institute of Information Technology in A Placement Initative DMC - Operating Systems and Linux Programming What is OS? What are its important functions? Whats system call? How it is executed? Explain terms: Multi-programming, Multi-tasking, Multi-threading, Multi-processing and Mutli-user? Explain Linux kernel design (monolithic or modular). Explain process life cycle. ‘What are Linux IPC mechanisms? Explain any three with diagram, ‘What is difference between process and thread? How can you create them in Linux program? ‘What is difference between semaphore and mutex? How can you create them in Linux program? What is file? Which system calls are used to manipulate files in Linux? Write their prototypes and explain. 1. What is paging? What is page fault and how it is handled? . What is difference between starvation and deadlock? . How vfork() system call works? What is copy-on-write? . Explain OS booting. Explain Linux booting. How many Linux run-levels are there? Which features are enabled in each runlevel? Explain regex commands and wildcard characters. Which Linux command is used to kill all running instances of the same program. How security is implemented in Linux file systems? Tell commands related to it. How redirection and pipe in Linux commands work? ‘SunBeam Institute of Information Technology, Pune, KaradSUNBEAM a | Institute of Information Technology ion Cire aes Placement Intative Tell us something about yourself. Tell us some of your strengths and weaknesses. How you can overcome your weaknesses? Are you comfortable working in a team? What makes you think so? If you were hiring for this position, what qualities would you look for in a potential candidate? How would you rate yourself as a candidate on a scale of 1-10? Give Reasons. What is your career objective? What motivates you at work? What is your opinion about working in night shifts or over the weekends? Do you think you have made the right career choice? Why? Discuss the most stressful situation you came across in life 11. Why should we hire you? 12, What is your idea of an ideal company? 13, Tell us something about your achievements during your education. 14, Do you think your marks in academics truly reflect your potential? 15, Tell us something about your hobbies. 16. How do you see yourself 5 years from now? 17, Tell us about your dream job. 18, Is there any particular kind of person you cannot work with? 19. Tell us what do you know about our company? 20, How long do you think you can work for our company? 21, Are you willing to sign a service bond with our company? If yes for what duration? If no, why not? 22, How important would the location of your job be for you? Why? 23. Which is the subject that you have liked in your studies till date? Why? 24, What are the things that might make you leave a job? 25, We are hiring for test engineer position. Are you willing to join? Why? SunBeam Institute of Information Technology, Pune, KaradInstitute of Information Technology @ SUNBEAM vé, Se AT Placement Initiative PSTD ker) What is the reason for the gap in your education? (Answer only if applicable to you) ‘Why is your academic performance in X,Xll & Graduation not consistent? (Answer only if applicable to you). There is a 2/3/A year gap after finishing your education. Why? (Answer only if applicable to you). Your graduation branch is different. Why do you want to change your line by taking this job? (Answer only if applicable to you). ). Your previous academic performance has been below average. What makes you think your work performance will be better? (Answer only if applicable to you).