ExamTopics Logo
Mail Us[email protected]
Menu
 

1z0-149 Actual Exam Questions

Last updated on Dec. 16, 2024.
Vendor:Oracle
Exam Code:1z0-149
Exam Name:Oracle Database Program with PL/SQL
Exam Questions:65
97% Passed the exam with this material
 

Topic 1 - Exam A

Question #1 Topic 1

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

  • A. PACKAGES
  • B. VARIABLES
  • C. ANONYMOUS BLOCK
  • D. TRIGGER BODY
  • E. DATABASE LINKS
Reveal Solution Hide Solution   Discussion   6

Correct Answer: AB 🗳️

Question #2 Topic 1

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

  • A. The ACCESSIBLE BY clause can be used only for procedures.
  • B. In a function, every execution path must lead to a RETURN statement.
  • C. Both can have only constants as actual parameters for IN mode parameters.
  • D. Both can be invoked from within SQL statements.
  • E. In a procedure the RETURN statement cannot specify an expression.
  • F. In a function every RETURN statement must specify an expression.
Reveal Solution Hide Solution   Discussion   3

Correct Answer: BEF 🗳️

Question #3 Topic 1

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

  • A. PL/SQL code can be compiled and executed based on different versions of the operating system.
  • B. PL/SQL code can be compiled and executed based on different versions of Oracle.
  • C. It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.
  • D. Conditional compilation is disabled by default.
  • E. The PL/SQL compiler can conditionally include selected parts of a program.
Reveal Solution Hide Solution   Discussion   2

Correct Answer: BE 🗳️

Question #4 Topic 1

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

  • A. The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.
  • B. The NOCOPY hint asks the compiler to pass the actual parameters by reference.
  • C. A deterministic function's results always depend on the state of session variables.
  • D. The NOCOPY hint asks the compiler to pass the actual parameters by value.
  • E. A function is deterministic if it always returns the same result for a specific combination of input values.
  • F. The PARALLEL_ENABLE clause can be specified for a nested function.
  • 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.
Reveal Solution Hide Solution   Discussion   3

Correct Answer: BEG 🗳️

file Viewing page 1 out of 17 pages.
Viewing questions 1-4 out of 65 questions
Next Questions
Browse atleast 50% to increase passing rate cup
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago