This page contains Solution of Both Type A and Type B Questions of Class 12 IP Chapter 7 Querying Using SQL Sumita Arora Textbook Solution.
Type A: Short Answer Questions / Conceptual Questions
Type B: Application Based Questions
1. What is the use of ORDER BY clause?
2. What is the default sort order of ORDER By Clause?
Ans: The ORDER BY clause sorts in Ascending order by default.
3. Write an example query those sorts on three columns.
Ans:
SELECT Empname, Deptname, Designation, Salary
FROM Employee
ORDER BY Empname, Deptname DESC, Salary;
4. Write a query that sorts the data of table student on the basis of Project-Group (in ascending order), section (in descending order), Marks (in descending order)
Ans:
SELECT * FROM Student ORDER BY Project_Group, Section DESC, Mark DESC;
5. What is the difference between HAVING and GROUP BY clause?
6. What is the use of GROUP BY clause?
7. What are aggregate functions? What is their use? Give some examples.
8. What type of function can you use with GROUP BY and HAVING clauses?
Ans: We can use Aggregate functions also known as multiple row function with GROUP BY and HAVING clause.
Class 12 IP Chapter 7 Type B Sumita Arora Textbook Solution
Download PDF IP Class 12 Chapter 7 Querying using SQL Type B Sumita Arora Textbook Solution