Coditas Technologies Senior Software Developer Interview Questions and Answers

Design a schema for a restaurant app like Zomato.

• Create tables for restaurants, menus, reviews, and users.

• Include columns for restaurant name, location, cuisine, and ratings.

• Add columns for menu items, prices, and descriptions.

• Include user information such as name, email, and password.

• Create relationships between tables using foreign keys.

• Implement search and filter functionality for restaurants and menus.

• Allow users t...read more

A transaction is a unit of work that is performed on a database.

• A transaction is a sequence of database operations that are treated as a single unit of work.

• It ensures that all the operations are completed successfully or none of them are performed.

• Transactions are used to maintain data consistency and integrity in a database.

• Examples of transactions include transferring money between bank accounts or updating inventor

SQL is a relational database while NoSQL is a non-relational database.

• SQL databases use structured query language while NoSQL databases use unstructured query language.

• SQL databases are vertically scalable while NoSQL databases are horizontally scalable.

• SQL databases are good for complex queries while NoSQL databases are good for large amounts of unstructured data.

• Examples of SQL databases include MySQL, Oracle, and Po...read more

Multitasking in Java can be achieved through multithreading.

• Create a new thread using the Thread class or Runnable interface

• Use the start() method to start the thread

• Synchronize shared resources to avoid race conditions

• Use wait() and notify() methods for inter-thread communication

• Example: creating a thread to perform a long-running task while the main thread continues executing other tasks

Semaphores are a synchronization tool used to control access to a shared resource.

• Semaphores can be used to prevent race conditions in multi-threaded programs.

• They can be used to limit the number of concurrent accesses to a resource.

• Semaphores can be binary (0 or 1) or counting (0 to n).

• Examples of semaphore functions include wait(), signal(), and init().