Interview Questions

SQL statement gets executed when we open cursor

We can use the following method call:

boolean createNewFile();

This method creates a new file on the HD. 

If a file is already existing with the name given in the constructor then this method does not creates file on HD.

If file is successfully created then this method returns true.

If file is already existing on the HD then this method returns false.

This method may throw IOException whenever IO error is generated while creating file on HD.

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

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

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.

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

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

There are two major platforms that providing hosting and servers to host on. The differences between them are as follows:

- Unix are more efficient in performing offsite and onsite, whereas windows doesn’t provide very good efficiency to work with. 

- Unix provide lower hosting cost for the website using the high bandwidth, whereas windows take more resources and have the cost higher for the storage. 

- Unix is better for the websites that are static and includes HTML and graphics, whereas Windows is used for heavy websites and having more requirements. 

- Unix supports the scripting languages like PHP and databases like MySQL and other related categories, whereas Windows supports IIS, coldfusion and big applications that take more space.