Interview Questions

Named PL/SQL blocks of code which can be invoked using parameters are called PL/SQL sub programs.

Advantages of PL/SQL subprograms are

- The application makes a single call to the database to run a block of statements which improves performance against running SQL multiple times. This will reduce the number of calls between the database and the application.

- PL/SQL is secure since the code resides inside the database thus hiding internal database details from the application. The application will only make a call to the PL/SQL sub program

- PL/SQL and SQL go hand in hand so there would be no need of any translation required between PL/SQL and SQL.

The interviewer wants to know what motivates you. If you can relate an example of a job or project when you were excited, the interviewer will get an idea of your preferences.

Eg: "I was very satisfied in my last job, because I worked directly with the customers and their problems; that is an important part of the job for me."

SQL Server runs on port 1433. It can be changed from the Network Utility TCP/IP properties.

The container manages the storage space for its elements and provides member functions to access them, either directly or through iterators which reference objects with similar properties to pointers.

You can use different versions of private assemblies in the same application without a re-build by specifying the assembly version in the AssemblyInfo.cs or AssemblyInfo.vb file.

The types of accounts that appear on the post-closing trial balance are the permanent accounts, Assets, Liability and Owner's capital. Permanent accounts is also called real accounts.

By providing callback function. Callback function gets called whenever corresponding event triggered.

We can apply at max of 12 triggers in a table.