Discussion
Home ‣ Interview ‣ Technology See What Others Are Saying!
- Question
What are aggregate functions in SQL? What are those functions?
- Correct Answer
- 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 eg 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 eg 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 eg 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 eg 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 eg 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
- 1. What is CRR rate? Discuss
- 2. Which among the following are not access Specifiers in C++?
Options- A. Public
- B. Protected
- C. Default
- D. Private Discuss
- 3. In which year, the first bank of India "Bank of Hindustan" was established ?
Options- A. 1677
- B. 1770
- C. 1796
- D. 1831 Discuss
- 4. What could be the bucket size if collision and overlapping occur at same time?
Options- A. 2
- B. 0
- C. 1
- D. 4 Discuss
- 5. Default constructor accepts how many arguments?
Options- A. one
- B. two
- C. three
- D. None Discuss
- 6. What are the mandatory part to present in function pointers?
Options- A. &
- B. retrun values
- C. data types
- D. none of these Discuss
- 7. Which of the following can derived class inherit?
Options- A. members
- B. functions
- C. both a & b
- D. None of the above Discuss
- 8. What kind of object is modifying sequence algorithm?
Options- A. Function template
- B. Class template
- C. Method
- D. None of these Discuss
- 9. Fixed Foreign Exchange rate can be changed by
Options- A. SEBI
- B. Ministry of Finance
- C. RBI
- D. All of the above Discuss
- 10. The shortcut key to quit from tally is
Options- A. CTRL + Q
- B. CTRL + ESC
- C. CTRL + T
- D. CTRL + P Discuss
More questions
Correct Answer: CRR or Cash Reverse Ratio is the amount of money that a commercial bank has to keep with the Reserve Bank of India If the bank increase CRR then the amount with RBI comes down and vice-versa
Correct Answer: Default
Explanation:
Default is the access specifier in java not in C++
Correct Answer: 1770
Explanation:
Among the first banks were the Bank of Hindustan, which was established in 1770 and liquidated in 1829-32.
Correct Answer: 1
Explanation:
One. If there is only one entry possible in the bucket, when the collision occurs, there is no way to accommodate the colliding value. This results in the overlapping of values
Correct Answer: None
Explanation:
Default constructors has no arguments
Correct Answer: data types
Explanation:
The data types are mandatory for declaring the variables in the function pointers.
Correct Answer: both a & b
Correct Answer: Function template
Explanation:
It is a group of functions and implemented under algorithm header file.
Correct Answer: RBI
Explanation:
Fixed Foreign Exchange rate can be changed by Reserve Bank Of India (RBI).
Correct Answer: CTRL + Q
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.