CBSE Class 12 Informatics Technology Structured Query Language Worksheet Set 01

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

Download Structured Query Language Worksheet PDF

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

Free study material for Informatics Practices

Download CBSE Practice Material: Class 12 Informatics Practices Structured Query Language

Structured Query Language Printable Worksheet for 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.

How to Use These Practice Sheets

Cross-reference your completed exercises with comprehensive NCERT solutions for Class 12 Informatics Practices to ensure absolute clarity across all sub-topics in this chapter.

Enhance Speed with Online Practice

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

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

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

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