CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set 02

Download Class 12 Informatics Practices Worksheets for Structured Query Language

Explore reliable practice materials for Structured Query Language tailored for Class 12 learners. Utilizing these Informatics Practices worksheets ensures thorough preparation and strengthens problem-solving speed for upcoming school assessments.

Access Structured Query Language Questions and Exercises

Access the complete worksheet PDF for Structured Query Language below. Regular practice with these targeted questions builds familiarity with standard exam patterns and helps secure higher marks in final Informatics Practices evaluations.

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

Free study material for Informatics Practices

Exam Preparation Worksheet for Class 12 Informatics Practices Structured Query Language

Structured Query Language Printable Worksheet for Class 12 Informatics Practices

Explore reliable practice questions for Structured Query Language tailored for Class 12 Informatics Practices learners. Use these structured worksheets to evaluate preparedness and strengthen problem-solving skills.

How to Use These Practice Sheets

Built using the official NCERT book for Class 12 Informatics Practices, these practice materials provide reliable academic guidance. Pair your practice with our recommended NCERT solutions to master optimal problem-solving approaches.

Enhance Speed with Online Practice

Wrap up your chapter revision by testing your knowledge against standard question formats. Everything on our platform is provided free of charge.

FAQs

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

You can download the teacher-verified PDF for CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set 02 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-27 competency-based pattern?

Yes, our CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set 02 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 02?

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

How does solving CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set 02 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 02 without any registration.