Interview Questions

No difference. There is a difference between obtain first and obtain next for an area sweep, but not when current on the owner in a set.

Windows Server Backup is a feature released for the Windows 2008 that provides a number of solutions on backing up the data on your computer in case of a system failure or any other issue. Windows Server Backup can backup a few files to a whole server. The server backup is accessible through command lines and a management console

In international accounting LIFO and extraordinary items are prohibited

In international accounting, proposed dividend entry is made in the Year in which it is declared, but in Indian Accounting Standards Proposed Divided entry is passed in the year for which dividend is declared. e.g. Dividend for 09-10 declared in AGM on 14 Sept 2010, Financial (Accounting) Year = 2009-10

In Indian Accounting entry would be passed in 2009-10 Accounts books, but in International Accounting entry would be passed in the year 2010-11 Accounts books.

Aggregate functions in SQL are used to perform calculation on data. These functions are inbuilt in SQL and return a single value.

SUM( )

SUM function returns the sum or addition of all NOT NULL values of a column. For e.g. I have a Table employee with the fields id, name, salary and I want the sum of all salaries, I can use SUM function as shown
SELECT SUM(emp_salary) from employee;
Hence, if my column emp_salary has values 20,000, 22,000, 21,000; the output will be 63,000

AVG( )

 
AVG function returns the average of all NOT NULL values of a column. For e.g. I have a Table employee with the fields id, name, salary and I want the average of all salaries, I can use AVG function as shown
SELECT AVG(emp_salary) from employee;
Hence, if my column emp_salary has values 20,000, 22,000, 21,000; the output will be 21,000

COUNT( )

COUNT function returns the number of rows or values of a table. For e.g. I have a Table employee with the fields id, name, salary and I want the count of all rows, I can use COUNT function as shown
SELECT COUNT(*) from employee;

Max ( ) and Min ( )

MAX function returns the largest value of a column in a table. For e.g. I have a Table employee with the fields id, name, salary and I want the maximum salary of an employee, I can use MAX function as shown
SELECT MAX(emp_salary) from employee;
Hence, if my column emp_salary has values 20,000, 22,000, 21,000; the output will be 22,000

MIN function returns the smallest value of a column in a table. For e.g. I have a Table employee with the fields id, name, salary and I want the minimun salary of an employee, I can use MIN function as shown
SELECT MIN(emp_salary) from employee;
Hence, if my column emp_salary has values 20,000, 22,000, 21,000; the output will be 20,000

Even if you like to work as a team or independent. Make sure you show interest in both, As most jobs require you to work both as part of team and independent.

In general, the idea is to say what you prefer without being negative about the thing you don’t.

Independently -
If you have done enough research on the job posting and mostly need to work independently then you can say something like “I prefer to work alone, but I find that occasionally working with a team feels creative and fun. Always felt, it is easy to solve problems being part of a team.

Work in a Team -
On the other hand, if your research says that your job requires working in a team then you can say something like "I like the dynamics of working in a team, but do like working independently when the assignment requires it.”

JDK is Java Development Kit which is for development purpose and it includes execution environment also.

JVM is Java Virtual Machine which is a run time environment for the compiled java class files .Hence you will not be able to compile your source files using a JVM.

Managed execution process is a process where CLR executes the managed code. The steps involved in this process are:

1.  Choosing the right compiler


2.  Compiling the code to MSIL. This also generates the required metadata.


3.  Compile the MSIL ode to native machine code.


4. Executing the code with the variety of services available

- GPRS uses 2.5 generation of GSM signals
- The radio interface is the same that of GSM
- GPRS uses 900 / 1800 Mhz, frequency band and GMSK modulation
- The bit rates are EGPRS, similar to EDGE
- Separate hardware and ports need to be added and availed.