Exam 2: Basic PL/SQL Block Structures

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?

The basic loop dictates exactly how many times the loop should run in the opening LOOP clause. ____________________

To keep code efficient and minimize statement processing, any statements that are dynamic in nature should be placed outside a loop. _________________________

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

If the EXIT WHEN clause is not included in a basic loop, then the result is a(n) ____.

The only required sections of a PL/SQL block are DECLARE and END.

Which of the following statements is True?

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

The ____ section of a PL/SQL block contains handlers that allow you to control what the application will do if an error occurs when the executable statements are processed.

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

Which of the following statement blocks correctly uses a scalar variable in an assignment statement?

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

Which of the following dictates exactly how many times the loop should run in the opening LOOP clause?

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

The following code fragment is a correct example of the use of a basic loop. BEGIN LOOP DBMS_OUTPUT.PUT_LINE( lv_cnt_num ); lv_cnt_num := lv_cnt_num + 1; END LOOP; END;

The only required sections of a PL/SQL block are the ____ sections.

Which of the following does not use a selector, but individually evaluates conditions that are placed in WHEN clauses?

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

The statements that are used to control the flow of logic processing in your programs are commonly referred to as ____.

The following code fragment is a correct example of the use of a WHILE loop. BEGIN WHILE lv_cnt_num <= 5 DBMS_OUTPUT.PUT_LINE( lv_cnt_num ); lv_cnt_num := lv_cnt_num + 1; END LOOP; END;