Question No. 1

Which two PL/SQL elements can be deprecated using the DEPRECATE pragma? (Choose two.)

APACKAGES

BVARIABLES

CANONYMOUS BLOCK

DTRIGGER BODY

EDATABASE LINKS

Show Answer

Correct Answer: A, E

Question No. 2

Which three are true about functions and procedures? (Choose three.)

AThe ACCESSIBLE BY clause can be used only for procedures.

BIn a function, every execution path must lead to a RETURN statement.

CBoth can have only constants as actual parameters for IN mode parameters.

DBoth can be invoked from within SQL statements.

EIn a procedure the RETURN statement cannot specify an expression.

FIn a function every RETURN statement must specify an expression.

Show Answer

Correct Answer: B, E, F

Question No. 3

Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.)

APL/SQL code can be compiled and executed based on different versions of the operating system.

BPL/SQL code can be compiled and executed based on different versions of Oracle.

CIt is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.

DConditional compilation is disabled by default.

EThe PL/SQL compiler can conditionally include selected parts of a program.

Show Answer

Correct Answer: B, E

Question No. 4

Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.)

AThe PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.

BThe NOCOPY hint asks the compiler to pass the actual parameters by reference.

CA deterministic function's results always depend on the state of session variables.

DThe NOCOPY hint asks the compiler to pass the actual parameters by value.

EA function is deterministic if it always returns the same result for a specific combination of input values.

FThe PARALLEL_ENABLE clause can be specified for a nested function.

GA function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.

Show Answer

Correct Answer: B, E, G

Question No. 5

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

Free Oracle 1Z0-149 Exam Actual Questions

The questions for 1Z0-149 were last updated On May 4, 2024