Scribd
Upload
20 views1 page

Chapter4 - Worksheet 2 SingleRowFunctions

This worksheet is designed for Grade XII students at The Emirates National School in Sharjah, focusing on MySQL database queries. It includes questions on single row functions, such as string concatenation, substring extraction, and numeric computations. Additionally, students are required to write outputs for various SQL statements demonstrating their understanding of these functions.

Uploaded by

zainab.mustafa290
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
20 views1 page

Chapter4 - Worksheet 2 SingleRowFunctions

This worksheet is designed for Grade XII students at The Emirates National School in Sharjah, focusing on MySQL database queries. It includes questions on single row functions, such as string concatenation, substring extraction, and numeric computations. Additionally, students are required to write outputs for various SQL statements demonstrating their understanding of these functions.

Uploaded by

zainab.mustafa290
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

THE EMIRATES NATIONAL SCHOOL – SHARJAH

INFORMATICS PRACTICES Worksheet


Grade XII (2025-’26)
CHAPTER 4 – Database Query Using MySQL

[Worksheet 2 – Single Row Functions]

1) Name the following:


a) A function can be used to concatenate two strings.
b) Function(s) that can be used for extracting substrings.
c) A function working with every row of a table.
d) Another term used for single row functions.
e) A special type of predefined command set that performs operations and returns a
single value in MySQL.
f) A function with work with numeric values to compute the result of ab

2) Write the output for the following SQL statements:


(i) SELECT INSTR("INDIA", "ID");;
(ii) SELECT UPPER(CONCAT("It", "was", "ok"));
(iii) SELECT LCASE(MONTHNAME('2023-03-05'));
(iv) SELECT ROUND(153.669, 2);
(v) SELECT MONTH('2020-05-11');
(vi) SELECT ROUND(49.88);
(vii) SELECT MOD(9, 0);
(viii) SELECT ROUND(144.23,-1) FROM dual;
(ix) SELECT SUBSTR('MYSQL APPLICATIONS', 3, 7);
(x) SELECT INSTR('ARTIFICIAL INTELLIGENCE', 'i');
(xi) SELECT LOWER(RIGHT('CHARACTER’, 5, 3));
(xii) SELECT LENGTH(TRIM(' EXAMINATION ');
(xiii) SELECT LEFT("INDIA",3), RIGHT("Computer Science",4);

You might also like