Interview Questions

Row Level Trigger :
Row Level Trigger is fired each time row is affected by Insert, Update or Delete command. If statement doesn’t affect any row, no trigger action happens.

Statement Level Trigger :
This kind of trigger fires when a SQL statement affects the rows of the table. The trigger activates and performs its activity irrespective of number of rows affected due to SQL statement.

ADO.NET is a very important feature of .NET Framework, which is used to work with data that is stored in structured data sources, such as databases and XML files. The following are some of the important features of ADO.NET:

 =>   Contains a number of classes that provide you with various methods and attributes to manage the communication between your application and data source.

 =>   Enables you to access different data sources, such as Microsoft SQL Server, and XML, as per your requirements.

 =>   Provides a rich set of features, such as connection and commands that can be used to develop robust and highly efficient data services in .NET applications.

 =>   Provides various data providers that are specific to databases produced by various vendors. For example, ADO.NET has a separate provider to access data from Oracle databases; whereas, another provider is used to access data from SQL databases.

A delegate declares a ref type that references a named of anonymous method. Delegates are secure and type-safe.

Scope resolution operator allows a program to reference an identifier in the global scope that is hidden by another identifier with the same name in the local scope.

Run VERIFY.

Because these exps are paid/payable to persons. person includes Sole Proprietor, Partnership Firms, HUF, Co; etc.Personal accounts always appear in B/S until it is transfered to expenditure by debiting to P&L A/C.