Interview Questions

Open for INPUT, OUTPUT, I-O, EXTEND.

1.INPUT : for read only purpose

2.OUTPUT : for write only purpose

3.EXTEND : for appending records

4.I-O : for read and write(using EXTEND) purpose

Similarity: Both WHERE and HAVING Clause filters out records based on one or more conditions.

Difference: WHERE Clause can only be applied to a static non-aggregated column whereas HAVING is needed for aggregated columns.

The tax payable on a non-salary benefit provided to an employee or an associate of the employee. The employer is liable to pay any FBT and may choose to recover the FBT amount from the employee.

A static method cannot access non static variables or methods because static methods doesnt need the object to be accessed. So if a static method has non static variables or non static methods which has instantiated variables they will no be intialized since the object is not created and this could result in an error.

WATER MARK is a divided segment of used and free blocks. Blocks which are below high WATER MARK i.e. used blocks, have at least once contained some data. This data might have been deleted later. Oracle knows that blocks beyond high WATER MARK don’t have data; it only reads blocks up to the high WATER MARK during a full table scan. 

A DB2 bind is a process that builds an access path to DB2 tables. 

The interviewer asks the queries to interviewee to know the interest of an individual. This is because if an individual has more interest in a particular part, then there will be more chances of getting a job in an area of interest and specialization. The employer wants to know you're serious about pursuing a career in fashion. Companies spend a lot of time and money training employees, so before they make that investment, they want to make sure you're not just applying for a job in the industry on a whim.

In C++, void represents the absence of type, so void pointers are pointers that point to a value that has no type. The void pointers can point to any data type.

You can declare void pointer as follows:

void *p;