CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set A

Read and download free pdf of CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set A. 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
 
1 Create a table EMPLOYEE with the following fields
EmpNo     integer
Name        20 characters
Dept         20 characters
Salary       Decimal (10,2)
 
Ensure that the following constraints are met :
• Empno is the Primary Key
• Default value of Salary is 2000
• Dept should be any of the values given below - “Accounts”, “Sales”,“Production”, “Stores”.
 
2 Insert the details of 5 employees.
CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set A
3 Display the structure and contents of the entire table.
 
4 Display in the following format
Ajay gets a salary 2000 for the employees in Accounts Department.
 
5 Display the various departments from the table.
 
6 Add a Column bonus of data type Decimal(8,2)..
 
7 Compute the bonus as 20% of the salary.
 
8 Add a Column NetPay of type Decimal(10,2).
 
9 Compute Netpay as salary + bonus.
 
10 Display the names of the employees whose salary is in the range 20,000 – 50,000.
 
11 Di Display the details of employees whose name ends with the letter ‘n’.
 
12 Display the names of the employees whose name is starting with letter ‘A’.
 
13 Display the department and salary of employees having exactly 5 letters in the name.
 
14 Display the details of employees who have the letter combination ‘sh’ in their name.
 
15 Change the data type of Dept to 12 characters.
 
16 Delete the details of the employees from Sales Department.
 
17 Drop the column Bonus from the table.
 
18 Drop the default value for Salary.
 
19 Add a new default value for salary as 3500.
 
20 Delete the table.


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

More Study Material

CBSE Class 12 Informatics Practices Structured Query Language 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.

Worksheet for Informatics Practices CBSE Class 12 Structured Query Language

Teachers of studiestoday have referred to the NCERT book for Class 12 Informatics Practices to develop the Informatics Practices Class 12 worksheet. If you download the practice worksheet for the above chapter daily, you will get better scores in Class 12 exams this year as you will have stronger concepts. Daily questions practice of Informatics Practices printable worksheet and its study material will help students to have a stronger understanding of all concepts and also make them experts on all scoring topics. You can easily download and save all revision Worksheets for Class 12 Informatics Practices also from www.studiestoday.com without paying anything in Pdf format. 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

Structured Query Language worksheet Informatics Practices CBSE Class 12

All practice paper sheet given above for Class 12 Informatics Practices have been made as per the latest syllabus and books issued for the current academic year. The students of Class 12 can be assured that the answers have been also provided by our teachers for all test paper of Informatics Practices so that you are able to solve the problems and then compare your answers with the solutions provided by us. We have also provided a lot of MCQ questions for Class 12 Informatics Practices in the worksheet so that you can solve questions relating to all topics given in each chapter. All study material for Class 12 Informatics Practices students have been given on studiestoday.

Structured Query Language CBSE Class 12 Informatics Practices Worksheet

Regular printable worksheet practice helps to gain more practice in solving questions to obtain a more comprehensive understanding of Structured Query Language concepts. Practice worksheets play an important role in developing an understanding of Structured Query Language in CBSE Class 12. Students can download and save or print all the printable worksheets, assignments, and practice sheets of the above chapter in Class 12 Informatics Practices in Pdf format from studiestoday. You can print or read them online on your computer or mobile or any other device. After solving these you should also refer to Class 12 Informatics Practices MCQ Test for the same chapter.

Worksheet for CBSE Informatics Practices Class 12 Structured Query Language

CBSE Class 12 Informatics Practices best textbooks have been used for writing the problems given in the above worksheet. If you have tests coming up then you should revise all concepts relating to Structured Query Language and then take out a print of the above practice sheet and attempt all problems. 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

Can I download the Practice worksheets of Class 12 Informatics Practices Structured Query Language in Pdf

Yes, you can click on the links above and download chapter-wise Practice worksheets in PDFs for Class 12 for Informatics Practices Structured Query Language

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

How can I download the Structured Query Language Class 12 Informatics Practices Practice worksheets

You can easily access the links above and download the Class 12 Practice worksheets Informatics Practices for Structured Query Language

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

Can test sheet papers for Structured Query Language Class 12 Informatics Practices be accessed on mobile devices

Yes, studiestoday provides worksheets in Pdf for Structured Query Language Class 12 Informatics Practices in mobile-friendly format and can be accessed on smartphones and tablets.

Are practice worksheets for Class 12 Informatics Practices Structured Query Language available in multiple languages

Yes, practice worksheets for Class 12 Informatics Practices Structured Query Language are available in multiple languages, including English, Hindi