PLSQL Chapter 4 Quiz

Welcome to your PLSQL Chapter 4 Quiz

Which one of these statements is true about the differences between a procedure and a function?

They are both the same.

Functions must have a RETURN value, but procedures don't need one.

Procedures can only take IN parameters and not OUT parameters.

Procedures can be used in regular SQL, but functions cannot.

What does the OR REPLACE keyword do as part of the CREATE PROCEDURE or CREATE FUNCTION statement?

It replaces the existing object with the one you have defined in the statement if it already exists.

Nothing, this keyword is not valid.

Nothing, it's a valid keyword but does not apply to procedures or functions.

It determines if your code will insert new data into a table or update existing data.

What is an exception?

An error that happens when you create your procedure or function, such as a missing bracket.

The part of an IF statement that runs if no criteria are met.

An error that happens while your code is running.

A collection of data that is not inserted into a table.

How can you run the code in a procedure?

Run the "CALL procedure_name" statement.

It's run automatically when you create the procedure.

Run the "RUN procedure_name" statement.

You can't run procedures, you can only run functions.

Time's up

Post navigation