Interview Questions

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

Finance:It is the branch of economics that studies the management of money and other assets.In simpler terms it can be defined as the commercial activity of providing funds and capital.It addresses questions like -- what funds are required by the org & How they can be raised &  How they have to be allocated etc.

Accounts: It is the occupation of maintaining and auditing records and preparing financial reports for a business. Accounts provides quantitative information about finances. It addresses issues like what amount of funds have been allocated to various activities, how the book-keeping is being done etc.

Both functions are distinct but complimentary to each other.

Finance and accounts are highly specilized and distinct areas and hence most organizations have seperate sections of finance and accounts.

Means whatever income any employee received from the organisation and on that tax to be deducted. (e.g. Gross salary, Overtime, Bonus, Incentives etc.)

According to one-definition rule, C++ constructs must be identically defined in every compilation unit they are used in. 

As per ODR, two definitions contained in different source files are called to be identically defined if they token-for-token identical. The tokens should have same meaning in both source files. 

Identically defined doesn’t mean character-by-character equivalence. Two definitions can have different whitespace or comments and yet be identical.

The financial statements should be prepared in the following order:

Income statement - Statement of retained earnings - Balance sheet

1. Income statement reports revenues and expenses and calculates net income or net loss for the time period.

2. Statement of retained earnings show how retained earnings changed during the period due to net income or net loss and dividends.

3. Balance sheet reports assets, liabilities, and stockholders’ equity as of the last day of the period.

It can either be Final or Abstract

Currency is the location within the database during run-unit execution.

There are four levels of currency:

- Current of run-unit is the record occurrence of the last successful find or obtain;

- Current of record type is for the most recent of each record type;

- Current of record set is the most recent within each set 

- Current of area is within each area.

new and delete operators are mainly used to allocate and deallocate
during runtime.