CBSE Class 11 Information Practices Data Manipulation Commands Worksheet

Read and download free pdf of CBSE Class 11 Information Practices Data Manipulation Commands Worksheet. Students and teachers of Class 11 Informatics Practices can get free printable Worksheets for Class 11 Informatics Practices Chapter 8 Introduction to Structured Query Language (SQL) in PDF format prepared as per the latest syllabus and examination pattern in your schools. Class 11 students should practice questions and answers given here for Informatics Practices in Class 11 which will help them to improve your knowledge of all important chapters and its topics. Students should also download free pdf of Class 11 Informatics Practices Worksheets prepared by school teachers as per the latest NCERT, CBSE, KVS books and syllabus issued this academic year and solve important problems with solutions on daily basis to get more score in school exams and tests

Worksheet for Class 11 Informatics Practices Chapter 8 Introduction to Structured Query Language (SQL)

Class 11 Informatics Practices students should refer to the following printable worksheet in Pdf for Chapter 8 Introduction to Structured Query Language (SQL) in Class 11. This test paper with questions and answers for Class 11 will be very useful for exams and help you to score good marks

Class 11 Informatics Practices Worksheet for Chapter 8 Introduction to Structured Query Language (SQL)

Table Creation And Data Manipulation Commands

Q1. Consider the following table named “GYM” with details about Fitness products being sold in the store :

Prcode*Prname**Unitprice***manufacturer
P101Cross trainer25000Avon fitness
P102Treadmill32000AG fitline
P103Massage chair20000Fit Express
P104Vibration trainer22000Avon fitness
P105bike13000Fit express

Write SQL statements to do the following :

a) Display the names of all the products in the store.

b) Display the names and unit price of all the products in the store.

c) Display the names of all the products with unit price less than Rs 200000.00

d) Display details of all the products with unit price in the range 20000 to 30000

e) Display name of all products by the manufacturer “Fit Express”.

f) Display all rows sorted in descending order of unit price.

g) Add a new row for product with the details : “P106”, “Vibro Exercise”, 23000, “Avon Fitness”.

h) Change the unit price data of all the rows by applying 10% discount reduction on all the products.

i) Display details of all products with manufacturer name starting with “A”.

* Prcode : Stores codes of Products. ** Prname : Stores names of Products *** Unit price is in Rs.

Table Creation And Data Manipulation Commands

Q1. Consider the following table “Employee”.

EcodeFirst nameLast nameDepartmentSalary
101AmitSharmaSales3000.500
102ShivAroraPersonnel3560
103KsLakshmiaccounts1500
104ShivikaRajlaniaccounts2980.250
105SatvikThakralsales5322

• Ecode should be declared as Primary key, Unique.

• Salary must be greater than 1000.

• First name and Last name must not remain blank.

• Make data type for “Salary” with 8 digits maximum with 3 digits decimals.

Write SQL statements to do the following :

a) Combine and display the first names and last names of all employees with Example : “Amit Sharma”

b) Display the department names , without duplicates.

c) Display all the details of employees with last names as “Lakshmi”.

d) Display all the details of employees whose last name is “Rajlani” or “Sharma”.

e) Display the codes and first names of all employees of ‘Accounts’ department.

f) Display department names of departments with salary above 18000.

g) Display First name and first letter of Lastname (Exp :Amit S.)

h) Combine and display Second name and First name where department is accounts.

i) Increase 50 OR of all the employees where salary is less than 2000.

j) Delete the records where salary is more than 5000.

k) Display all the first name, salary (round to 0 decimal place).

l) Rename the field Department to Dept.

m)Delete the column Last name.

n) Delete all the records

o) Delete the table.

Q.1 If you have to create a table CUSTOMER. Identify the required data types for each attributes : Cust_ID Customer Identification Number, Cust_Name Customer Name,Cust_Add, Customer Address, Bill_No Customer bill Number

Q.2 Create a table name as “Deptm” with the following structure :

Field NameField TypeConstraint
D NAMEVarchar(14)NOT NULL
AGEInteger 
DEPT NAMEVarchar(10)NOT NULL PRIMARY KEY
DOJVarchar(13) 
SALARYInteger(5) 

(b) Write SQL Commands for the questions form (a) to (h) on the basis of table Teacher.

Table :Teacher

NameAgeDepartmentDate of joinSalary
Jugal24Computer2007-02-1012000
Shanti31History2008-03-2420000
Sandeep32Maths2009-02-2514000
Sangeeta45History2007-04-1520000
Rahat55Computer2007-05-1721000

a) To show all information about the teacher of History department in descending order of their name .

b) To list the male teacher who are in Maths department.

c) To display Name, Salary, where age less than 25 and age equal to or more than 45.

d) Update the Salary by increasing Rs. 1000 for teachers with age more than 55.

e) To Insert a new record in table Teacher with the following data :

‘Raja’, 23, ‘Hindi’, ‘2005-08-19’,12675.

f) Write a SQL command to add following column in above table.

Column Name Data Type Size Constraint Description

Address Varchar 40 Address of the Person

g) Display the name of those teacher whose name started with alphabet ‘S’;

h) To Delete those records where Department is History.

i) Write SQL Command to drop the table Teacher.

2. Find the Output of following :

(i) SELECT ROUND (1.298,1);

(ii) SELECT POW(2,4);

(iii) SELECT LOWER(‘MYSQL QUERY LANGUAGE’);

(iv) SELECT SUBSTR(‘MYSQL LANGUAGE’, 7,8);

(v) SELECT LENGTH(‘INFORMATION’); 

Table Creation And Data Manipulation Commands

Q1. Create table One with the following structure :

Name of columnData typeConstraints
NameVarchar(20)Not null
RollnoNumber(2)Not null
grnoNumber(5) 
AgeNumber(2)Should be more than 13
MarksNumber(2)Should be more than 0
addrChar(20)Default “ISM”

Q2. Write SQL command to display the table structure.

Q3. Add the following data in the above table(ONE) :

NameRollnoGrnoAgeMarksadd
Anil212321489Ism
Beena143531590Ism
sumit365341440Isd
vineet523531467ism

Q4. Add 5 marks for all the students.

Q5. Add 2 marks where rollno greater than 3.

Q6. Change the field name name to Sname.

Q7. Modify the Add char(20) to Char (30).

Q.8. Change the width of Grno to number(4).

Q9. Modify the grno position to first position in the table.

Q10. Update the field grno as Primary Key.

Q11.Delete the record(s) where mark is less than 50.

Q12. Remove the entire contents of the table.

Q13. Drop the table “ONE”. 

Table Creation And Data Manipulation Commands

Q1. Consider the following table named “GYM” with details about Fitness products being sold in the store :

Prcode*Prname**Unitprice***manufacturer
P101Cross trainer25000Avon fitness
P102Treadmill32000AG fitline
P103Massage chair20000Fit express
P104Vibration trainer20000Avon fitness
P105bike13000Fit express

Write SQL statements to do the following :

a) Display the names of all the products in the store.

b) Display the names and unit price of all the products in the store.

c) Display the names of all the products with unit price less than Rs 200000.00

d) Display details of all the products with unit price in the range 20000 to 30000

e) Display name of all products by the manufacturer “Fit Express”.

f) Display all rows sorted in descending order of unit price.

g) Add a new row for product with the details : “P106”, “Vibro Exercise”, 23000, “Avon Fitness”.

h) Change the unit price data of all the rows by applying 10% discount reduction on all the products.

i) Display details of all products with manufacturer name starting with “A”.

* Prcode : Stores codes of Products. ** Prname : Stores names of Products *** Unit price is in Rs. 

More Study Material

CBSE Class 11 Informatics Practices Chapter 8 Introduction to Structured Query Language (SQL) Worksheet

We hope students liked the above worksheet for Chapter 8 Introduction to Structured Query Language (SQL) designed as per the latest syllabus for Class 11 Informatics Practices released by CBSE. Students of Class 11 should download in Pdf format and practice the questions and solutions given in the above worksheet for Class 11 Informatics Practices on a daily basis. All the latest worksheets with answers 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 class tests and examinations. Studiestoday is the best portal for Class 11 students to get all the latest study material free of cost.

Worksheet for Informatics Practices CBSE Class 11 Chapter 8 Introduction to Structured Query Language (SQL)

Expert teachers of studiestoday have referred to the NCERT book for Class 11 Informatics Practices to develop the Informatics Practices Class 11 worksheet. If you download the practice worksheet for one chapter daily, you will get higher and better marks in Class 11 exams this year as you will have stronger concepts. Daily questions practice of Informatics Practices 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 worksheet for Class 11 Informatics Practices also from www.studiestoday.com without paying anything in Pdf format. After solving the questions given in the worksheet which have been developed as per the latest course books also refer to the NCERT solutions for Class 11 Informatics Practices designed by our teachers

Chapter 8 Introduction to Structured Query Language (SQL) worksheet Informatics Practices CBSE Class 11

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

Chapter 8 Introduction to Structured Query Language (SQL) CBSE Class 11 Informatics Practices Worksheet

Regular worksheet practice helps to gain more practice in solving questions to obtain a more comprehensive understanding of Chapter 8 Introduction to Structured Query Language (SQL) concepts. Worksheets play an important role in developing an understanding of Chapter 8 Introduction to Structured Query Language (SQL) in CBSE Class 11. Students can download and save or print all the worksheets, printable assignments, and practice sheets of the above chapter in Class 11 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 11 Informatics Practices MCQ Test for the same chapter.

Worksheet for CBSE Informatics Practices Class 11 Chapter 8 Introduction to Structured Query Language (SQL)

CBSE Class 11 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 Chapter 8 Introduction to Structured Query Language (SQL) and then take out a print of the above worksheet and attempt all problems. We have also provided a lot of other Worksheets for Class 11 Informatics Practices which you can use to further make yourself better in Informatics Practices

Where can I download latest CBSE Printable worksheets for Class 11 Informatics Practices Chapter 8 Introduction to Structured Query Language (SQL)

You can download the CBSE Printable worksheets for Class 11 Informatics Practices Chapter 8 Introduction to Structured Query Language (SQL) for latest session from StudiesToday.com

Can I download the Printable worksheets of Chapter 8 Introduction to Structured Query Language (SQL) Class 11 Informatics Practices in Pdf

Yes, you can click on the links above and download Printable worksheets in PDFs for Chapter 8 Introduction to Structured Query Language (SQL) Class 11 for Informatics Practices

Are the Class 11 Informatics Practices Chapter 8 Introduction to Structured Query Language (SQL) Printable worksheets available for the latest session

Yes, the Printable worksheets issued for Class 11 Informatics Practices Chapter 8 Introduction to Structured Query Language (SQL) have been made available here for latest academic session

How can I download the Class 11 Informatics Practices Chapter 8 Introduction to Structured Query Language (SQL) Printable worksheets

You can easily access the links above and download the Class 11 Printable worksheets Informatics Practices Chapter 8 Introduction to Structured Query Language (SQL) for each chapter

Is there any charge for the Printable worksheets for Class 11 Informatics Practices Chapter 8 Introduction to Structured Query Language (SQL)

There is no charge for the Printable worksheets for Class 11 CBSE Informatics Practices Chapter 8 Introduction to Structured Query Language (SQL) you can download everything free

How can I improve my scores by solving questions given in Printable worksheets in Class 11 Informatics Practices Chapter 8 Introduction to Structured Query Language (SQL)

Regular revision of practice worksheets given on studiestoday for Class 11 subject Informatics Practices Chapter 8 Introduction to Structured Query Language (SQL) can help you to score better marks in exams

Are there any websites that offer free test sheets for Class 11 Informatics Practices Chapter 8 Introduction to Structured Query Language (SQL)

Yes, studiestoday.com provides all latest NCERT Chapter 8 Introduction to Structured Query Language (SQL) Class 11 Informatics Practices test sheets with answers based on the latest books for the current academic session

Can test papers for Class 11 Informatics Practices Chapter 8 Introduction to Structured Query Language (SQL) be accessed on mobile devices

Yes, studiestoday provides worksheets in Pdf for Chapter 8 Introduction to Structured Query Language (SQL) Class 11 Informatics Practices in mobile-friendly format and can be accessed on smartphones and tablets.

Are worksheets for Chapter 8 Introduction to Structured Query Language (SQL) Class 11 Informatics Practices available in multiple languages

Yes, worksheets for Chapter 8 Introduction to Structured Query Language (SQL) Class 11 Informatics Practices are available in multiple languages, including English, Hindi