Module assessment

1.

You want to make it easier for a colleague to insert data into a table. What should you do?

Create a stored procedure.

Create a function.

Creating a stored procedure or a function doesn't address this requirement.

2.

You created a stored procedure that returns a country/region name. Which of the following options is the correct way to call the stored procedure?

Write a SELECT query and include the stored procedure's return value with an alias.

Use the keyword CALL to call the stored procedure.

Use the keywords CALL PROCEDURE.

3.

Your company uses Azure Database for PostgreSQL as the database for their expenses processing application. You need to write some code to calculate how much should be reimbursed to employees for mileage in their own car. The code returns a single decimal number. The result of the code is used in SELECT statements. What should you do?

Create a stored procedure.

Create a function.

Creating a stored procedure or a function doesn't address this requirement.

Check your knowledge

Feedback