Interview Questions

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

Price and quantity supplied move in the same direction. As the price decreases, quantity supplied also decreases and viceversa.

The analogy here is like this: Veeru has 20 lt of petrol and he uses 1 lt per each day and consumes it in 20 days. If he uses 1.25 lt every day, in how many days it will be consumed?
We considered 1.25 lt here because it’s 25% more than 1 lt.

The answer would be  20/1.25=16 days.

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]

};

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

    }

}

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.