Gopal Snacks Limited Interview Questions and Answers

Abstract class is a class that cannot be instantiated, while static class cannot be instantiated and can only have static members.

• Abstract class can have abstract methods that must be implemented by subclasses.

• Static class cannot be instantiated and all its members must be static.

• Abstract class is used for inheritance and polymorphism, while static class is used for grouping related methods and data.

• Example: Abstract class - Shape with abstract method calculateArea(). Static ...read more

Stored Procedure is a precompiled collection of SQL statements that can be executed by calling the procedure name.

• Stored Procedures are stored in the database and can be reused multiple times.

• They can improve performance by reducing network traffic and increasing security.

• Stored Procedures can accept parameters and return results.

• Example: CREATE PROCEDURE GetCustomerDetails AS SELECT * FROM Customers WHERE Country = 'USA';