Question 1

The syntax of the following code fragment is correct.
BEGIN
If lv_rows_num = 0
GOTO insert_row;
End If;

Accepted Answer

A) True 
 B)False

Question 2

Which of the following is sometimes called a jumping control because it instructs programs to "jump to" some specific area of the code?

Accepted Answer

A)  GO TO statement 
B)  GOTO statement 
C)  GO_TO statement 
D)  JUMP statement 
A)  GO TO statement 
B)  GOTO statement 
C)  GO_TO statement 
D)  JUMP statement

Question 3

PL/SQL blocks use assignment variables to assign values to variables. _________________________

Accepted Answer

A) True 
 B)False

Question 4

The INTO clause follows the SELECT clause and indicates which variables are to hold the values that are retrieved from the database.

Accepted Answer

A) True 
 B)False

Question 5

____ are functions that can be used in conjunction with table variables and allow greater ability to manipulate table values.

Accepted Answer

A)  Associative array 
B)  Assignment statements 
C)  Collections 
D)  Table attributes 
A)  Associative array 
B)  Assignment statements 
C)  Collections 
D)  Table attributes

Question 6

What do most developers say about using a GOTO statement? Why?

Accepted Answer

Even though the GOTO statement exists, m

Question 7

A(n) ____________________ is an ordered group of elements that allows the handling of multiple values of the same data type as a single unit.

Accepted Answer

The answer of A(n) ____________________ is an ordered group of...

Question 8

A(n) ____ of data typically includes a number of different fields.

Accepted Answer

A)  row 
B)  collection 
C)  assignment statement 
D)  variable 
A)  row 
B)  collection 
C)  assignment statement 
D)  variable

Question 9

Declaring a table of records variable in a package specification allows it to persist for a user session.

Accepted Answer

A) True 
 B)False

Question 10

A(n) ____________________ statement could be used to create a record data type.

Accepted Answer

The answer of A(n) ____________________ statement could be used to...

Question 11

What is an associative array?

Accepted Answer

An associative arrray is commonly referr

Question 12

Which of the following code fragments tells the system to look up the data type of a database column and use it for the declared variable?

Accepted Answer

A)  DECLARE
Order NUMBER(2) := 4;
Total_amt NUMBER(2);
BEGIN
--- executable code ---
END; 
B)  DECLARE
Order.quantity%TYPE;
Total_amt NUMBER(2);
BEGIN
--- executable code ---
END; 
C)  DECLARE
Order.quantity#TYPE;
Total_amt NUMBER(2);
BEGIN
--- executable code ---
END; 
D)  DECLARE
Order CONSTANT NUMBER(2) := 4;
Total_amt NUMBER(2);
BEGIN
--- executable code ---
END; 
A)  DECLARE
Order NUMBER(2) := 4;
Total_amt NUMBER(2);
BEGIN
--- executable code ---
END; 
B)  DECLARE
Order.quantity%TYPE;
Total_amt NUMBER(2);
BEGIN
--- executable code ---
END; 
C)  DECLARE
Order.quantity#TYPE;
Total_amt NUMBER(2);
BEGIN
--- executable code ---
END; 
D)  DECLARE
Order CONSTANT NUMBER(2) := 4;
Total_amt NUMBER(2);
BEGIN
--- executable code ---
END;

Question 13

Which of the following attributes is available to enable movement through the associative array data?

Accepted Answer

A)  COUNT 
B)  DELETE 
C)  PRIOR 
D)  EXISTS 
A)  COUNT 
B)  DELETE 
C)  PRIOR 
D)  EXISTS

Question 14

A(n)index table is an ordered group of elements that allows the handling of multiple values of the same data type as a single unit. _________________________

Accepted Answer

A) True 
 B)False

Question 15

Which of the following statements is incorrect?

Accepted Answer

A)  The GOTO action interrupts the flow of execution, making it very difficult to understand and maintain the code. 
B)  Even though the GOTO statement exists, most developers believe this should be used very sparingly. 
C)  Most developers believe that the GOTO statement should be used as many times as possible. 
D)  Even though the GOTO statement exists, most developers believe this should be used only if no other method can be used to accomplish the task at hand. 
A)  The GOTO action interrupts the flow of execution, making it very difficult to understand and maintain the code. 
B)  Even though the GOTO statement exists, most developers believe this should be used very sparingly. 
C)  Most developers believe that the GOTO statement should be used as many times as possible. 
D)  Even though the GOTO statement exists, most developers believe this should be used only if no other method can be used to accomplish the task at hand.

Question 16

The associative array attribute EXISTS returns the total number of values in the table. _________________________

Accepted Answer

A) True 
 B)False

Question 17

A(n) ____ can store and handle multiple values of different data types as one unit.

Accepted Answer

A)  composite data type 
B)  collection 
C)  record 
D)  block 
A)  composite data type 
B)  collection 
C)  record 
D)  block

Question 18

A composite data type is a variable that can store and handle multiple values of the same data type as one unit.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following code fragments correctly uses a record variable to hold the row of data queried for a shopper?

Accepted Answer

A)  DECLARE
Rec_shopper bb_shopper%ROWTYPE;
BEGIN
SELECT*
INTO rec_shopper
FROM bb_shopper
WHERE idshopper = :g_shopper;
DBMS_OUTPUT.PUT_LINE(rec_shopper.lastname);
DBMS_OUTPUT.PUT_LINE(rec_shopper.address);
DBMS_OUTPUT.PUT_LINE(rec_shopper.email);
END; 
B)  DECLARE
Rec_shopper bb_shopper%ROW;
BEGIN
SELECT*
INTO rec_shopper
FROM bb_shopper
WHERE idshopper = :g_shopper;
DBMS_OUTPUT.PUT_LINE(rec_shopper.lastname);
DBMS_OUTPUT.PUT_LINE(rec_shopper.address);
DBMS_OUTPUT.PUT_LINE(rec_shopper.email);
END; 
C)  DECLARE
Rec_shopper bb_shopper%TYPE;
BEGIN
SELECT*
INTO rec_shopper
FROM bb_shopper
WHERE idshopper = :g_shopper;
DBMS_OUTPUT.PUT_LINE(rec_shopper.lastname);
DBMS_OUTPUT.PUT_LINE(rec_shopper.address);
DBMS_OUTPUT.PUT_LINE(rec_shopper.email);
END; 
D)  DECLARE
Rec_shopper bb_shopperROWTYPE;
BEGIN
SELECT*
INTO rec_shopper
FROM bb_shopper;
WHERE idshopper = :g_shopper;
END; 
A)  DECLARE
Rec_shopper bb_shopper%ROWTYPE;
BEGIN
SELECT*
INTO rec_shopper
FROM bb_shopper
WHERE idshopper = :g_shopper;
DBMS_OUTPUT.PUT_LINE(rec_shopper.lastname);
DBMS_OUTPUT.PUT_LINE(rec_shopper.address);
DBMS_OUTPUT.PUT_LINE(rec_shopper.email);
END; 
B)  DECLARE
Rec_shopper bb_shopper%ROW;
BEGIN
SELECT*
INTO rec_shopper
FROM bb_shopper
WHERE idshopper = :g_shopper;
DBMS_OUTPUT.PUT_LINE(rec_shopper.lastname);
DBMS_OUTPUT.PUT_LINE(rec_shopper.address);
DBMS_OUTPUT.PUT_LINE(rec_shopper.email);
END; 
C)  DECLARE
Rec_shopper bb_shopper%TYPE;
BEGIN
SELECT*
INTO rec_shopper
FROM bb_shopper
WHERE idshopper = :g_shopper;
DBMS_OUTPUT.PUT_LINE(rec_shopper.lastname);
DBMS_OUTPUT.PUT_LINE(rec_shopper.address);
DBMS_OUTPUT.PUT_LINE(rec_shopper.email);
END; 
D)  DECLARE
Rec_shopper bb_shopperROWTYPE;
BEGIN
SELECT*
INTO rec_shopper
FROM bb_shopper;
WHERE idshopper = :g_shopper;
END;

Question 20

The GOTO statement interrupts the flow of execution of a program.

Accepted Answer

A) True 
 B)False

The syntax of the following code fragment is correct. BEGIN If lv_rows_num = 0 GOTO insert_row; End If;

Which of the following is sometimes called a jumping control because it instructs programs to "jump to" some specific area of the code?

PL/SQL blocks use assignment variables to assign values to variables. _________________________

The INTO clause follows the SELECT clause and indicates which variables are to hold the values that are retrieved from the database.

____ are functions that can be used in conjunction with table variables and allow greater ability to manipulate table values.

What do most developers say about using a GOTO statement? Why?

A(n) ____________________ is an ordered group of elements that allows the handling of multiple values of the same data type as a single unit.

A(n) ____ of data typically includes a number of different fields.

Declaring a table of records variable in a package specification allows it to persist for a user session.

A(n) ____________________ statement could be used to create a record data type.

What is an associative array?

Which of the following code fragments tells the system to look up the data type of a database column and use it for the declared variable?

Which of the following attributes is available to enable movement through the associative array data?

A(n)index table is an ordered group of elements that allows the handling of multiple values of the same data type as a single unit. _________________________

Which of the following statements is incorrect?

The associative array attribute EXISTS returns the total number of values in the table. _________________________

A(n) ____ can store and handle multiple values of different data types as one unit.

A composite data type is a variable that can store and handle multiple values of the same data type as one unit.

Which of the following code fragments correctly uses a record variable to hold the row of data queried for a shopper?

The GOTO statement interrupts the flow of execution of a program.

Introduction To PL/SQL

Basic PL/SQL Block Structures

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 3: Handling Data In PL/SQL Blocks

The syntax of the following code fragment is correct. BEGIN If lv_rows_num = 0 GOTO insert_row; End If;

Which of the following is sometimes called a jumping control because it instructs programs to "jump to" some specific area of the code?

PL/SQL blocks use assignment variables to assign values to variables. _________________________

The INTO clause follows the SELECT clause and indicates which variables are to hold the values that are retrieved from the database.

____ are functions that can be used in conjunction with table variables and allow greater ability to manipulate table values.

What do most developers say about using a GOTO statement? Why?

A(n) ____________________ is an ordered group of elements that allows the handling of multiple values of the same data type as a single unit.

A(n) ____ of data typically includes a number of different fields.

Declaring a table of records variable in a package specification allows it to persist for a user session.

A(n) ____________________ statement could be used to create a record data type.

What is an associative array?

Which of the following code fragments tells the system to look up the data type of a database column and use it for the declared variable?

Which of the following attributes is available to enable movement through the associative array data?

A(n)index table is an ordered group of elements that allows the handling of multiple values of the same data type as a single unit. _________________________

Which of the following statements is incorrect?

The associative array attribute EXISTS returns the total number of values in the table. _________________________

A(n) ____ can store and handle multiple values of different data types as one unit.

A composite data type is a variable that can store and handle multiple values of the same data type as one unit.

Which of the following code fragments correctly uses a record variable to hold the row of data queried for a shopper?

The GOTO statement interrupts the flow of execution of a program.

Introduction To PL/SQL

Basic PL/SQL Block Structures

Cursors and Exception Handling

Procedures

Functions

PL/SQL Packages

Program Unit Dependencies

Database Triggers

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

Filters