Unit 9 - Review Stored Procedures vs Custom Functions

How many stored procedures are in this code?

• 0

• 1

• 2

• 3

Answer explanation

The stored procedures are setup and draw.

Stored procedures NEVER need to be called.

How many stored procedures are in this code?

• 0

• 1

• 2

• 3

Answer explanation

The stored procedures are setup and mouseClicked.

Stored procedures NEVER need to be called.

How many custom functions are in this code?

• 0

• 1

• 2

• 3

Answer explanation

Custom function definition syntax is

var nameOfFunction () = {

};

*Remember

Custom functions NEED to be called.

Stored procedures NEVER need to be called.

How many custom functions are in this code?

• 0

• 1

• 2

• 3

Answer explanation

Custom function definition syntax is

var nameOfFunction () = {

};

*Remember

Custom functions NEED to be called.

Stored procedures NEVER need to be called.

Identify ALL the stored procedures

• setup

• draw

• drawSnow

• drawCloud

Answer explanation

*Remember

Custom functions NEED to be called.

Stored procedures NEVER need to be called.

Identify ALL the custom functions

• setup

• draw

• drawSnow

• drawCloud

Answer explanation

*Remember

Custom functions NEED to be called.

Stored procedures NEVER need to be called.

Identify ALL the custom functions

• setup

• mouseClicked

• calcSize

• drawCalculator

Answer explanation

*Remember

Custom functions NEED to be called.

Stored procedures NEVER need to be called.

Identify ALL the stored procedures

• setup

• mouseClicked

• calcSize

• drawCalculator

Answer explanation

*Remember

Custom functions NEED to be called.

Stored procedures NEVER need to be called.

True or False: drawCalculator takes parameters

• True

• False

Answer explanation

Parameters are values that are passed to the function.

True or False: drawSmile takes parameters

• True

• False

Answer explanation

drawSmile is expected one parameter - smileColor