Read and download free pdf of CBSE Class 12 Informatics Practices MySQL Worksheet. Students and teachers of Class 12 Informatics Practices can get free printable Worksheets for Class 12 Informatics Practices MySQL in PDF format prepared as per the latest syllabus and examination pattern in your schools. Class 12 students should practice questions and answers given here for Informatics Practices in Class 12 which will help them to improve your knowledge of all important chapters and its topics. Students should also download free pdf of Class 12 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 12 Informatics Practices MySQL
Class 12 Informatics Practices students should refer to the following printable worksheet in Pdf for MySQL in Class 12. This test paper with questions and answers for Class 12 will be very useful for exams and help you to score good marks
Class 12 Informatics Practices Worksheet for MySQL
Q1. a) Raju wants to change the schema of the table “ STUDENT ” which already exists in the database. Which command he will use.
1 b) Neha is not able to enter the details of students born after ‘ 30-Mar-2007’. Which constraint might be specified when the table was created.
1 c) What is the purpose of the following query. 1 SELECT COUNT(*) FROM ELECTION GROUP BY city.
d) What is the role of UNIQUE constraint? How is PRIMARY KEY constraint differ from UNIQUE key constraint.
2 e) What is the significant of ORDER BY command in SQL query.
2 f) ActivityName and ParticipantNo of table ACTIVITY given below 2 Activity Name ParticipantNo Relay 100X 4 16 High Jump 10 Shot Put 12 Long Jump 12 Discuss Throw 10 Based on this information, find the output of the following queries.
a) SELECT COUNT( DISTINCT ParticipantNo) FROM ACTIVITY;
b) SELECT ActivityName FROM ACTIVITY WHERE ActivityName LIKE ‘%p’;'
g) A table Employee in a database has a 4 columns and 2 rows in it. What is cardinality and degree if 3 more columns are added in the table? 1 Q2. A)Write an SQL query to create following table ‘ Supplier’ with following descriptions. 2 Table : Supplier Field Type Constraint Supp_id Varchar(5) Primary Key Supp_Name Varchar(20) Not Null City Varchar(20) Order_No Integer(10) Foreign key with reference to Order_No column in Order table Supp_Amount Decimal(6,2) Minimum 10000 b) In database there are two tables “Student” and “Stream” as below : Table: Student Sid Sname age Strid 1 Roondy 10 1 2 Joseph 12 1 3 Trinchu 14 2 4 Prithlon 11 3 5 Ahol 10 2
Q. Create the following tables with the following constraints and values.
Table : TicketDetails
| Field Name | Datatype | Size | Constraint |
| Tcode | Char | 5 | Primary Key |
| Name | Varchar | 20 | Not Null |
| Tickets | Int | 2 | Default 0 |
| Acode | Char | 4 |
Q. Add the following values to the above table
| Tcode | Name | Tickets | Acode |
| S001 | Meena | 7 | A01 |
| S002 | Vani | 5 | A02 |
| S003 | Meena | 9 | A03 |
| S004 | Rhea | 3 | A04 |
| S005 | Suraj | 1 | A05 |
Table : AgentDetails
| Field Name | Datatype | Size | Constraint |
| Acode | Char | 4 | |
| AName | Varchar | 20 |
Add the following values to the above table
| Acode | AName |
| A01 | Mr. Robin |
| A02 | Mr. Ayush |
| A03 | Mr. Trilok |
| A04 | Mr. John |
Q. To display Tcode,Name and Aname of all the records where the number of tickets sold is more than 5.
Q. To list out Name, Tickets,A_code and Aname for all the Agent Details.
Q. To list out all the Acode, Aname and corresponding Tcode where Aname ends with ‘k’.
Q. To Total number of tickets booked by each customer.
Q. To display total number of tickets booked by agent “Mr. Ayush”.
Q1. Create the Table Emp with the following constraints:
| Field Name | Data Type | Size | Constraint |
| ID | Int | 2 | Primary Key |
| Name | Varchar | 20 | Not Null |
| Age | Int | 3 | |
| Address | Char | 40 | |
| Salary | Int | 7 | |
| Phone | Char | 15 |
Q2. Add the following records to the above table “Emp” and Write commands in SQL
| ID | NAME | AGE | ADDRESS | SALARY | PHONE |
| 1 | Siddharth | 25 | A-4, Ashok Vihar, Delhi | 62000 | 98110766656 |
| 2 | Chavi | 23 | B-21, Model Town, Mumbai | 71000 | 99113423989 |
| 3 | Karan | 26 | KC-24, North Avenue, Bhopal | 65000 | 98105393578 |
| 4 | Raunaq | 22 | A-152, Gomti Nagar, Lucknow | 89000 | 99101393576 |
| 5 | Kunal | 27 | B-5/45, Uday Park, Delhi | 80000 | 97653455654 |
| 6 | Karan | 25 | A-Block,AMT Vihar,Chennai | 94000 | 945287653241 |
| 7 | Paul | 25 | S-25,BLB Appts, Bangalore | 75000 | 988765442312 |
1. To display list of all employees below 25 years old.
2. To list names and respective salaries in descending order of salary.
3. To count the number of employees with names starting with ‘K’
4. To list names and addresses of those persons who have ‘Delhi’ in their address.
5. To list out all the employees whose salary is in between 70000 and 80000.
6. Count number of employees based on their age group.
7. To list out all the employee names whose phone number starts with ‘99’.
8. To display all the details of employee whose salary is above 85000.
9. To display all the employee names whose name contains the character ‘a’ anywhere.
Find the output:
1.select name from emp where sal=select max(sal) from emp;
2. select length(name) from emp where salary >82000;
3. select 9* 4 from emp where id>6;
4. select Left(address,4) from emp where id <3;
5. select mid(name,2,3) from emp where address like ‘%delhi%’;
| CBSE Class 12 Informatics Practices Data Handling using Pandas Worksheet |
| CBSE Class 12 Informatics Practices Societal Impacts Worksheet |
More Study Material
CBSE Class 12 Informatics Practices MySQL Worksheet
We hope students liked the above worksheet for MySQL designed as per the latest syllabus for Class 12 Informatics Practices released by CBSE. Students of Class 12 should download in Pdf format and practice the questions and solutions given in the above worksheet for Class 12 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 12 students to get all the latest study material free of cost.
Worksheet for Informatics Practices CBSE Class 12 MySQL
Expert 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 one chapter daily, you will get higher and better marks in Class 12 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 12 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 12 Informatics Practices designed by our teachers
MySQL worksheet Informatics Practices CBSE Class 12
All worksheets 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 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 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.
MySQL CBSE Class 12 Informatics Practices Worksheet
Regular worksheet practice helps to gain more practice in solving questions to obtain a more comprehensive understanding of MySQL concepts. Worksheets play an important role in developing an understanding of MySQL in CBSE Class 12. Students can download and save or print all the worksheets, printable 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 MySQL
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 MySQL 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 12 Informatics Practices which you can use to further make yourself better in Informatics Practices
You can download the CBSE Printable worksheets for Class 12 Informatics Practices MySQL for latest session from StudiesToday.com
Yes, you can click on the links above and download Printable worksheets in PDFs for MySQL Class 12 for Informatics Practices
Yes, the Printable worksheets issued for Class 12 Informatics Practices MySQL have been made available here for latest academic session
You can easily access the links above and download the Class 12 Printable worksheets Informatics Practices MySQL for each chapter
There is no charge for the Printable worksheets for Class 12 CBSE Informatics Practices MySQL you can download everything free
Regular revision of practice worksheets given on studiestoday for Class 12 subject Informatics Practices MySQL can help you to score better marks in exams
Yes, studiestoday.com provides all latest NCERT MySQL Class 12 Informatics Practices test sheets with answers based on the latest books for the current academic session
Yes, studiestoday provides worksheets in Pdf for MySQL Class 12 Informatics Practices in mobile-friendly format and can be accessed on smartphones and tablets.
Yes, worksheets for MySQL Class 12 Informatics Practices are available in multiple languages, including English, Hindi