Deck 2: Basic PL/SQL Block Structures

Question 1

With respect to processing efficiency, the less code that has to be processed, the faster the program runs.

Answer 1

True

Question 2

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

Answer 2

False

Question 3

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;

Answer 3

False

Question 4

Even though the EXIT clause can be used in any type of loop, it is considered good form to use the EXIT clause only in basic loops.

Question 5

When an IF statement checks only one condition and performs actions only if the condition is True, it is referred to as a simple IF condition.

Question 6

The keyword DEFAULT can be used in place of the := symbol to assign initial values to the variables within the declaration statement.

Question 7

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

Question 8

The CASE statement begins with the keyword CASE followed by a selector that is typically a variable name.

Question 9

The BEGIN section of a PL/SQL block contains code that creates variables, cursors, and types. _________________________

Question 10

The syntax of the following code fragment is correct:
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

Question 11

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;

Question 12

The term anonymous blocks refers to blocks of code that are not stored for reuse and do not exist after being executed.

Question 13

An infinite loop causes a program to loop indefinitely, disrupting the ability of the code to continue with any processing beyond the loop.

Question 14

The EXIT WHEN clause ensures that a basic loop runs at least once.

Question 15

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

Question 16

Assignment statements are used to put or change the values of variables.

Question 17

The following code fragment is a correct example of the use of a FOR loop.
BEGIN
FOR i IN 1..5
DBMS_OUTPUT.PUT_LINE( i );
END LOOP;
END;

Question 18

The following loop terminates when the lv_cnt_num variable holds a value of 6.
BEGIN
WHILE lv_cnt_num <= 5 LOOP
DBMS_OUTPUT.PUT_LINE( lv_cnt_num );
lv_cnt_num := lv_cnt_num + 1;
END LOOP;
END;

Question 19

The following loop iterates four times.
BEGIN
WHILE lv_cnt_num <= 5 LOOP
DBMS_OUTPUT.PUT_LINE( lv_cnt_num );
lv_cnt_num := lv_cnt_num + 1;
END LOOP;
END;

Question 20

The syntax of the following code fragment is correct.
IF rec_order.state = 'VA' THEN
lv_tax_num := rec_order.sub * .06;
ELS IF rec_order.state = 'ME' THEN
lv_tax_num := rec_order.sub * .05;
END IF

Question 21

If the WHERE clause is not included the basic loop, the result is the programmer's nightmare of the infinite loop. _________________________

Question 22

Variables are named memory areas that hold values to allow retrieval and manipulation of values within your programs. _________________________

Question 23

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

A) BEGIN & DECLARE
B) DECLARE & EXCEPTION
C) BEGIN & END
D) EXCEPTION & END

Question 24

The EXCEPTION section of a PL/SQL block contains handlers that allow you to control what the application will do if an error occurs. _________________________

Question 25

Which of the following lines of code is syntactically correct?

A) DECLARE
Order NUMBER;
Departure DATE;
BEGIN
---- executable statements ---
END
B) DECLARE
Order NUMBER;
Departure DATE
BEGIN
---- executable statements ---
END
C) DECLARE
Order NUMBER(2);
Departure DATE;
BEGIN;
---- executable statements ---
END
D) DECLARE
Order NUMBER(3);
Departure DATE;
BEGIN
---- executable statements ---
END;

Question 26

When an IF statement checks only one condition and performs actions only if the condition is True, it is referred to as a(n) simple IF condition. _________________________

Question 27

A(n) CASE expression evaluates conditions and returns a value in an assignment statement. _________________________

Question 28

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.

A) EXCEPTION
B) BEGIN
C) DECLARE
D) END

Question 29

____ are named memory areas that hold values to allow the retrieval and manipulation of values in a program.

A) Loops
B) Assignment statements
C) Blocks
D) Variables

Question 30

The Searched CASE statement does not use a selector but individually evaluates conditions that are placed in the WHERE clauses. _________________________

Question 31

The DECLARE section of the PL/SQL block contains all the processing action, or programming logic. _________________________

Question 32

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

Question 33

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

Question 34

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

A) DECLARE
B) BEGIN
C) EXCEPTION
D) END

Question 35

Which of the following initializes the variable order?

A) DECLARE
Order NUMBER(2);
Departure DATE;
BEGIN
---- executable statements ---
END;
B) DECLARE
Order NUMBER(2) = 0;
Departure DATE;
BEGIN
---- executable statements ---
END;
C) DECLARE
Order NUMBER(2) =: 0;
Departure DATE;
BEGIN
---- executable statements ---
END;
D) DECLARE
Order NUMBER(2) := 0;
Departure DATE;
BEGIN
---- executable statements ---
END;

Question 36

The basic loop uses the LOOP and END LOOP markers to begin and end the loop code. _________________________

Question 37

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

Question 38

The common data types used for cursor variables include character, numeric, date, and Boolean. _________________________

Question 39

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

Question 40

____ are used to change the values of variables.

A) Loops
B) Assignment statements
C) Exceptions
D) Blocks

Question 41

Which of the following PL/SQL blocks requires the variable to always contain a particular value within the block?

A) DECLARE
Order NUMBER(2) := 0;
Departure DATE;
BEGIN
---- executable statements ---
END;
B) DECLARE
Order NUMBER(2,2) := .06;
Departure DATE;
BEGIN
---- executable statements ---
END;
C) DECLARE
Order CONSTANT NUMBER(2,2) := .02;
Departure DATE;
BEGIN
---- executable statements ---
END;
D) DECLARE
Order NUMBER(2) CONSTANT := .03;
Departure DATE;
BEGIN
---- executable statements ---
END;

Question 42

BEGIN WHILE lv_cnt_num <= 5 LOOP
DBMS_OUTPUT.PUT_LINE(lv_cnt_num);
Lv_cnt_num := lv_cnt_num + 1;
END LOOP;
END;
According to the code fragment above, how many times does the loop iterate?

A) 3
B) 4
C) 5
D) 6

Question 43

Which of the following statements is correct?

A) IF order > 5
Prize = 'yes';
END IF;
B) IF order > 5 THEN
Prize = 'yes';
ENDIF
C) IF order > 5 THEN;
Prize = 'yes';
END IF;
D) IF order > 5 THEN
Prize := 'yes';
END IF;

Question 44

FOR i IN 1..tbl_roast.COUNT LOOP lv_tot_num := lv_tot_num + tbl_roast(i);
END LOOP;
In the above code fragment, which of the following holds the value of the current iteration number?

A) tbl_roast
B) i
C) COUNT
D) lv_tot_num

Question 45

The ____ uses the LOOP and END LOOP markers to begin and end the loop code.

A) basic loop
B) cursor
C) index-by table
D) general loop

Question 46

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

A) DECLARE
Order NUMBER(2) := 4;
Total_amt NUMBER(2);
BEGIN
Total_amt = 12;
END;
B) DECLARE
Order NUMBER(2) := 4;
Total_amt NUMBER(2);
BEGIN
Total_amt := 12 * order;
END;
C) DECLARE
Order NUMBER(2) := 4;
Total_amt NUMBER(2);
BEGIN
Order := total_amt *12;
END;
D) DECLARE
Order NUMBER(2) := 4;
Total_amt NUMBER(2);
BEGIN
Total_amt := total_amt *12;
END;

Question 47

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

A) CASE
B) WHILE loop
C) FOR loop
D) Basic loop

Question 48

DECLARE order NUMBER(2) := 4;
Total_amt NUMBER(2);
BEGIN
Total_amt := order * 8;
END;
According to the statement block above, what value is stored in the variable total_amt?

A) 4
B) 8
C) 12
D) 32

Question 49

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

A) Control statements
B) Searched CASE
C) Loops
D) CASE expression

Question 50

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

A) exceptions
B) control structures
C) pragma statements
D) index-by tables

Question 51

Which of the following statements is True?

A) The WHEN clause of a CASE statement ends with a semicolon.
B) The WHEN clause of a CASE statement ends with "END CASE;".
C) The WHEN clause of a CASE expression does not end with a semicolon.
D) The WHEN clause of a CASE statement ends with "ENDCASE".

Question 52

Which of the following evaluates conditions and returns a value in an assignment statement?

A) Searched CASE
B) Basic loop
C) CASE expression
D) Control statement

Question 53

BEGIN LOOP
DBMS_OUTPUT.PUT_LINE(lv_cnt_num);
Lv_cnt_num := lv_cnt_num + 1;
EXIT WHEN lv_cnt_num >= 5;
END LOOP;
END;
Which of the statements in the code fragment above ensures that the loop executes at least once?

A) LOOP
B) lv_cnt_num := lv_cnt_num + 1;
C) EXIT WHEN lv_cnt_num >= 5;
D) DBMS_OUTPUT.PUT_LINE(lv_cnt_num);

Question 54

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

A) BEGIN
WHILE lv_cnt_num <= 5
DBMS_OUTPUT.PUT_LINE(lv_cnt_num);
Lv_cnt_num := lv_cnt_num + 1;
END LOOP;
END;
B) BEGIN
WHILE lv_cnt_num <= 5
DBMS_OUTPUT.PUT_LINE(lv_cnt_num);
Lv_cnt_num := lv_cnt_num + 1;
END;
C) BEGIN
WHILE lv_cnt_num <= 5 LOOP
DBMS_OUTPUT.PUT_LINE(lv_cnt_num);
Lv_cnt_num := lv_cnt_num + 1;
END LOOP;
D) BEGIN
WHILE lv_cnt_num <= 5 LOOP
DBMS_OUTPUT.PUT_LINE(lv_cnt_num);
Lv_cnt_num := lv_cnt_num + 1;
END LOOP;
END;

Question 55

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

A) IF rec.state = 'VA' OR 'PA' THEN
A := b * .06;
ELSE
A := b * .04;
END IF;
B) IF rec.state = 'VA' OR rec.state = 'PA' THEN
A := b * .06;
ELSE
A := b * .04;
END IF;
C) IF rec.state = 'VA' OR rec.state = 'PA'
A := b * .06;
ELSE
A := b * .04;
END IF;
D) IF rec.state = 'VA' OR rec.state = 'PA' THEN
A := b * .06;
ELSE
A := b * .04;
END IF

Question 56

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

A) BEGIN
LOOP
DBMS_OUTPUT.PUT_LINE( lv_cnt_num );
Lv_cnt_num := lv_cnt_num + 1;
END LOOP;
END;
B) BEGIN
LOOP
DBMS_OUTPUT.PUT_LINE( lv_cnt_num );
EXIT WHEN lv_cnt_num >= 5;
Lv_cnt_num := lv_cnt_num + 1;
END;
C) BEGIN
LOOP
DBMS_OUTPUT.PUT_LINE( lv_cnt_num );
EXIT WHEN lv_cnt_num >= 5;
Lv_cnt_num := lv_cnt_num + 1
END LOOP
END
D) BEGIN
LOOP
DBMS_OUTPUT.PUT_LINE( lv_cnt_num );
EXIT WHEN lv_cnt_num >= 5;
Lv_cnt_num := lv_cnt_num + 1;
END LOOP;
END;

Question 57

Which of the following allow us to repeat the processing of a desired portion of code?

A) Functions
B) Looping constructs
C) IF statements
D) CASE expressions

Question 58

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

A) 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;
B) IF rec_order.state = 'VA' THEN
Lv_tax_num := rec_order.sub * .06;
ELSE IF rec_order.state = 'ME' THEN
Lv_tax_num := rec_order.sub * .05;
ELSE
Lv_tax_num := rec_order.sub * .04;
END IF;
C) 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;
D) IF rec_order.state = 'VA' THEN
Lv_tax_num := rec_order.sub * .06;
ELS IF rec_order.state = 'ME' THEN
Lv_tax_num := rec_order.sub * .05;
ELSE
Lv_tax_num := rec_order.sub * .04;
END IF;

Question 59

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

A) infinite loop
B) exception
C) RAISE_APPLICATION_ERROR
D) SQLCODE error

Question 60

Which of the following clauses ensures that a basic loop runs at least once?

A) EXIT WHEN
B) WHERE
C) CASE
D) LOOP

Question 61

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

Question 62

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

A) BEGIN
FOR i IN 1..10 LOOP
DBMS_OUTPUT.PUT_LINE(i);
END LOOP;
END;
B) BEGIN
FOR i IN 1..10 LOOP
DBMS_OUTPUT.PUT_LINE(c)
END LOOP
END;
C) BEGIN
FOR i IN 1..10
DBMS_OUTPUT.PUT_LINE(i);
END LOOP;
END;
D) BEGIN
FOR i IN 1..10 LOOP
DBMS_OUTPUT.PUT_LINE
END LOOP
END;

Question 63

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

Question 64

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

Question 65

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

Question 66

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?

A) ELSE
B) IF
C) END IF
D) THEN

Question 67

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.

Question 68

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

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

Which of the following code fragments is correct?

A) FOR i IN 1..tbl.COUNT
Lv_tot_num := lv_tot_num + tbl_roast(i);
END LOOP;
B) FOR i IN 1..tbl.COUNT LOOP
Lv_tot_num := lv_tot_num + tbl_roast(i)
END LOOP
C) FOR i IN 1..tbl.COUNT LOOP
Lv_tot_num = lv_tot_num + tbl_roast(i);
END LOOP;
D) FOR i IN 1..tbl.COUNT LOOP
Lv_tot_num := lv_tot_num + tbl_roast(i);
END LOOP;

Question 77

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

A) The counter variable
B) The IN clause
C) The INSERT INTO clause
D) The FOR clause

Question 78

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

Question 79

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;

A) Semicolon after THEN is omitted
B) No space between ELSE and IF
C) ELSEIF is not a keyword
D) ":=" should be "="

Question 80

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