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

Golden rules of accounting convert complex book-keeping rules into a set of well defined principles which can be easily studied and applied.

Real accounts involve machinery, land and building etc... Similarly when you credit what goes out, you are reducing the account balance when a tangible asset goes out of the organization. Debit All Expenses And Losses, Credit All Incomes And Gains. This rule is applied when the account in question is a nominal account.

Personal-Account

---Debit the receiver

---Credit the Giver

Real-Account

---Debit what comes in

---Credit what goes out

Nominal-Account

---Debit all expenses and losses

---Credit all income and gains

Templates are the rendered view with information from the controller and model. These can be a single file like index.html or multiple views in one page using "partials".

- Rename : It is a permanent name provided to a table or column.
- Alias : It is a temporary name provided to a table or column which gets over after the execution of SQL statement.

STL stands for Standard Template Library. It is a library of container templates approved by the ANSI committee for inclusion in the standard C++ specification.

There are three types of lock, namely:

Shared – This type of lock permits two or more programs to read from the locked space but does not allow them to change it.

Update – This lock is more lenient. It permits the program to read and change the locked space.

Exclusive – This lock restricts all users from accessing the locked space.

The primary purpose of life insurance is to provide financial protection to surviving dependents after the death of an insured.

After posting the all accounts in the Ledger a statement is prepared to showing debit and credit balances.Debit balances must be tally with the Credit side balance is called trial balance