1z0-149 Questions and Answers

Question # 6

Which two blocks of code display a numerical zero? (Choose two.)

Full Access

Question # 7

Examine these statements issued by user SH which execute successfully:

DBMS_OUTPUT.PUT_LINE(p_price(i)); END LOOP; END; END products_pkg; /

Now, examine this anonymous block executed by SH:

Which is true about the anonymous block?

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.

Full Access

Question # 8

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

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

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

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

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

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

The PARALLEL_ENABLE clause can be specified for a nested function.

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

Full Access

Question # 9

Examine this DECLARE section:

Which two lines are valid? (Choose two.)

line 5

line 6

line 7

line 4

line 3

line 2

Full Access

DumpsTool Header