Interview Questions

I have had differences of opinion with previous managers. Our disagreements were not significant, but some had to be confronted and resolved. I have learned that two parties typically quarrel when each one refuses to consider the other's perspective. Therefore, I asked the manager I disagreed with to explain his or her perspective, and then to consider my point of view. This way, we were able to take into account each other's perspective and come to an agreeable compromise. When a compromise could not be reached, I accepted my manager's decision. Regardless of individual perspectives, managers are responsible for setting policy, and subordinates are responsible for executing it.

If the price of a product rises, the demand for the substitute product increases.

Because any Database will supports only 16 foreign keys in a database table. 

It depends upon the Database limits provided to define the Foreign key constraint, e.g. in Sql Server 2005, the recommended max limit for foreign keys is 253, but you can define more.

Pareto analysis is otherwise known as the 80/20 rule. It stipulates that 80%of problems will arise from 20% of causes – that few factors can create big problems.

The internet address( IP address) is 32bits that uniquely and universally defines a host or router on the internet. The portion of the IP address that identifies the network is called netid. The portion of the IP address that identifies the host or router on the network is called hostid.

First we need to create an instance of a JDBC driver or load JDBC drivers, then we need to register this driver with DriverManager class. Then we can open a connection. By using this connection , we can create a statement object and this object will help us to execute the query.

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.