Technology Questions

DB2 precompiler (if embedded sql used), CICS translator (if CICS program), COBOL compiler, Link editor. If DB2 program, create plan by binding the DBRMs.

Following are the benefits of data integration:

- Makes reporting, monitoring, placing customer information across the enterprise flexible and convenient.

- Data usage is efficient.

- Cost Effective.

- Risk adjusted profitability management as it allows accurate data extraction.

- Allows timely and reliable reporting, as data quality is the prime technology for business challenges.

A constructor is a member function of a class that is used to create objects of that class. It has the same name as the class itself, has no return type, and is invoked using the new operator. We cannot invoke a constructor directly.

A method is an ordinary member function of a class. It has its own name, a return type (which may be void), and is invoked using the dot operator.

The C++ programming technique allows defining user defined datatypes through structure. The

syntax to declare structure is as follows:

struct student

{

char name[100]

char address[250]

};

The standard query operators in LINQ are the extension methods that form the LINQ pattern. These operators form an API that enables querying of any .NET array or collection. It operates on sequences and allows you to perform operations, such as determining if a value exists in the sequence and performing an aggregated function, such as a summation over a sequence.

public class Test {

    public void replaseSpaces(char[] str, int length) {

        int spaceCount = 0, newLength = 0, i = 0;

        for(i = 0; i < length; i++) {

            if (str[i] == ' ') 

                spaceCount++;

        }

        newLength = length + (spaceCount * 2);

        str[newLength] = '\0';

        for(i = length - 1; i >= 0; i--) {

            if (str[i] == ' ') {

                str[newLength - 1] = '0';

                str[newLength - 2] = '2';

                str[newLength - 3] = '%';

                newLength = newLength - 3;

            }

            else {

                str[newLength - 1] = str[i];

                newLength = newLength - 1;

            }

        }

        System.out.println(str);

    }

    public static void main(String[] args) {

        Test tst = new Test();

        char[] ch = {'t', 'h', 'e', ' ', 'd', 'o', 'g', ' ', ' ', ' ', ' ', ' ', ' '};

        int length = 6;

        tst.replaseSpaces(ch, length);  

    }

}

On the server side, the main difference between GET and POST is where the submitted is stored. The $_GET array stores data submitted by the GET method. The $_POST array stores data submitted by the POST method.

On the browser side, the difference is that data submitted by the GET method will be displayed in the browser’s address field. Data submitted by the POST method will not be displayed anywhere on the browser.

GET method is mostly used for submitting a small amount and less sensitive data.
POST method is mostly used for submitting a large amount or sensitive data.

PL/SQL exceptions are raised using the RAISE command. This command is used when exceptions are defined by programmer and not implicit exceptions.

Example:

Declare and raising an exception:

DECLARE

short_of_attendance EXCEPTION;

min_attendance NUMBER(4);

BEGIN

...

IF min_attendance < 10 THEN

RAISE short_of_attendance;

END IF;

EXCEPTION

WHEN short_of_attendance THEN

-- handle the error

END;