Interview Questions

SQL statement gets executed when we open cursor

Autoboxing is the process of converting a primitive type data into its corresponding wrapper class object instance.

Example:

Integer number = new Integer (100); // number is now refers to the object 100

Unboxing is the process of converting a wrapper instance into a primitive type.

Example: 

Integer number = new Integer (100); 

int num = number;// without type casting number would be changed into int type

Session storage is same like local storage but the data is valid for a session. In simple words the data is deleted as soon as you close the browser.

To create a session storage you need to use “sessionStorage.variablename” . In the below code we have a created a variable called as “clickcount”.

If you refresh the browser the count increases. But if you close the browser and start again the “clickcount” variable starts from zero.

if(sessionStorage.clickcount)

{

sessionStorage.clickcount=Number(sessionStorage.clickcount)+1;

}

else

{

sessionStorage.clickcount = 0;

} 

By using overloading we can add new functionality to the sub class.

Different types of risk exist in ivesting schemes depending on what you've invested in.

Savings accounts are generally regarded as the least risky investments as in this we just save our wealth for future expenses.

FDM is an analog technique that can be applied when the bandwidth of a link is greater than the combined bandwidths of the signals to be transmitted.

The number of rows returned by a select query can be restricted by the LIMIT clause.
Example:
SELECT * from employee
LIMIT 20

advantages: view is used to retrieve the data very fastly from the database tables
* memory wastage is reduced
* faster than joins to retrieve the data from database tables

disadvantages:
* view is not a container,it will not hold the data
* view memory is not permanent memory