Question 1

The ____________________ section of the PL/SQL block contains code that creates variables, cursors, and types.

Accepted Answer

The answer of The ____________________ section of the PL/SQL block...

Question 2

Which of the following code fragments would not raise an error?

Accepted Answer

A is the only code fragment that has a complete and correct syntax for a loop in PL/SQL. It initializes the loop with "FOR i IN 1..10 LOOP", prints the value of the loop counter with "DBMS_OUTPUT.PUT_LINE(i)", and ends the loop with "END LOOP;" and "END;".

B has a missing semicolon after "DBMS_OUTPUT.PUT_LINE(c)" and also does not define the variable "c".
C is missing the "LOOP" keyword after "FOR i IN 1..10".
D is missing the argument for "DBMS_OUTPUT.PUT_LINE".

Question 3

The code order NUMBER(2) := 6; is an example of a(n) ____________________.

Accepted Answer

The answer of The code order NUMBER(2) := 6; is...

Question 4

____________________ are used for situations in which we need to repeat a line or lines of code within our block.

Accepted Answer

The answer of ____________________ are used for situations in which...

Question 5

_____________________ statements are used to put or change values in variables.

Accepted Answer

The answer of _____________________ statements are used to put or...

Question 6

IF rec_order.state = 'VA' THEN lv_tax_num := rec_order.sub * .06;
ELSIF rec_order.state = 'ME' THEN
Lv_tax_num := rec_order.sub * .05;
ELSE
Lv_tax_num := rec_order.sub * .04;
END IF;
Which of the clauses in the code fragment above would not cause the IF statement to raise an error if it were excluded?

Accepted Answer

The ELSE clause is optional in an IF statement. Removing it would not cause an error; the IF or ELSIF conditions would still be checked, and if none match, the code would simply skip the tax calculation.

Question 7

The ____________________ section of a PL/SQL block contains handlers that allow you to control what the application will do if an error occurs during the executable statements in the BEGIN section.

Accepted Answer

The answer of The ____________________ section of a PL/SQL block...

Question 8

A(n) ____________________ variable can hold only a single value.

Accepted Answer

The answer of A(n) ____________________ variable can hold only a...

Question 9

By indicating a numeric range, the ____________________ dictates exactly how many times the loop should run in the opening LOOP clause.

Accepted Answer

OR loop

Question 10

What is the purpose of the BEGIN section of a PL/SQL block?

Accepted Answer

The answer of What is the purpose of the BEGIN...

Question 11

The simple IF statement performs an action only if the condition is ____________________.

Accepted Answer

The simple IF statement is executed only if the condition is true.

Question 12

The ____________________ loop is constructed with conditions in the LOOP statement to determine when the looping action begins and ends.

Accepted Answer

The answer of The ____________________ loop is constructed with conditions...

Question 13

A(n) ____________________ statement does not use a selector but individually evaluates conditions that are placed in the WHEN clauses.

Accepted Answer

The answer of A(n) ____________________ statement does not use a...

Question 14

If the EXIT WHEN clause is not included in the basic loop, the result is the programmer's nightmare of a(n) ____________________.

Accepted Answer

The answer of If the EXIT WHEN clause is not...

Question 15

To declare a variable, you must supply a variable name and ____________________.

Accepted Answer

The answer of To declare a variable, you must supply...

Question 16

Which of the following code fragments is correct?

Accepted Answer

Option D is the correct choice. It has the correct syntax for a FOR loop in PL/SQL. It declares a loop index variable i and specifies the range of values for it to iterate over (1 through tbl.COUNT). The loop body contains the statement Lv_tot_num := lv_tot_num + tbl_roast(i); that will be executed on each iteration of the loop. Additionally, it uses the correct syntax for variable assignment with the := operator.

Question 17

Which of the following can be referenced in the loop but cannot be assigned a value because it is controlled by the loop?

Accepted Answer

The counter variable is used to control the loop and keep track of the iteration number. It can be referenced within the loop to perform various operations, but cannot be assigned a value because it is controlled by the loop. The IN clause specifies the range or collection of values to loop through, the INSERT INTO clause is used to insert data into a table, and the FOR clause is another way to create a loop in some programming languages.

Question 18

The ____________________ statement is a mechanism that allows the checking of a condition to determine whether or not statements should be processed.

Accepted Answer

The answer of The ____________________ statement is a mechanism that...

Question 19

Why would the following code raise an error? IF rec_order.state = 'VA' THEN
Lv_tax_num := rec_order.sub * .06;
ELSEIF rec_order.state = 'ME' THEN
Lv_tax_num := rec_order.sub * .05;
ELSE
Lv_tax_num := rec_order.sub * .04;
END IF;

Accepted Answer

In some programming languages (such as SQL), ELSEIF is a valid keyword for handling conditional statements. However, in most programming languages (including popular ones like Java and Python), the correct syntax is either ELSE IF or ELSIF (without the second "E"). Therefore, the code as written would raise a syntax error due to the incorrect keyword.

Question 20

The ____________________ option can be added to the variable declaration to require the variable to always contain a particular value within the block.

Accepted Answer

The answer of The ____________________ option can be added to...

Quiz 2: Basic PL/SQL Block Structures