Question 1

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

Accepted Answer

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

Which of the following statements is correct?

Accepted Answer

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 9

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?

Accepted Answer

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 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

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

Exam 2: Basic PL/SQL Block Structures

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

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

Which of the following statements is correct?

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

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

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

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

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

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?

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

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

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

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

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

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

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

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

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

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

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