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.