Question No. 1

Which two are true about INDEX-BY tables? (Choose two.)

AThe index can be integer or string.

BThe index can be integer only.

CINDEX-BY table types can be created in PL/SQL blocks only.

DINDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.

EINDEX-BY table types can be created with the CREATE TYPE statement.

Show Answer

Correct Answer: A, C

Question No. 2

Which is true about EXIT and CONTINUE statements?

AThey can be used in any type of loop.

BThey must have a WHEN condition.

CThey have the same effect on the execution of a loop.

DThey must use labels.

Show Answer

Correct Answer: A

Question No. 3

Which three are true regarding code based access control (CBAC)? (Choose three.)

AIn a multitenant environment, the DELEGATE option of CBAC cannot be used.

BCBAC roles can be granted to a program unit only if they are directly granted to its owner.

CCBAC roles can be granted to a program unit only if they are the predefined roles automatically defined by the standard scripts as part of database creation.

DYou can use CBAC to attach database roles to a PL/SQL function or procedure only.

EIn CBAC, the ADMIN and DELEGATE options cannot both be granted to the same user.

FYou can use CBAC to attach database roles to a PL/SQL function, procedure, or package.

GCBAC cannot be used to secure definer's rights.

Show Answer

Correct Answer: B, E, F

Question No. 4

Examine this statement which executes successfully:

SQL> SET SERVEROUTPUT ON;

Now, examine this code which is executed:

What is true about the result?

AIt returns an error in line 2.

BIt returns an error in line 4.

CIt returns an error in line 9.

DIt executes and displays output.

Show Answer

Correct Answer: B

Question No. 5

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

Free Oracle 1Z0-149 Exam Actual Questions

The questions for 1Z0-149 were last updated On Dec 19, 2024