MySQL Functions Quiz 5

Share with others

Welcome to your MySQL Functions Quiz 5

Name
Email
School Name
Q41. Write the output of following:

select round(2565.7865, -3)

Q42. Write the output of following:

select round(2565.4920, -2)

Q43. Which of the following statement may give current year like 2023 or 2024 as output?

Q44. Which of the following statement may give 19 as output?

Q45. Write the command to display the position of 'm' in string "Commerce"

Q46. Which command will display first five characters of string "MySQL Practice"?

Q47. Write the command to extract "SQL" from the string "MySQL Practice"

Q48. Write the output of the following:

select length(trim("   Computer   ")) //3 spaces before and after the word Computer

Q49. Write the output of the following:

select power(instr("2134",'3'),2)

Q50. Write the command to display the remainder on dividing 2 raised to the power 11 by 4.


Share with others

Leave a Reply

error: Content is protected !!