Page 1 :
ST. JOHN’S SR. SEC. SCHOOL, DAMOH, Class Test-3, Fill in the blanks – MySQL Functions, 1. A __________ is pre-defined set of commands that is used to perform a specific, task and return values., 2. The values that are provided to function is called __________ or __________., 3. The ___________ functions allows to manipulate the text from table or string, passed as parameter to the function., 4. The ___________ function returns the character for the passed integer number., 5. To display a specific word from a text, __________ function is used., 6. The ____________ function removes leading extra spaced from the text., 7. To know the length of specified text, the __________ function is used., 8. The ___________ function accepts numeric values and returns numerical values, as well., 9. The ___________ function returns remainder of specified two numbers., 10. A _________ MySQL function returns square of the given number., 11. Mr. Kalpesh wants to ignore the fractional part of the number. A ___________, function will help him to serve his purpose., 12. To know the square root of the given number in MySQL ___________ function, will be used., 13. The ___________ function returns only specified digits from the given digits., 14. To convert the first letter of each word into capital, MySQL provides, ____________ function., , MCQs – MySQL Functions class 12 IP, 1. Which following is not a category of MySQL functions?, 1. Text Functions, 2. Mathematical Functions, 3. Statistical Functions, 4. Arithmetic Functions, 2. What is the output – select concat(5,5) :, 1. 55, 2. 10, 3. 5, 4. 25, 3. Suppose playername and rank are the columns of an ODI_RANKING table., The user wants to print a record in this manner: Virat Kohli is ranked First., Where Virat Kohli is the player name and First is rank. Which of the following, is the correct statement for the same:, 1. select concat(playername, ” is ranked “, rank) from ODI_RANKING where, rank=”First”;

Page 2 :
4., , 5., , 6., , 7., , 8., , 2. select concat(concat(playername, ” is ranked “),rank) from ODI_RANKING, where rank = “First”;, 3. select concat(concat(playername, ” is ranked “),rank) where rank = “First”, from ODI_RANKING ;, 4. All of these, What is the output of – select char(73,67,69); –, 1. ICE, 2. CAT, 3. ACE, 4. ECE, Which of the following function can be used as lower(); –, 1. lowercase(), 2. lower_case(), 3. lcase(), 4. l_case(), What will be the output of – select substr(“Year2020”,4,4) –, 1. 2020, 2. Year, 3. r202, 4. None of these, What will the output of – select round(12345.678,0); –, 1. 12345, 2. 12346, 3. 12350, 4. 12346.0, What will be returned by sign(-15), 1. -15, 2. -1, 3. Negative 15, 4. 15, , True/False –, , Text functions cannot accept numbers as arguments. –, The concat() function make additions for two numbers. –, The substr() and instr() function returns similar output. –, The trim() function removes extra leading and trailing spaces from the text. –, The instr() function returns the index position of the specified word from, selected string or text., 6. The length() function ignore blank spaces from the text. –, 7. When the string or text is null, length() function counts null as 1 character. –, 8. The mid() function is synonym for substring() function. –, 9. round() and truncate() functions returns the similar values. –, 10. The sign() function returns the number with sign only. –, 1., 2., 3., 4., 5.