Interview Questions

Issues related to AR
1. Invoice discrepancies / no proper documents
2. Services / goods delivered not satisfactory
3. Customer do more negotiation even your invoice as per agreed terms and conditions
4. Very Important issue if no proper follow up from your side my result you receivable to Bad Debts

Automatic payments batch means auto payment is done on the bases of the batch, which u created for the payment of particular pay group etc.

Automatic payments means auto payments is done on the bases of single transaction u selected base for the payments

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.

* 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.

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

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.

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.