Question 1

The UPDATE statement is sometimes called a jumping control because it instructs the program to "jump to" some specific area of the code. _________________________

Accepted Answer

A) True 
 B)False

Question 2

Discuss the meaning of the term collection.

Accepted Answer

The answer of Discuss the meaning of the term collection....

Question 3

A variable declared with a record type can hold one row of data consisting of a number of column values.

Accepted Answer

A) True 
 B)False

Question 4

A(n) _________________ data type is quite similar to the structure of a row in a database table.

Accepted Answer

The answer of A(n) _________________ data type is quite similar...

Question 5

DECLARE TYPE type_basket IS RECORD(
Basket bb_basket.idBasket%TYPE,
Created bb_basket.dtcreated%TYPE,
Total bb_basket.cost%TYPE,
Qty bb_basket.quantity%TYPE,
Sub bb_basket.subtotal%TYPE);
Rec_basket type_basket;
BEGIN
--- executable code ---
END;
According to the code fragment above, which variable is declared using the type_basket data type?

Accepted Answer

A)  basket 
B)  rec_basket 
C)  sub 
D)  qty

Question 6

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

Accepted Answer

A)  composite data type 
B)  collection 
C)  record 
D)  assignment statement

Question 7

A(n) ____ is a variable that can handle many rows of data but only one field.

Accepted Answer

A)  assignment statement 
B)  associative array 
C)  collection 
D)  table attribute

Question 8

Which of the following code fragments correctly creates a record data type that will hold four variables?

Accepted Answer

A)  DECLARE
TYPE type_basket IS RECORD (
Basket bb_basket.idBasket %TYPE,
Created bb_basket.dtcreated%TYPE,
Sub bb_basket.subtotal %TYP
E) ;
Rec_basket type_basket;
BEGIN
--- executable code ---
END; 
B)  DECLARE
TYPE type_basket IS RECORD (
Basket bb_basket.idBasket%TYPE,
Created bb_basket.dtcreated%TYPE,
Qty bb_basket.quantity%TYPE,
Sub bb_basket.subtotal%TYPE;
Rec_basket type_basket;
BEGIN
--- executable code ---
END; 
C)  DECLARE
TYPE type_basket IS RECORD (
Bb_basket.dtcreated%TYPE
Qty bb_basket.quantity%TYPE,
Sub bb_basket.subtotal%TYP
E) ;
Rec_basket type_basket;
BEGIN
--- executable code ---
END; 
D)  DECLARE
TYPE type_basket IS RECORD (
Basket bb_basket.idBasket%TYPE,
Created bb_basket.dtcreated%TYPE,
Qty bb_basket.quantity%TYPE,
Sub bb_basket.subtotal%TYPE );
Rec_basket type_basket;
BEGIN
--- executable code ---
END;

Question 9

A scalar variable can hold multiple values whereas a composite variable can hold only a single value.

Accepted Answer

A) True 
 B)False

Question 10

One major advantage of using collections as part of the physical database is being able to retrieve multiple values with a query of a single column.

Accepted Answer

A) True 
 B)False

Question 11

The ____ markers are used in PL/SQL to identify a label.

Accepted Answer

A)   
B)  "" 
C)  > 
D)  :=

Exam 3: Handling Data In PL/SQL Blocks

The UPDATE statement is sometimes called a jumping control because it instructs the program to "jump to" some specific area of the code. _________________________

Discuss the meaning of the term collection.

A variable declared with a record type can hold one row of data consisting of a number of column values.

A(n) _________________ data type is quite similar to the structure of a row in a database table.

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

A(n) ____ is a variable that can handle many rows of data but only one field.

Which of the following code fragments correctly creates a record data type that will hold four variables?

A scalar variable can hold multiple values whereas a composite variable can hold only a single value.

One major advantage of using collections as part of the physical database is being able to retrieve multiple values with a query of a single column.

The ____ markers are used in PL/SQL to identify a label.