CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set 03

Practice Worksheets for Class 12 Informatics Practices: 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.

Practice Structured Query Language Worksheets for Class 12 Informatics Practices

View or download the dedicated Structured Query Language practice resource below. Engaging with these objective and subjective questions daily ensures continuous academic progress and mastery of the 2026-27 curriculum.

STRUCTURED QUERY LANGUAGE (SQL)
 
Write SQL Commands to perform the following and execute them :

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

 
1)Display the Trainer Name, City & Salary in descending order of their Hiredate.
 
2)Display the TNAME and CITY of trainer who joined the Institute in the month of December 2001.
 
3)Display TNAME, HIREDATE, CNAME, STARTDATE from tables TRAINER and COURSE of all those courses whose FEES is less than or equal to 10000.
 
4) Display number of Trainers from each city.
 
5) Display TID, TNAME for those trainers who does not belong to DELHI and MUMBAI.
 
6) Display the different cities listed in table TRAINER..
 
7) Display the minimum fees of each Course.
 
8) Display the total fees for the course which started before 2018-09-15.
 
9) Display the details of COURSE table in ascending order of FEES.
 
10) Display the details of TRAINER table whose TNAME starts with the letter ‘M’.
 
11) Display SALARY and 20% of SALARY of all TRAINERS from the table under the heading ‘BONUS’.
 
12) ADD a new record in TRAINER table with the data T08, RAJ,MUMBAI,2001-08-23,70000.
 
13) Change the SALARY of RICHA as 100000.
 
14) Display the number of records from COURSE table whose Fees is greater than 10000.
 
15)Remove the records of TRAINERS who were hired after 2000-01-01.
 
16) Add a new column HRA (Decimal (10,2) to TRAINER table.
 
17) Find the average salary of Trainers from Mumbai.
 
18) Write the output of the following command:SELECT TID, COUNT(*), MAX(FEES) FROM COURSE GROUP BY TID HAVING COUNT(*)>1;
 
19) Display TNAME ,CITY,CNAME and FEES from the two tables.
 
20) Remove the table COURSE.


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

Free study material for Informatics Practices

Exam Preparation Worksheet for Class 12 Informatics Practices Structured Query Language

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

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 03?

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

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

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