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.

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.

MAC- Media Access Control .its a unique identifier defined for certain hardware/network adapters

Value type :

• Stores the data


• The value of value types is stored on the managed stack


• They are lighter objects 


• One variable can have only one value

Reference Type :

• Stores the reference to the data


• A reference type is allocated on the heap


• They are heavier objects


• Several variables can reference the same data

Notices: These are trivial, non-critical errors that PHP encounters while executing a script - for example, accessing a variable that has not yet been defined. By default, such errors are not displayed to the user at all - although, as you will see, you can change this default behaviour.

Warnings: These are more serious errors - for example, attempting to include() a file which does not exist. By default, these errors are displayed to the user, but they do not result in script termination.

Fatal errors: These are critical errors - for example, instantiating an object of a non-existent class, or calling a non-existent function. These errors cause the immediate termination of the script, and PHP’s default behaviour is to display them to the user when they take place.

- These are the Logical Storage Units into which a database is divided.
- It is used to group together the related logical structures.

Peoplesoft Database is similar to other database which is used to store data. Peoplesoft database stores data in a table format for system PeopleTools and Application tables. This is independent of the process you use to retrieve that data from PeopleSoft. Inside PeopleSoft database, only three types of tables reside inside the schema: System Catalog tables, PeopleTools tables, and Application data tables. Two of these table types, System Catalog and PeopleTools tables, can be referred to as metadata tables; users make use of Application data tables to store the data they need for their processes.