1z0-149 Oracle Database 19c: Program with PL/SQL Questions and Answers

A variable of RECORD type can contain fields of another RECORD type or any collection type.

Only associative arrays and nested tables can have elements of RECORD type.

All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.

Collections and RECORD types are always dense.

All collections and RECORD types can be stored in table columns.

VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.

It will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.

It will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.

It will fail at lines 6 and 7.

It will fail only at line 7.

It must explicitly be declared.

It can be modified in the body of the loop.

It cannot be NULL.

It is accessible outside the body of the loop.

The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.

Only the PRICE column can be updated in the PRODUCTS table.

The FOR UPDATE OF clause can be used only if the WHERE CURRENT OF clause is used in the executable part of the block.

The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.

An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.

line 1

line 6

line 8

line 2

line 3

line 7