Module 06: Working with Composite Data Types

Working with Composite Data Types

01. In the executable section of a PL/SQL block, you include this statement:
inventory. inventory1 := 12;

Which task will this accomplish? 

a. A record will be assigned a value.

b. A constant will be assigned a value.

c. An index identifier will be assigned a value.

d. A composite variable will be assigned a variable.

Answer: a

02. In the executable section of a PL/SQL block, you include this statement:

inventory (55) := ‘Walt’

which task will this accomplish?

a. A constant will be assigned a value.

b. A scalar variable will be assigned a value.

c. A PL/SQL table element will be assigned a number value.

d. A PL/SQL table element will be assigned a character string value.

Answer: c

03. Which data type is the primary key used to index a PL/SQL table?

a. RAW.

b. LONG.

c. CHAR.

d. NUMBER.

e. VARCHAR2.

f. BINARY_INTEGER.

Answer: f

04. Which one of the following in NOT a PL/SQL table attribute?

a. PRIOR.

b. DELETE.

c. LAST.

d. UPDATE.

e. FIRST.

Answer: d

05. Which line in the following statement will produce an error?

a. CURSOR action_cursor is.

b. SELECT name, rate action..

c. INTO action_record.

d. FROM acrion table.

e. There are no errors in the statement.

Answer: c

06. The command used to open a cursor for loop is

a. OPEN.

b. FETCH.

c. PARSE.

d. None, cursor for loops handle cursor opening implicitly.

Answer: d