Technology Questions

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;

Dalvik serves as a virtual machine, and it is where every Android application runs. Through Dalvik, a device is able to execute multiple virtual machines efficiently through better memory management.

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.

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

AWB stands for Administrator WorkBench. AWB is a tool for controlling, monitoring and maintaining all the processes connected with data staging and processing in the business information whearhousing.

The .Net runtime knows about all the references between the objects. It can identify all the circular references that are reachable from the root and hence finalize them to free them all at once if and when needed.

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);  

    }

}

Dropped tables can be recovered using DROP TABLE flashback. It works the way recycle bin works.
Example:
FLASHBACK TABLE EMPLOYEE TO BEFORE DROP;
The most recently dropped table with that original name is retrieved from the recycle bin, with its original name.