Creating stored functions in MySQL - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to start creating a stored function named 'getSquare'.

MySQL

CREATE FUNCTION getSquare(num INT) RETURNS INT [1]

Drag options to blanks, or click blank then click option'

AAS

BBEGIN

CDECLARE

DEND

Attempts:

3 left

💡 Hint

Common Mistakes

Using AS instead of BEGIN to start the function body.

Forgetting to start the function body with BEGIN.

The BEGIN keyword starts the body of the stored function in MySQL.

2fill in blank

medium

Complete the code to return the square of the input number inside the function.

MySQL

RETURN [1] * num; END

Drag options to blanks, or click blank then click option'

Anum - 1

Bnum + 1

Cnum

Dnum / 2

Attempts:

3 left

💡 Hint

Common Mistakes

Returning num + 1 instead of num * num.

Using division or subtraction instead of multiplication.

The function should return num * num to calculate the square.

3fill in blank

hard

Fix the error in the function declaration by completing the missing keyword.

MySQL

CREATE FUNCTION getDouble(num INT) RETURNS INT [1] RETURN num * 2; END

Drag options to blanks, or click blank then click option'

AFUNCTION

BAS

CDECLARE

DBEGIN

Attempts:

3 left

💡 Hint

Common Mistakes

Using AS instead of BEGIN to start the function body.

Omitting the BEGIN keyword entirely.

The function body must start with BEGIN before statements like RETURN.

4fill in blank

hard

Fill both blanks to declare a variable and set it to the square of the input number.

MySQL

DECLARE result INT; SET result = num [1] num; RETURN [2]; END

Drag options to blanks, or click blank then click option'

A*

Bresult

C+

Dnum

Attempts:

3 left

💡 Hint

Common Mistakes

Using + instead of * for multiplication.

Returning num instead of the result variable.

Use * to multiply and return the variable result.

5fill in blank

hard

Fill all three blanks to create a function that returns the cube of a number.

MySQL

CREATE FUNCTION getCube(num INT) RETURNS INT [1] DECLARE result INT; SET result = num [2] num [3] num; RETURN result; END

Drag options to blanks, or click blank then click option'

ABEGIN

B*

DAS

Attempts:

3 left

💡 Hint

Common Mistakes

Using AS instead of BEGIN to start the function.

Using + or other operators instead of * for multiplication.

Start the function body with BEGIN and multiply num three times using *.