Question 1

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

Accepted Answer

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

Question 2

Which of the following code fragments is correct?

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False  False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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.

Accepted Answer

A) True 
 B)False

Question 7

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;

Accepted Answer

A) True 
 B)False

Question 8

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;

Accepted Answer

A) True 
 B)False

Question 9

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?

Accepted Answer

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

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

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

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

The BEGIN section is the heart of the PL

Question 14

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?

Accepted Answer

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

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

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

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

Which of the following code fragments is correct?

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

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

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

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.

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;

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;

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(n) scalar variable can hold only a single value. _________________________

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

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

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

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?

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

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

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

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

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

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

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

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

Which of the following code fragments is correct?

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

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

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

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.

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;

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;

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(n) scalar variable can hold only a single value. _________________________

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

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

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

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?

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

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

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

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

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

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

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