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

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

Functions in MySQL

Question 1. Write the output for the following statements:
Answer:

In simple words: This table systematically presents the calculated outputs of mathematical, text-formatting, string, and date-related queries using standard built-in functions in MySQL.

Exam Tip: Be mindful of string functions like `INSTR` and `SUBSTRING` where indexing in MySQL is 1-based, unlike standard programming languages where it is 0-based. Also, remember that concatenating any string with a `NULL` value yields a final output of `NULL`.