CBSE Class 11 Informatics Practices My Sql Worksheet Set E

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