Jtp Consulting Engineers Interview Questions and Answers

Primary key uniquely identifies a record in a table, while foreign key establishes a relationship between two tables.

• Primary key is used to enforce entity integrity and ensure uniqueness of records.

• Foreign key is used to establish referential integrity and create relationships between tables.

• A table can have only one primary key, but multiple foreign keys can be present.

• Primary key values cannot be null, while foreign key values can be null.

• Example: In a database of students ...read more

Stack is a data structure that follows Last-In-First-Out (LIFO) principle, while Queue follows First-In-First-Out (FIFO) principle.

• Stack is like a stack of plates, where the last plate added is the first one to be removed.

• Queue is like a queue of people waiting in line, where the first person to arrive is the first one to be served.

• Stack supports two main operations: push (to add an element) and pop (to remove the topmost element).

• Queue supports two main operations: enqueue (...read more

Synchronization is the coordination of multiple processes or threads to ensure their orderly execution.

• Synchronization is used to prevent race conditions and ensure data consistency.

• It involves using locks, semaphores, or other mechanisms to control access to shared resources.

• Examples include using mutexes to protect critical sections of code or using condition variables to signal between threads.

A query in DML (Data Manipulation Language) is used to retrieve, modify, or delete data from a database.

• DML queries are used to perform operations on data stored in a database.

• They can be used to retrieve specific data using SELECT statements.

• DML queries can also be used to modify existing data using UPDATE statements.

• DELETE statements are used to remove data from a database using DML queries.

• Examples of DML queries include SELECT * FROM table_name, UPDATE table_name SET colu...read more

Servlet is a Java program that runs on a web server and handles client requests and generates dynamic web content.

• Servlet is a server-side technology used for developing web applications.

• It extends the capabilities of web servers by generating dynamic content.

• Servlets are platform-independent and can be used with any web server that supports the Java Servlet API.

• They follow the request-response model, where they receive requests from clients and send responses back.

• Servlets c...read more

MVC stands for Model-View-Controller. It is a software architectural pattern used for designing and organizing code in an application.

• MVC separates the application into three interconnected components: the model, the view, and the controller.

• The model represents the data and business logic of the application.

• The view is responsible for displaying the user interface.

• The controller handles user input, updates the model, and interacts with the view.

• MVC promotes separation of con...read more