Question 1

____________________ 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 2

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

Accepted Answer

A) True 
 B)False

Question 3

What is the purpose of control structures?

Accepted Answer

Control structures provide the

Question 4

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;

Accepted Answer

A) True 
 B)False

Question 5

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?

Accepted Answer

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

Question 6

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

Accepted Answer

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

Question 7

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

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

Question 8

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

Accepted Answer

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

Question 9

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 10

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. _________________________

Accepted Answer

A) True 
 B)False

Question 11

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.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

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; 
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 15

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

Accepted Answer

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

Question 16

Which of the following initializes the variable order?

Accepted Answer

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; 
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 17

Which of the following lines of code is syntactically correct?

Accepted Answer

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; 
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 18

____ are used to change the values of variables.

Accepted Answer

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

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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...

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

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

What is the purpose of control structures?

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;

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?

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

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;

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

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

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. _________________________

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.

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

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

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

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

Which of the following initializes the variable order?

Which of the following lines of code is syntactically correct?

____ are used to change the values of variables.

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

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.

Introduction To PL/SQL

Handling Data In PL/SQL Blocks

Cursors and Exception Handling

Procedures

Functions

PL/SQL Packages

Program Unit Dependencies

Database Triggers

Oracle-Supplied Packages, Dynamic SQL, and Hiding Source Code

Filters

Exam 2: Basic PL/SQL Block Structures

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

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

What is the purpose of control structures?

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;

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?

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

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;

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

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

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. _________________________

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.

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

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

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

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

Which of the following initializes the variable order?

Which of the following lines of code is syntactically correct?

____ are used to change the values of variables.

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

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.

Introduction To PL/SQL

Handling Data In PL/SQL Blocks

Cursors and Exception Handling

Procedures

Functions

PL/SQL Packages

Program Unit Dependencies

Database Triggers

Oracle-Supplied Packages, Dynamic SQL, and Hiding Source Code

Filters