MySQL Functions Quiz 6

Share with others

Welcome to your MySQL Functions Quiz 6

Name
Email
School Name
Q51. Write a statement in SQL to calculate the square of 5.

Q52. Write the output of the following:

Select round(945.3951, 3);

Q53. Write a query to display the different types of "sport" from table "student".

Q54. Write a query to count the different types of "sport" from table "student".

Q55. Write the output of the following:

select power(instr("Communication", "u"), instr("Power","o"));

Q56. Write a statement to display only the first character from column "name" in upper case from table "student".

Q57. Which statement will display the maximum sales of each area.

Q58. Write the output of the following:

select pow(3, mod(17,3));

Q59. Which of the following query display the system date and time?

Q60. Which of the following statement may give "Monday" as output?


Share with others

Leave a Reply

error: Content is protected !!