Technology Questions

public delegate void Del<T>(T item);

Del<int> d1 = new Del<int>(Notify);

-  A stored procedure can accept parameters while a trigger cannot.
-  A trigger can’t return any value while stored procedures can.
-  A trigger is executed automatically on some event while a stored procedure needs to be explicitly called.
-  Triggers are used for insertions, update and deletions on tables while stored procedures are often using independently in the database.
-  A trigger cannot be written in a stored procedure. However, the reverse is not possible.

Priority: concern with application from the business point of view. It answers  How quickly we need to fix the bug? Or How soon the bug should get fixed?

Severity: concern with functionality of application. It deals with the impact of the bug on the application.

DriverManager is a class in java.sql package. It is the basic service for managing a set of JDBC drivers.

1. Initialization
2. At selection-screen
3. Start-of-selection
4. End-of-selection
5. Top-of-page
6. End-of-page
7. At line-selection
8. At user-command
9. At PF
10. Get
11. At New
12. At LAST
13. AT END
14. AT FIRST

A static initializer block is a block of code that declares with the static keyword. It normally contains the block of code that must execute at the time of class loading. The static initializer block will execute only once at the time of loading the class only.

SQL is a structured query language while PL/SQL is an extension of SQL by introducing a procedural flow. PL/SQL has blocks of statements. PL/SQL works like other procedural languages and has concepts like control statements, sequential statements, exception handling etc.

The LOAD command retrieves an object program from disk and loads it into main storage - it's primarily used for a constant table that will be available system-wide.