Interview Questions

* HTML elements communicate with the Browser how to represent the text.

* HTML elements become HTML tags when enclosed within the angular brackets as "<>".

Log shipping is the process of automating the backup of database and transaction log files on a production SQL server, and then restoring them onto a standby server. Enterprise Editions only supports log shipping. In log shipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and can be used this as the Disaster Recovery plan. The key feature of log shipping is that it will automatically backup transaction logs throughout the day and automatically restore them on the standby server at defined interval.

You might initially think that if you haven’t done a degree in finance or economics you haven’t got very much to offer an investment bank, but you’d be wrong. Any numerate discipline will have given you a mathematical toolkit that will come in useful in technical banking work, and any good degree proves that you’re intelligent, hardworking, and effective under pressure. Extra-curricular activities may have given you a wealth of other skills that are valuable at an investment bank, such as being able to juggle a number of commitments and work with others.

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.

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.

Testing an executable application for portability across system platforms and environments, usually for conformation to an ABI specification.

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

Static (embedded) SQL:

1.In static SQL how database will be accessed is predetermined in the embedded SQL statement.

2.It is more swift and efficient.

3.SQL statements are compiled at compile time.

4.Parsing, validation, optimization, and generation of application plan are done at compile time.

5.It is generally used for situations where data is distributed uniformly.

6.EXECUTE IMMEDIATE, EXECUTE and PREPARE statements are not used.

7. It is less flexible 

Dynamic (interactive) SQL:

1.In dynamic SQL, how database will be accessed is determined at run time.

2.It is less swift and efficient.

3.SQL statements are compiled at run time.

4.Parsing, validation, optimization, and generation of application plan are done at run time.

5.It is generally used for situations where data is distributed non-uniformly.

6.EXECUTE IMMEDIATE, EXECUTE and PREPARE statements are used.

7.It is more flexible.