Interview Questions

sap memory is a global memory whereas abap memory is local memory.

For example, we have four programs in abap memory and assigned some varibles to a particular program in abap memory then those varibles can't be used by anyother program in abap memory i.e., the variables are only for that program and also local to that memory,whereas sap memory can access all the abap memory or else it can perform any kind of modifications.

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.

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.

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.