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

Read and download free pdf of CBSE Class 12 Informatics Practices More on SQL Grouping Records and Table Joins Assignment. Get printable school Assignments for Class 12 Informatics Practices. Class 12 students should practise questions and answers given here for More On Sql Grouping Records And Table Joins Informatics Practices in Class 12 which will help them to strengthen their understanding of all important topics. Students should also download free pdf of Printable Worksheets for Class 12 Informatics Practices prepared as per the latest books and syllabus issued by NCERT, CBSE, KVS and do problems daily to score better marks in tests and examinations

Assignment for Class 12 Informatics Practices More On Sql Grouping Records And Table Joins

Class 12 Informatics Practices students should refer to the following printable assignment in Pdf for More On Sql Grouping Records And Table Joins in Class 12. This test paper with questions and answers for Class 12 Informatics Practices will be very useful for exams and help you to score good marks

More On Sql Grouping Records And Table Joins Class 12 Informatics Practices Assignment

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.

 


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


Class 12 Informatics Practices Assignments
CBSE Class 12 Informatics Practices Concept Of Inheritance In Java
CBSE Class 12 Informatics Practices Database Concepts Assignment
CBSE Class 12 Informatics Practices Database Transactions Assignment
CBSE Class 12 Informatics Practices Extensible Markup Language Assignment
CBSE Class 12 Informatics Practices Free And Open Source Software Assignment
CBSE Class 12 Informatics Practices GUI Dialogs And Tables Assignment
CBSE Class 12 Informatics Practices HTML I Basic HTML Elements Assignment
CBSE Class 12 Informatics Practices HTML II Lists Tables and Forms Assignment
CBSE Class 12 Informatics Practices IT Applications Assignment
CBSE Class 12 Informatics Practices Java Database Connectivity To MySQL Assignment
CBSE Class 12 Informatics Practices Java GUI Programming Revision Tour Assignment
CBSE Class 12 Informatics Practices More About Classes And Libraries Assignment
CBSE Class 12 Informatics Practices More on SQL Grouping Records and Table Joins Assignment
CBSE Class 12 Informatics Practices More RDBMS Assignment
CBSE Class 12 Informatics Practices MYSQL Revision Tour Assignment
CBSE Class 12 Informatics Practices Networking and open standards Assignment
CBSE Class 12 Informatics Practices Programming Fundamentals Assignment
CBSE Class 12 Informatics Practices Revision Assignment Set A
CBSE Class 12 Informatics Practices Revision Assignment Set B
CBSE Class 12 Informatics Practices Revision Assignment Set C
CBSE Class 12 Informatics Practices Revision Assignment Set D
CBSE Class 12 Informatics Practices Web Application Development Assignment
CBSE Class 12 Informatics Practices Worksheet All Chapters

More Study Material

CBSE Class 12 Informatics Practices More On Sql Grouping Records And Table Joins Assignment

We hope you liked the above assignment for More On Sql Grouping Records And Table Joins which has been designed as per the latest syllabus for Class 12 Informatics Practices released by CBSE. Students of Class 12 should download and practice the above Assignments for Class 12 Informatics Practices regularly. We have provided all types of questions like MCQs, short answer questions, objective questions and long answer questions in the Class 12 Informatics Practices practice sheet in Pdf. All questions have been designed for Informatics Practices by looking into the pattern of problems asked in previous year examinations. 

Assignment for Informatics Practices CBSE Class 12 More On Sql Grouping Records And Table Joins

Our team of expert teachers have referred to NCERT book for Class 12 Informatics Practices to design the Informatics Practices Class 12 Assignments. If you practice at least one test paper daily, you will get higher marks in Class 12 exams this year. Daily practice of Informatics Practices course notes and related study material will help you to clear all your doubts and have stronger understanding of all concepts. You can download all Revision notes for Class 12 Informatics Practices also from www.studiestoday.com absolutely free of cost.

More On Sql Grouping Records And Table Joins Assignment Informatics Practices CBSE Class 12

All questions and their answers for the assignment given above for Class 12 Informatics Practices have been developed as per the latest curriculum and books issued for the current academic year. The students of Class 12 can rest assured that the best teachers have designed the questions of Informatics Practices so that you are able to revise the entire syllabus if you do the assignments. Lot of MCQ questions for Class 12 Informatics Practices have also been given in the worksheets and assignments for regular use. All study material for Class 12 Informatics Practices students have been given on studiestoday.

More On Sql Grouping Records And Table Joins Assignment CBSE Class 12 Informatics Practices

Regular assignment practice helps to get a more comprehensive understanding of More On Sql Grouping Records And Table Joins concepts. Assignments play a crucial role in understanding More On Sql Grouping Records And Table Joins in CBSE Class 12. Students can download all the assignments of the same chapter in Class 12 Informatics Practices in Pdf format. You can print them or read them online on your computer or mobile.

CBSE Informatics Practices Class 12 More On Sql Grouping Records And Table Joins Assignment

CBSE Class 12 Informatics Practices latest books have been used for coming up with the latest questions and solutions for the above assignment. If you have revised all concepts relating to More On Sql Grouping Records And Table Joins then you should attempt all questions given in the test sheets above. We have also provided lot of Worksheets for Class 12 Informatics Practices which you can use to further make your self stronger in Informatics Practices

Where can I download in PDF assignments for CBSE Class 12 Informatics Practices More On Sql Grouping Records And Table Joins

You can download free Pdf assignments for CBSE Class 12 Informatics Practices More On Sql Grouping Records And Table Joins from StudiesToday.com

The assignments for More On Sql Grouping Records And Table Joins Class 12 Informatics Practices for have been made based on which syllabus

The More On Sql Grouping Records And Table Joins Class 12 Informatics Practices Assignments have been designed based on latest CBSE syllabus for Class 12 Informatics Practices issued for the current academic year

Can I download and print these printable assignments for Informatics Practices More On Sql Grouping Records And Table Joins Class 12

Yes, These printable assignments for More On Sql Grouping Records And Table Joins Class 12 Informatics Practices are free to download and print

How many topics are covered in More On Sql Grouping Records And Table Joins Informatics Practices assignments for Class 12

All topics given in More On Sql Grouping Records And Table Joins Informatics Practices Class 12 Book for the current academic year have been covered in the given assignment

Is there any charge for this assignment for More On Sql Grouping Records And Table Joins Informatics Practices Class 12

No, all Printable Assignments for More On Sql Grouping Records And Table Joins Class 12 Informatics Practices have been given for free and can be downloaded in Pdf format

How can I download the printable test assignments for More On Sql Grouping Records And Table Joins Informatics Practices Class 12

Just click on the View or Download button below, then another window with the Pdf will be visible, just click on the Pdf icon to download the free assignments for More On Sql Grouping Records And Table Joins Class 12 Informatics Practices

Are these assignments available for all chapters in Class 12 Informatics Practices

Yes, apart from Informatics Practices you can download free assignments for all subjects in Class 12

Can I download solved assignments for More On Sql Grouping Records And Table Joins CBSE Class 12 Informatics Practices

Our team of expert teachers at studiestoday.com have provided all answers for the practice questions which have been given in Class 12 Informatics Practices More On Sql Grouping Records And Table Joins assignments