Interview Questions

A finally block will always be executed, whether or not an exception is actually thrown. Even in the case where the catch statement is missing and an exception is thrown, the finally block will still be executed. Last thing to mention is that the finally block is used to release resources like I/O buffers, database connections, etc.

It is a compilation error it should be X extends Y implements Z

SELECT YEAR(GETDATE()) as "Year";

ERS is a business process between trading partners that conduct commerce without invoices. In an ERS transaction the supplier ships goods based upon an Advance Shipping Notice (ASN) and the purchaser upon receipt confirms the existence of a corresponding purchase order or contract verifies the identity and quantity of the goods and then pays the supplier.

The different implementations of LINQ are:

      =>  LINQ to SQL - Refers to a component of.NET Framework version 3.5 that    provides a run-time infrastructure to manage relational data as objects.

      =>   LINQ to DataSet - Refers to a component that makes it easier and faster to query over data cached in a DataSet object.

      =>   LINQ to XML - Provides an in-memory XML programming interface.

      =>  LINQ to Objects - Refers to the use of LINQ queries with any IEnumerable or IEnumerable(T) collection directly, without the use of an intermediate LINQ provider or API, such as LINQ to SQL or LINQ to XML.

Following steps should be taken

>Validate the invoice once it is matched for checking any holds..

>If workflow is implemented , Initiate approval for the invoice. Once the invoice is approved/Approrval not required(status in case WF is not implemented) you can go for payments.

>Create accounting after approval of invoice..

Finally for payments you need to format, build
-------------------------------------------------------------------------------
Before making payment

the following steps should be taken
1. invoice amt, date, qty, quy,
2. invoice duplication or not
3. rectification of any Errors in invoice
------------------------------------------------------------------------------
Before hand over the invoice or dispatch the materials
1.we have to receive perchase order from the customer
2.Then PDC cheque, cash or current dated chq for dispatch the materials
3.have to take signature from the customer for the proof of goods recieve
-------------------------------------------------------------------------------
We must check the invoice thoroughly.
(1) Date of Invoice
(2)Qty,Rate,Tax Levid

In SQL, a SQL view is a virtual table based on the result-set of an SQL statement. A view contains rows and columns, just like a real table.

SQL views can be used to hide rows and columns and complicated SQL syntax.

The fields in a view are fields from one or more real tables in the database.

IDD is the Integrated Data Dictionary. It contains information about the elements, record types, sets, maps and dialogues within the database.