CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set B

Access the latest CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set B. We have provided free printable Class 12 Informatics Practices worksheets in PDF format, specifically designed for Structured Query Language. These practice sets are prepared by expert teachers following the 2025-26 syllabus and exam patterns issued by CBSE, NCERT, and KVS.

Structured Query Language Informatics Practices Practice Worksheet for Class 12

Students should use these Class 12 Informatics Practices chapter-wise worksheets for daily practice to improve their conceptual understanding. This detailed test papers include important questions and solutions for Structured Query Language, to help you prepare for school tests and final examination. Regular practice of these Class 12 Informatics Practices questions will help improve your problem-solving speed and exam accuracy for the 2026 session.

Download Class 12 Informatics Practices Structured Query Language Worksheet PDF

STRUCTURED QUERY LANGUAGE (SQL)
 
Write SQL Commands to perform the following and execute them
 
1. Create the following tables PAINTING and GALLERY.
( ID is the Primary key of PAINTING, G_ID is the primary key of GALLERY)
 
2. Insert the records in the table with the given values.

CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set B

3. Display A_NAME(Artist Name) and TITLE of all Modern type paintings.
 
4. Display all the details of all the Paintings in descending order of TITLE.
 
5. Display the A_NAME, G_NAME and Date of Display (D_OF_DISPLAY) for all the Paintings which are having a display at the gallery from the tables PAINTING and GALLERY.
 
6. Display the highest price of paintings in each type from table PAINTING .
 
7. Display A_NAME , TITLE and PRICE of all Paintings whose PRICE in the range 120000 and 300000.
 
8. Display the different TYPE from the table PAINTING
 
9. Find the highest and lowest FEES from GALLERY table
 
10. Find the number of records whose PRICE is less than 30000 from the table PAINTING.
 
11. Display the Average value of FEES from table GALLERY.
 
12. Display the sum of PRICE of ABSTRACT Paintings from table PAINTING under the heading TOTAL.
 
13. Display 10% of PRICE under the heading DISCOUNT.
 
14. Display the records in descending order of Price.
 
15. Display the lowest price in ABSTRACT category.
 
16. Display the paintings which are having the letter ‘R’ anywhere in TITLE.
 
17. Display the different TYPE from table PAINTING.
 
18. Display the number of different TYPE from table PAINTING.
 
19. Delete the records whose PRICE is greater than 30000
 
20. Delete both the tables PAINTING and GALLERY.


Please click on below link to download CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set B

Structured Query Language CBSE Class 12 Informatics Practices Worksheet

Students can use the Structured Query Language practice sheet provided above to prepare for their upcoming school tests. This solved questions and answers follow the latest CBSE syllabus for Class 12 Informatics Practices. You can easily download the PDF format and solve these questions every day to improve your marks. Our expert teachers have made these from the most important topics that are always asked in your exams to help you get more marks in exams.

NCERT Based Questions and Solutions for Structured Query Language

Our expert team has used the official NCERT book for Class 12 Informatics Practices to create this practice material for students. After solving the questions our teachers have also suggested to study the NCERT solutions  which will help you to understand the best way to solve problems in Informatics Practices. You can get all this study material for free on studiestoday.com.

Extra Practice for Informatics Practices

To get the best results in Class 12, students should try the Informatics Practices MCQ Test for this chapter. We have also provided printable assignments for Class 12 Informatics Practices on our website. Regular practice will help you feel more confident and get higher marks in CBSE examinations.

Where can I download the latest PDF for CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set B?

You can download the teacher-verified PDF for CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set B from StudiesToday.com. These practice sheets for Class 12 Informatics Practices are designed as per the latest CBSE academic session.

Are these Informatics Practices Class 12 worksheets based on the 2026 competency-based pattern?

Yes, our CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set B includes a variety of questions like Case-based studies, Assertion-Reasoning, and MCQs as per the 50% competency-based weightage in the latest curriculum for Class 12.

Do you provide solved answers for CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set B?

Yes, we have provided detailed solutions for CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set B to help Class 12 and follow the official CBSE marking scheme.

How does solving CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set B help in exam preparation?

Daily practice with these Informatics Practices worksheets helps in identifying understanding gaps. It also improves question solving speed and ensures that Class 12 students get more marks in CBSE exams.

Is there any charge for the Class 12 Informatics Practices practice test papers?

All our Class 12 Informatics Practices practice test papers and worksheets are available for free download in mobile-friendly PDF format. You can access CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set B without any registration.