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

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.

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.

The input type attribute TYPE defines the slider control.

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.

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

    }

}

Why are they asking?

The interviewer wants to find out the following:

  -How committed are you to the career and the company
  -How much do you understand about the career path ahead of you
  -How passionate are you

Approach 
Research the job and the organization structure and relate your career plan and progression with the job posting and progression of the company.

Eg.
I would like to work hard and grow with the company to a respectable position with additional challenges and responsibilities and contributing to success of the company.

Please don't give these answers...
"Doing your Job"
"Working somewhere else"
"No idea"
"I haven’t thought that far ahead"
"Have a family"

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.