CBSE Class 11 Information Practices Functions In My Sql Worksheet Set D

CBSE Class 11 Information Practices - Functions in My SQL (4). Students can download these worksheets and practice them. This will help them to get better marks in examinations. Also refer to other worksheets for the same chapter and other subjects too. Use them for better understanding of the subjects.

FUNCTIONS IN MySQL

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’);

Please click the link below to download CBSE Class 11 Information Practices - Functions in My SQL (4)