Interview Questions

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.

Open addressing (closed hashing),

The methods used include: Overflow block,

 Closed addressing (open hashing)

The methods used include: Linked list, Binary tree…

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

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

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.