Technology Questions

User defined functions can be created into the Microsoft spreadsheet. Spreadsheets can be customized according to the user needs by using VB applications. To create visual basic functions useful for spreadsheet you need to click Tools and select Macros where you will need to click on Visual basic editor.

It is virtual table which is defined as a stored procedure based on one or more tables.

Cloud computing consists of 3 layers in the hierarchy and these are as follows:

1. Infrastructure as a Service (IaaS) provides cloud infrastructure in terms of hardware like memory, processor speed etc. 

2. Platform as a Service (PaaS) provides cloud application platform for the developers. 

3. Software as a Service (SaaS) provides cloud applications which are used by the user directly without installing anything on the system. The application remains on the cloud and it can be saved and edited in there only.

Unwrapping is also called as unpacking or unboxing.

Getting the private data stored in the object by using methods is called unpacking or unwrapping.

Call transaction is faster than session method. But usually we use session method in real time…because we can transfer large amount of data from internal table to database and if any errors in a session, then process will not complete until session get correct.

Regression Testing: When changes in the code of the software are made to fix the previous bug. Then testing needs to be perform to ensure that it will not generate a new bug in the application and it works as specified and that it has not negatively impacted any functionality that it offered previously. Regression Testing is important because of following reason:

- That the application works even after the alteration in the code were made.

- The original functionality continues to work as specified even after doing changes in the software application.

- The alteration to the software application has not introduced any new bugs.

A synonym can be called as an alias for a table, view, sequence or program unit. It is basically of two types:
- Private - Only the owner can access it.
- Public - Can be accessed by any database user.