Official Class 11 Informatics Practices Worksheets: My Sql
Explore reliable practice materials for My Sql tailored for Class 11 learners. Utilizing these Informatics Practices worksheets ensures thorough preparation and strengthens problem-solving speed for upcoming school assessments.
Chapter-wise Practice Material: My Sql
Access the complete worksheet PDF for My Sql below. Regular practice with these targeted questions builds familiarity with standard exam patterns and helps secure higher marks in final Informatics Practices evaluations.
Topic : MySQL
Lab Work Sheet
I Give the output of the following code :
1. SELECT ASCII(“A”);
2. SELECT CONCAT(CONCAT(„Comp‟, „uter‟), „Studies‟);
3. SELECT LOWER(„BOARD‟) FROM DUAL;
4. SELECT ROUND(29.21), ROUND(32.76) FROM DUAL;
5. SELECT ROUND(29.21,1), ROUND(356.78, -1) FROM DUAL;
6. SELECT 9 MOD 2;
7. SELECT POWER(13,2);
8. SELECT LENGTH(„INFORMATICS‟);
9. SELECT LEFT(„RHOMBUS‟,4);
10. SELECT MID(„Quadrilateral‟,4,5);
11. SELECT SUBSTR(„COMPUTER‟,4,3);
12. SELECT SUBSTR(„COMPUTER‟,-5,4);
13. SELECT SIGN(-16) “SIGN”;
14. SELECT SQRT(625) “Square root”;
15. SELECT TRUNCATE(25.79,1) “Truncate”;
16. SELECT TRUNCATE(25.79,-1) “Truncate”;
17. SELECT UPPER(„India‟) FROM DUAL;
18. SELECT TRIM(„ ONE „);
19. SELECT LTRIM(„ CHECK „);
20. SELECT RTRIM(„ TWO „);
21. SELECT CHAR(101);
22. SELECT INSTR(„CORPORATE OFFICE‟, „OR‟);
23. SELECT RIGHT(„MUSCAT‟,2);
24. SELECT NOW(), SLEEP(10),NOW();
25. SELECT SYSDATE(), SLEEP(10), SYSDATE();
26. SELECT LCASE(„INDIA‟);
II Write SQL Commands for the following :
1. Display current date on your system.
2. Display current date and time on your system.
3. Display date after 15 days of current date.
4. Display month from the date 3rd Feb 2010.
5. Display year from the date 21st Nov 2017.
6. Display the name of weekday for the date 17th Oct 2015.
7. Display the day of month for the date 28th Sep 2010.
8. Display the day of the week for the date 5th Nov 2012.
9. Display the day of the year for the date 23rd Dec 2014.
10. Display the date from a given date time value „2010-11-30 11:12:28‟
Please click on below link to download CBSE Class 11 Informatics Practices My Sql Worksheet Set E
Exam Preparation Worksheet for Class 11 Informatics Practices My Sql
Download Practice Sheet: My Sql (Class 11 Informatics Practices)
Access structured practice worksheets for My Sql designed in alignment with the latest CBSE curriculum for Class 11 Informatics Practices. These printable problem sets help students build accuracy and prepare effectively for school tests.
Concept Clarification for My Sql
Built using the official NCERT book for Class 11 Informatics Practices, these practice materials provide reliable academic guidance. Pair your practice with our recommended NCERT solutions to master optimal problem-solving approaches.
Additional Study Resources for Class 11 Informatics Practices
Wrap up your chapter revision by testing your knowledge against standard question formats. Everything on our platform is provided free of charge.
FAQs
You can download the teacher-verified PDF for CBSE Class 11 Informatics Practices My Sql Worksheet Set 05 from StudiesToday.com. These practice sheets for Class 11 Informatics Practices are designed as per the latest CBSE academic session.
Yes, our CBSE Class 11 Informatics Practices My Sql Worksheet Set 05 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 11.
Yes, we have provided detailed solutions for CBSE Class 11 Informatics Practices My Sql Worksheet Set 05 to help Class 11 and follow the official CBSE marking scheme.
Daily practice with these Informatics Practices worksheets helps in identifying understanding gaps. It also improves question solving speed and ensures that Class 11 students get more marks in CBSE exams.
All our Class 11 Informatics Practices practice test papers and worksheets are available for free download in mobile-friendly PDF format. You can access CBSE Class 11 Informatics Practices My Sql Worksheet Set 05 without any registration.