CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set C

Read and download free pdf of CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set C. Download printable Informatics Practices Class 12 Worksheets in pdf format, CBSE Class 12 Informatics Practices Structured Query Language Worksheet has been prepared as per the latest syllabus and exam pattern issued by CBSE, NCERT and KVS. Also download free pdf Informatics Practices Class 12 Assignments and practice them daily to get better marks in tests and exams for Class 12. Free chapter wise worksheets with answers have been designed by Class 12 teachers as per latest examination pattern

Structured Query Language Informatics Practices Worksheet for Class 12

Class 12 Informatics Practices students should refer to the following printable worksheet in Pdf in Class 12. This test paper with questions and solutions for Class 12 Informatics Practices will be very useful for tests and exams and help you to score better marks

Class 12 Informatics Practices Structured Query Language Worksheet Pdf

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

Structured Query Language CBSE Class 12 Informatics Practices Worksheet

The above practice worksheet for Structured Query Language has been designed as per the current syllabus for Class 12 Informatics Practices released by CBSE. Students studying in Class 12 can easily download in Pdf format and practice the questions and answers given in the above practice worksheet for Class 12 Informatics Practices on a daily basis. All the latest practice worksheets with solutions have been developed for Informatics Practices by referring to the most important and regularly asked topics that the students should learn and practice to get better scores in their examinations. Studiestoday is the best portal for Printable Worksheets for Class 12 Informatics Practices students to get all the latest study material free of cost. Teachers of studiestoday have referred to the NCERT book for Class 12 Informatics Practices to develop the Informatics Practices Class 12 worksheet. After solving the questions given in the practice sheet which have been developed as per the latest course books also refer to the NCERT solutions for Class 12 Informatics Practices designed by our teachers. After solving these you should also refer to Class 12 Informatics Practices MCQ Test for the same chapter. We have also provided a lot of other Worksheets for Class 12 Informatics Practices which you can use to further make yourself better in Informatics Practices.

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