Interview Questions

A class can have any number of constructors. If a class have more than one constructor, we call it as the constructor is overloaded.

SQL has IsDate() function which is used to check passed value is date or not of specified format ,it returns 1(true) or 0(false) accordingly.

SELECT  ISDATE('1/08/13') AS "MM/DD/YY";

It will return 0 because passed date is not in correct format.

When amount of memory to be allocated is known beforehand i.e. at the the time of compilation, it is known as Static Memory Allocation. Once the memory is allocated statically, it cannot be deallocated during program run. So it leads to wastage of storage space.

Example:

int A[100];

When amount of memory to be allocated is not known beforehand, rather it is determined at the time of program run, it is called Dynamic Memory Allocation. It leads to efficient utilization of storage space.

Example:

cout << " Enter number of elements: ";

cin >> N;

int *A = new int[N]; // dynamic memory allocation

Open addressing (closed hashing),

The methods used include: Overflow block,

 Closed addressing (open hashing)

The methods used include: Linked list, Binary tree…

The comparison operator that is used in SQL is '='. Comparison operators test whether two expressions are the same. Comparison operators can be used on all expressions except expressions of the text, ntext, or image data types.

Software Technology Parks of India (STPI).Some of the software service providers will get exemption from STPI for their software exports. In accounts payable may be we need to define the vendor STPI location wise.

In India we have different STPI location. If one vendor supplying services or materials to all OR some of the STPI locations we need to maintain the same vendor STPI wise.  

If an outstanding check of the previous month clears the bank (is paid by the bank) in the current month, you simply remove that check from the list of outstanding checks.

If an outstanding check of the previous month does not clear the bank in the current month, the check will remain on the list of outstanding checks until the month that it does clear the bank.

In the bank reconciliation process, the total amount of the outstanding checks is deducted from the balance appearing on the bank statement.