Technology Questions

The address resolution protocol(ARP) is used to associate the 32 bit IP address with the 48 bit physical address, used by a host or a router to find the physical address of another host on its network by sending a ARP query packet that includes the IP address of the receiver.

The reverse address resolution protocol (RARP) allows a host to discover its Internet address when it knows only its physical address.

A package is a collection of related PL/SQL objects. The package contains a body and a specification. The package specification has the declaration which is public and can be used in the PL/SQL sub programs inside the package.

The package body holds the implementation of all the PL/SQL objects declared in the specification.

Example of a PL/SQL Package.

CREATE OR REPLACE PACKAGE emp_data AS 

PROCEDURE add_employee (

      ename VARCHAR2,

      job VARCHAR2,

      mgr NUMBER,

      sal NUMBER,

      deptno NUMBER);

END emp_actions;

CREATE OR REPLACE PACKAGE BODY emp_data AS 

PROCEDURE add_employee (

       ename VARCHAR2,

       job VARCHAR2,

       mgr NUMBER,

       sal NUMBER,

       deptno NUMBER) IS

BEGIN

         INSERT INTO emp VALUES (empno_seq.NEXTVAL, ename, job, mgr, SYSDATE, comm, deptno);

END add_employee;

END emp_data;

Advantages of  PL/SQL packages :

Packages are easier for application designing, encapsulating data, additional functionality and better performance. An application has various modules which can be placed in packages and handled easier.

By using two types of function modules to be called in SAP Script:

1)HELP_OBJECT_SHOW_FOR_FIELD
2)HELP_OBJECT_SHOW

Buffer class could be a global class and may be accessed in application without importing buffer module. A Buffercould be a quite an array of integers and corresponds to a raw memory allocation outside the V8 heap. A Buffer can not be resized.

An OLE server application creates ole Objects that are embedded or linked in OLE Containers ex. OLE servers are ms_word & ms_excel. OLE containers provide a place to store, display and manipulate objects that are created by ole server applications. Ex. oracle forms is an example of an OLE Container.

Dealing with primitives as objects is easier at times. Most of the objects collection store objects and not primitive types. Many utility methods are provided by wrapper classes. To get these advantages we need to use wrapper classes. As they are objects, they can be stored in any of the collection and pass this collection as parameters to the methods.

Features of the Java wrapper Classes:

- Wrapper classes convert numeric strings into numeric values.

- The way to store primitive data in an object.

- The valueOf() method is available in all wrapper classes except Character

- All wrapper classes have typeValue() method. This method returns the value of the object as its primitive type.

Asc() - Returns ANSI Character Code 

Chr() - Returns Character from ANSI Code 

InStr() - Find a string within another 

InStrRev() - Find a string within another (Reverse) 

LCase() - Convert a string to lowercase 

Left() - Crops a string from left 

Len() - Determine the length of a string 

LTrim() - Remove leading spaces from a string 

Mid() - Crops a string 

Replace() - Replace a substring within a string 

Right() - Crops a string from right 

RTrim() - Remove trailing spaces from a string 

Space() - Creates a string with the specified number of spaces 

StrComp() - Compare two strings 

String() - Creates a repeated character string 

StrReverse() - Reverse the characters of a string 

Trim() - Remove both leading and trailing spaces from a string 

UCase() - Convert a string to uppercase 

The differences in responsibilities are listed below:

- QA is concern for Process Quality and Programmers are concern for Product Quality.

- QA ensure that the processes used for developing the product of high quality where as programmers used these processes so that end product is of good quality.

- Processes are decided by QA. Programmers are supposed to follow the processes so that they can produce a good quality product.

- Any issue found during execution of process by the programmers is communicated to the QA so that they can improve the process.