Question No. 1

Which two are true about collections and RECORD types? (Choose two.)

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

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

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

DCollections and RECORD types are always dense.

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

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

Show Answer

Correct Answer: B, F

Question No. 2

Which two statements are true about the RETURNING clause when used with DML? (Choose two.)

AWhen using the RETURNING INTO clause, the data returned can be only single column or expression.

BThe RETURNING INTO clause and bulk binds may not be used together.

CThe RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.

DThe RETURNING INTO clause returns column values for rows affected by DML statements.

EThe RETURNING clause can be used for remote or parallel deletes.

Show Answer

Correct Answer: C, E

Question No. 3

Examine the SH.PRODUCTS table:

A row exists in SH.PRODUCTS with PDT_ID = 1.

Now, examine this code and output executed by SH:

Now, examine this block of code:

Which error message(s) does it display on execution by user SH?

AError in inner block

BError in inner block Error in outer block

CError in inner block Error in calling block

DError in inner block Error in outer block Error in calling block

Show Answer

Correct Answer: A

Question No. 4

Which three PL/SQL-only data types can be used in queries and native dynamic SQL issued from PL/SQL in the server? (Choose three.)

Aa record declared in an anonymous block

Ba record declared in a procedure

Can associative array indexed by PLS_INTEGER

Da record declared in a package specification

Ea predefined PL/SQL-only data type like BOOLEAN

Fan associative array indexed by VARCHAR2

Show Answer

Correct Answer: C, D, F

Question No. 5

Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)

AImplicit cursor returns only one record.

BExplicit cursor can return more than one record.

C%Isopen, %Rowtype, %Notfound, and %Found are the attributes of Explicit Cursor.

D%Isopen, %Rowcount, %Notfound, and %Found are the attributes of Explicit Cursor.

E%Isopen, %Type, %Notfound, and %Found are the attributes of Explicit Cursor.

F%Isopen is always false in Explicit Cursor.

G%Isopen is always false in Implicit Cursor.

Show Answer

Correct Answer: B, C, G

Free Oracle 1Z0-149 Exam Actual Questions

The questions for 1Z0-149 were last updated On Nov 17, 2024