Read and download free pdf of CBSE Class 11 Information Practices Functions In My Sql 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 teachers as per the latest Informatics Practices 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)
Q1. Write the output for the following statements:
Statement
Output
Statement
Output
1
SELECT POW(2,4);
12
SELECT POW(2,-2);
2
SELECT POW(-2,3);
13
SELECT POW(-2,-3);
3
SELECT ROUND(-1.23);
14
SELECT ROUND(-1.57);
4
SELECT ROUND(-1.58);
15
SELECT ROUND(1.43);
5
SELECT ROUND(6.298,1);
16
SELECT ROUND(6.235,0);
6
SELECT ROUND(56.34,-1);
17
SELECT TRUNCATE(7.543,1);
7
SELECT TRUNCATE(4.567,0);
18
SELECT TRUNCATE(-76.56,1)
8
SELECT TRUNCATE(342,-2);
19
SELECT SQRT(25);
9
SELECT SQRT(125);
20
SELECT SIGN(-43);
10
SELECT SIGN(654);
21
SELECT SIGN(-25);
11
SELECT LENGTH(‘INDIA’);
22
SELECT LENGTH(‘4321’);
23
SELECT CONCAT(‘My’, ‘S’, ‘SQL’);
24
SELECT CONCAT(‘Class’, NULL, ‘XI’);
25
SELECT INSTR (‘INFORMATICS’, ‘FOR’);
26
SELECT INSTR (‘COMPUTERS’, ‘PER’);
27
SELECT INSTR (‘COMPUTER’, ‘pu’);
28
SELECT LOWER (‘INFORMATION’);
29
SELECT UPPER (‘Indian’);
30
SELECT LCASE (‘IT’);
32
SELECT UCASE (‘COMPUTER’);
Statement
Output
33
SELECT LEFT (‘Information’, 3);
34
SELECT LEFT(“SCIENCE”,6);
35
SELECT RIGHT (‘INFORMATICS’,4);
36
SELECT LTRIM (‘ Class ’);
37
SELECT RTRIM (‘ Class ’);
38
SELECT TRIM (‘ Class ’);
39
SELECT SUBSTRING (‘INFORMATICS’,3);
40
SELECT SUBSTRING (‘INFORMATION’, FROM 4);
41
SELECT SUBSTRING (‘INFORMATION’, 3,4);
42
SELECT SUBSTRING (‘INFORMATION’, -3);
43
SELECT SUBSTRING (‘INFORMATION’, -5,3);
44
SELECT SUBSTRING (‘INFORMATION’, FROM -4 FOR 2);
45
SELECT ASCII(‘B’);
46
SELECT CHAR(65);
47
SELECT CURDATE ( );
48
SELECT NOW ( );
49
SELECT SYSDATE ( );
50
SELECT DATE (‘2016-02-26 01:02:03’);
51
SELECT MONTH (‘2016-02-26’);
52
SELECT YEAR (‘2016-02-26’);
53
SELECT DAYNAME(‘2016-02-26’);
54
SELECT DAYOFMONTH(‘2016-02-26’);
55
SELECT DAYOFWEEK(‘2016-02-26’);
56
SELECT DAYOFYEAR(‘2016-02-26’);
Q1. Create a Table “Employee” with the following constraints
FIELD NAME | DATA TYPE | CONSTRAINT | FIELD NAME | DATA TYPE | CONSTRAINT |
empcode | char(4) | PRIMARY KEY,NOT ULL | empdoj | date | |
empname | varchar(25) | NOT NULL | empdept | varchar(20) | |
empadd | varchar(30) | empphone | int | ||
empgender | char(1) | empdesg | varchar(20) | ||
empdob | date | empsal | int |
Q2. Add 10 records to the above table “Employee”.
Q3. Write the following SQL commands on the basis of above table “Employee”
a) Show all the information of the employees.
b) Display all the employee names, designation and salary.
c) Display all the employee names and their salary in descending order.
d) Display all the different departments in the company.
e) Display all the details of Female Employee.
f) Display the employee name, address and phone number from “HR” department.
g) Display all the details of employee name starting with “a”.
h) Display all the employee details (name, designation , department and gender) with salary 1000 OR to 2000 OR.
i) Display all the details of the staff that joined from year 2000.
j) Display the names of all the “GM” in the company. (GM- General Manager).
k) Display the names of all the employees from “finance” department with salary more than 1000
l) Display the names of all the Male employees from “transport” department with salary less than 1000 .
m) Display the details of the entire employee NOT from “Sales” department.
n) Display the name, address of employee without phone number.
Q1. Create a Table “Class” with the following constraints (Rollno(2), Name Varchar(30), Stipend number(5), Subject Char(25), Avgmark decimal(6,2),Grade char(1));
ROLLNO | NAME | STIPEND | SUBJECT | AVGMARK | GRADE |
1 | VIKAS | 1200 | MEDICAL | 67 | B |
2 | BOBY | 1400 | HUMANITIES | 78.8 | B |
3 | TARUN | 1000 | MEDICAL | 64.8 | C |
4 | VARUN | 1800 | NON-MEDICAL | 84 | A |
5 | ATUL | 1800 | NON-MEDICAL | 90 | A |
Q2. Write the following SQL commands on the basis of above table “CLASS”
a) Display all the Non Medical stream students Name from the table Class.
b) List the Names that have grade “A” sorted by stipend in the ascending order.
c) Arrange the records Average marks wise .
d) List the records where grade is B or C.
e) Display the records where Name ends with N.
f) Display those records whose average mark in between 70 to 90.
g) Display the different Subjects in the table.
h) Display students Name where Avergemarks is more than 75.
i) Display all records in Descending order (Name) wise.
j) Insert a new row with the following data (06, ‘MITHUN’, 1300, ‘HUMANITIES’, ‘98’,’A’).
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
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
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
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
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
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
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
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
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.
Yes, worksheets for Chapter 8 Introduction to Structured Query Language (SQL) Class 11 Informatics Practices are available in multiple languages, including English, Hindi
CBSE Class 11 Informatics Practices worksheets help students practice all concepts given in their books, improve problem-solving skills, and prepare effectively for CBSE exams
CBSE Class 11 Informatics Practices Chapter 8 Introduction to Structured Query Language (SQL) worksheets cover all topics as per the latest syllabus for current academic year.
Regular practice with Class 11 Informatics Practices worksheets can help you understand all concepts better, you can identify weak areas, and improve your speed and accuracy.
All worksheets for Class 11 Informatics Practices and for Chapter 8 Introduction to Structured Query Language (SQL) have solved questions with step by step guide for each solution
Practice atleast one worksheet of Chapter 8 Introduction to Structured Query Language (SQL) every day for Class 11 Informatics Practices