MySQL Functions Quiz 2

Share with others

Welcome to your MySQL Functions Quiz 2

Q11. Which of the following SQL command is used to add a new column in a table?

Q12. Which of the following function is used to change the case of string?

Q13. Write the output of the statement : select upper("mysql")

Q14. Which of the following function return numeric value?

Q15. Which of the following function help to extract substring from main string?

Q16. ___________ return the number of characters in the specified string.

Q17. Which of the following function takes one argument?

Q18. ________________ function returns the position of the first occurrence of the substring in the given string.

Q19. Write the output of statement: Select instr(“Informatics”, “ma”);

Q20. Which function returns the string after removing leading white space characters.

Share with others

Leave a Reply

error: Content is protected !!