Create Next App

Exam contains 65 questions

Page 1 of 11

Question 1 🔥

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

Which database solution meets these requirements?

A. The ACCESSIBLE BY clause can be used only for procedures.

Highly voted

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

Highly voted

C. Both can have only constants as actual parameters for IN mode parameters.

Highly voted

D. Both can be invoked from within SQL statements.

Highly voted

E. In a procedure the RETURN statement cannot specify an expression.

Highly voted

F. In a function every RETURN statement must specify an expression.

Highly voted

Discussion of the question

Question 2 🔥

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

Which database solution meets these requirements?

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

Highly voted

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

Highly voted

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

Highly voted

D. Conditional compilation is disabled by default.

Highly voted

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

Highly voted

Discussion of the question

Question 3 🔥

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

Which database solution meets these requirements?

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

F. The PARALLEL_ENABLE clause can be specified for a nested function.

Highly voted

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

Highly voted

Discussion of the question

Question 4 🔥

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

Which database solution meets these requirements?

A. The index can be integer or string.

Highly voted

B. The index can be integer only.

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

Discussion of the question

Question 5 🔥

Which three are true about anonymous blocks and subprograms? (Choose three.)

Which database solution meets these requirements?

A. Named subprograms cannot be called from other packages.

Highly voted

B. PROCEDURE subprograms can accept parameters.

Highly voted

C. A FUNCTION subprogram must return one or more values.

Highly voted

D. Anonymous blocks cannot use packaged variables.

Highly voted

E. Named subprograms are stored in the database server.

Highly voted

F. Anonymous blocks must always start with the Declare keyword.

Highly voted

G. FUNCTION subprograms must be called and passed through one or more parameters.

Highly voted

Discussion of the question

Question 6 🔥

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

Which database solution meets these requirements?

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_149

Exam contains 65 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us