Technology Questions

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.

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.

Aggregate functions perform a calculation on a set of values and return a single value. Aggregate functions ignore NULL values except COUNT function. HAVING clause is used, along with GROUP BY, for filtering query using aggregate values.

Following functions are aggregate functions. 

AVG, MIN CHECKSUM_AGG, SUM, COUNT, STDEV, COUNT_BIG, STDEVP, GROUPING, VAR, MAX. VARP

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.

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 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]

};

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.

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

    }

}