Explain OOP concepts such as inheritance, association, aggregation, composition, and polymorphism with examples
Write an SQL coding query
What is pure abstraction in Java?
What is the diamond problem in Java?
Explain Java Collections and synchronization.
What are database indexes and why are they used?
Answer theoretical questions on DBMS, OOP, and SQL.
Determine the normal form of a given database table
Explain multithreading and synchronization in Java.
What is serialization? Explain its internal working.
Write a medium-level SQL query using JOIN operations
Explain pointers including referencing and addressing
Explain the different types of database normalization.
What are B-tree and B+ tree? Explain their differences.
Explain the difference between Merge Sort and Quick Sort
Write SQL queries to join tables based on the designed ER model
Write a C++ struct for a generic linked list using void pointers.
Write a SQL query using JOIN operations to retrieve required data
Explain internal working of HashMap, ConcurrentHashMap, and TreeMap.
Explain the difference between wait() and sleep() in Java threading.
Explain processes, threads, semaphores, mutexes, deadlock, and starvation.
Explain operating system concepts including processes, threads, and caching
Improve the robustness of the tree construction code to handle extreme cases.
Design a database schema for an eCommerce system and write required SQL queries
Exceptions hierarchy in Java and rules for overridden methods throwing exceptions.
SQL: Find names of students enrolled in more than 3 courses using subquery and join.
Difference between abstract class and interface. Explain default methods in interfaces.
Explain Operating System concepts including processes, threads, caching, and page faults
Explain your approach to the written coding solutions and discuss possible optimizations.
List the data structures used in constructing a page table with an LRU swapping algorithm.
Given matrices of sizes 2x2, 2x3, and 3x3, how would you store them in a single database table?