CBSE Class 12 Informatics Practices More on SQL- Grouping Records and Table Joins

Scroll down for PDF

CBSE Assignment for Class XII Informatics Practices -More on SQL- Grouping Records and Table Joins. Based on CBSE and CCE guidelines. The students should read these basic concepts to gain perfection which will help him to get more marks in CBSE examination.

More on SQL- Grouping Records and Table Joins

Very Short Question Answer

1. Why is it not allowed to give String and Date type arguments for SUM() and AVG() functions? Can we give these type of arguments for other functions?

Answer : String and dates are not real numbers that we calculate so sum or avg functions are not valid for them.

2. What is default, Autocommit mode in MySQL ?

Answer : By default, Autocommit mode is on in MySQL.

3. Can where be added a savepoint in a transaction ?

Answer : We can add a savepoint anywhere in a transaction.

4. How are NULL values treated by aggregate functions?

Answer : : None of the aggregate functions takes NULL into consideration. NULL is simply ignored by all the aggregate functions.

5. There is a column C1 in a table T1. The following two statements: SELECT COUNT(*) FROM T1; and SELECT COUNT(C1) from T1; are giving different outputs. What may be the possible reason?

Answer : There may be a null value.

6. What is the purpose of GROUP BY clause?

Answer : GROUP BY: GROUP BY clause is used in a SELECT statement in conjunction with aggregate functions to group the result based on distinct values in a column.

7. What is the difference between HAVING and WHERE clauses? Explain with the help of an example.

Answer : WHERE Vs HAVING: WHERE is used to put a condition on individual row of a table whereas HAVING is used to put condition on individual group formed by GROUP BY clause in a SELECT statement.

8. What is a Foreign key? What is its importance?

Answer : Foreign Key: It is a column of a table which is the primary key of another table in the same database. It is used to enforce referential integrity of the data.

9. What are constraints? Are constraints useful or are they hindrances to effective management of databases?

Answer : These are the rules which are applied on the columns of tables to ensure data integrity and consistency. These play very important role for tables so are not hindrances.

10. In a database there is a table Cabinet. The data entry operator is not able to put NULL in a column of Cabinet? What may be the possible reason(s)?

Ansewr : Not NULL or Primary key constraints used.

11. In a database there is a table Cabinet. The data entry operator is not able to put duplicate values in a column of Cabinet? What may be the possible reason(s)?

12. Do Primary Key column(s) of a table accept NULL values?

Answer :No.

13. There is a table T1 with combination of columns C1, C2, and C3 as its primary key? Is it possible to enter:

a. NULL values in any of these columns?

b. Duplicate values in any of these columns?

Answer : No.

14. What are the differences between DELETE and DROP commands of SQL?

Answer : Delete is used for row removing while drop is used for removing complete table.

15. What are Aggregate Functions ?

Answer : A multiple row function works on multiple values. These functions are called aggregate functions or group functions.

Q.16 for what Data Types aggregate functions : MIN(), MAX(), and COUNT() work?

Answer : on any type of values - Numeric, Date, or String. AVG(), and SUM() work on only Numeric values (INT and DECIMAL).

Q.17 What is HAVING clause ?

Answer : HAVING clause is used in conjunction with GROUP BY clause in a SELECT statement to put condition on groups.

Q.18 What is Referential Integrity ?

Answer : The property of a relational database which ensures that no entry in a foreign key column of a table can be made unless it matches a primary key value in the corresponding column of the related table.

Q19. What is Union used for ?

Answer : Union is an operation of combining the output of two SELECT statements.

Q20. What is ALTER TABLE ?

Answer : ALTER TABLE command can be used to Add, Remove, and Modify columns of a table. It can also be used to Add and Remove constraints.

Q.21 What is DROP TABLE ?

Answer : DROP TABLE command is used to delete tables.

Please refer to attached file for CBSE Class 12 Informatics Practices More on SQL- Grouping Records and Table Joins


Click on the text For more study material for Informatics Practices please click here - Informatics Practices

Latest NCERT & CBSE News

Read the latest news and announcements from NCERT and CBSE below. Important updates relating to your studies which will help you to keep yourself updated with latest happenings in school level education. Keep yourself updated with all latest news and also read articles from teachers which will help you to improve your studies, increase motivation level and promote faster learning

Extension of dates by CBSE for Single Girl Child Merit (SGC) scholarship

CBSE has announced to extend dates for SGC scholarship. Previously the dates to submit the SGC scholarship form were 18 October 2019. Now dates have shifted. For online submission, the last date is 31st October. Whereas date for submission of hard copies of renewal...

CBSE examination board hike the fee for class 10th and 12th

The CBSE (Central Board Secondary Education) increased the examination fees for classes 10 and 12 of the 2020 boards, with no profit no loss principle, from Rs. 750 to Rs 1500, for all categories of students, including SC/ST candidates for all schools throughout India...

TIPS: Study habits for success

Being a student is fairly a difficult job. Alongside maintaining your curricular as well as extra-curricular activities adds more to it. Performance in academics is one of the major concerns. Every parent now tries to get their children more indulged in studies. Need...

JEE Entrance Exam 2020 Dates Registration Admit Cards Exam Pattern

JEE Entrance exam is conducted for students who wish to pursue engineering in different subjects or categories like mechanical, CS, etc.. It is officially organized and conducted by NTA. Formerly it was organized by CBSE. It avails seats for students in IITs, NITs, and...

JEE in Punjabi too after English, Hindi and Gujarati

Punjab Minister Tript Rajinder Singh Bajwa requested the joint technology entrance exam (main) to be conducted in Punjabi and other regional languages too. In his letter to Union HRD Minister Ramesh Pokhriyal Nishank, the Punjab Minister for Higher Education and...


Central Board of Secondary Education, CBSE is to conduct the 10th and 12th Board Examination 2020 from February 15, 2020. Due to University Admissions, CBSE has shifted Board Exams dates from 1 March to February 15 from 2019. This year too CBSE would be making changes...

Studies Today