PLSQL Chapter 2 Quiz

Welcome to your PLSQL Chapter 2 Quiz

What keyword is used to start the section where variables are created?

START

BEGIN

DECLARE

VARIABLE

What do you need to include when declaring a variable?

The name of the variable and the data type are required.

The name, data type, and the value are all required.

The name of the variable is required.

The name, data type, the value, and the word CONSTANT are all required.

What is a constant?

An area in memory that stores a value for your program and can be changed in your program.

A variable in your program that cannot be changed once it is set.

A function that displays data to the screen.

A way to join two values together into one.

What's wrong with this code?

DECLARE
  l_radius NUMBER(8);
BEGIN
  DBMS_OUTPUT.PUT_LINE('The diameter is ' || 2 * l_radius);
END;

Nothing. It will run and display the value of 16, because l_radius is set to 8 and the function multiplies it by 2.

The code will run, but it won't display a number because the value of l_radius is not set.

The code will run and display a value of 2.

The code will not run because you can't concatenate a text value with a number value.

Time is Up!

Time's up

Post navigation