Interview Questions

1. Zero infrastructure investment : Cloud architecture provide user to build large scale system with full hardware, machines, routers, backup and other components. So, it reduces the startup cost of the business. 

2. Just-in-time Infrastructure : It is very important to scale the infrastructure as the demand rises. This can be done by taking cloud architecture and developing the application in the cloud with dynamic capacity management. 

3. More efficient resource utilization : Cloud architecture provides users to use their hardware and resource more efficiently and utilize it in a better way. This can be done only by applications request and relinquish resources only when it is needed (on-demand).

3 way matching is to compare three documents i.e., 

1. Purchase order

2. Receipt of Items/Packing slip 

3. Invoice. 

For example, if we Order for 50 Items in purchase order and received 40 Items only instead of 50 items. But we received invoice for 50 items. After comparing the three documents we pay for only 40 Items..

We can apply at max of 12 triggers in a table.

SQL keyword ORDER BY is used to sort the result-set.

One. If there is only one entry possible in the bucket, when the collision occurs, there is no way to accommodate the colliding value. This results in the overlapping of values

An inline function is a function that is expanded inline when invoked.ie. the compiler replaces the function call with the corresponding function code. An inline function is a function that is expanded in line when it is invoked. That is the compiler replaces the function call with the corresponding function code (similar to macro)

SQL Server can be linked to any server provided it has OLE-DB provider from Microsoft to allow a link. E.g. Oracle has an OLE-DB provider for oracle that Microsoft provides to add it as linked server to SQL Server group.