CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set 04

Class 12 Informatics Practices Practice Set: Structured Query Language

Review targeted practice sets for Class 12 Informatics Practices Structured Query Language. Built according to official educational guidelines for the 2026-27 academic year, these downloadable worksheets support daily revision and core concept reinforcement.

Download Structured Query Language Worksheet PDF

Navigate directly to the printable exercises for Structured Query Language using the digital viewer below. Each practice set allows students to isolate specific topics for thorough review and uninterrupted practice alongside standard textbooks.

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

Free study material for Informatics Practices

Structured Query Language Practice Sheet and Solutions for Class 12 Informatics Practices

Download Practice Sheet: Structured Query Language (Class 12 Informatics Practices)

Review targeted practice exercises for Class 12 Informatics Practices Structured Query Language. Curated to match official CBSE guidelines, these downloadable PDF sheets support daily revision and core concept reinforcement.

Concept Clarification for Structured Query Language

Each worksheet is structured around standard CBSE textbooks, allowing students to check their working steps and correct mistakes early in their revision.

Additional Study Resources for Class 12 Informatics Practices

Follow up your worksheet practice by attempting the interactive online Informatics Practices MCQ test for this chapter to evaluate your execution speed. All platform resources are free to access.

FAQs

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

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

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

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