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.

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?

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.