CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set D

Access the latest CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set D. 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)
 
Consider the following table RESORT and OWNER :

CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set D 1

Write SQL commands for the following statements:
 
1. To display the RCODE and PLACE of all ‘2 Star’ resorts .
 
2. To display the details of RESORT in the alphabetical order of the place.
 
3. To display the maximum rent for each type of resort from table RESORT.
 
4. To display the details of all resorts which are started after 31-Dec-04 from table RESORT.
 
5. To display the ownername(ownedby) of all ‘5 Star’ resorts from tables RESORT and OWNER.
 
6. To change the TYPE of RCODE R104 as 4 Star.
 
7. To find the total rent of 5tar types.
 
8. To remove the details of all records whose RENT is below 10000
 
9. To display the least RENT from RESORT table
 
10. To display 25% of RENT under the heading ‘DISCOUNT’.
 
11. To add a new record with the data R106,GOA,13000,5STAR,24 May 2010 to the table RESORT.
 
12. To insert one more column called ADDRESS with the data type VARACJAR(30).
 
13. To find the total RENT of all resorts from GOA.
 
14. To display the details of resorts whose PLACE is ending with the letter ‘A’.
 
15. To display TYPE and STARTDATE in descending order of STARDATE
 
16. To show the number of different TYPE from the table RESORT
 
17. To display different TYPE from RESORT.
 
18. To drop the column STARTDATE from table RESORT.
 
19. Find the number and maximum rent of resort of each TYPE.
 
20. Delete the table RESORT,.


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

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 latest CBSE Practice worksheets for Class 12 Informatics Practices Structured Query Language

You can download the CBSE Practice worksheets for Class 12 Informatics Practices Structured Query Language for the latest session from StudiesToday.com

Are the Class 12 Informatics Practices Structured Query Language Practice worksheets available for the latest session

Yes, the Practice worksheets issued for Structured Query Language Class 12 Informatics Practices have been made available here for the latest academic session

Is there any charge for the Practice worksheets for Class 12 Informatics Practices Structured Query Language

There is no charge for the Practice worksheets for Class 12 CBSE Informatics Practices Structured Query Language you can download everything free

How can I improve my scores by solving questions given in Practice worksheets in Structured Query Language Class 12 Informatics Practices

Regular revision of practice worksheets given on studiestoday for Class 12 subject Informatics Practices Structured Query Language can help you to score better marks in exams

Are there any websites that offer free Practice test papers for Class 12 Informatics Practices Structured Query Language

Yes, studiestoday.com provides all the latest Class 12 Informatics Practices Structured Query Language test practice sheets with answers based on the latest books for the current academic session