Lesson 7: Manipulating Data with Functions

Question 1

What is a function?

Answer 1

A function is a defined routine that returns a value.

Question 2

What is the syntax for a function?

Answer 2

function (argument1, argument2, …);

• function name
• arguments in parentheses
• arguments are separated by COMMAS.
• ends with semicolon

Question 3

What is a CALL routine?

Answer 3

CALL routine
- performs computation or system manipulation

BUT
- it does NOT return a value;
- it ALTERS column values

Question 4

Which function works for random values

Answer 4

RAND (‘distribution’, parameter1, parameter k)

Question 5

What function is used to be used to identity the top three (quiz scores)/

Answer 5

LARGEST (k, value-1 <, value-2…>)