Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-149

Oracle 1z0-149 Exam Practice Questions (P. 1)

  • Full Access (65 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #1
Which two PL/SQL elements can be deprecated using the DEPRECATE pragma? (Choose two.)
  1. A
    PACKAGES
  2. B
    VARIABLES
  3. C
    ANONYMOUS BLOCK
  4. D
    TRIGGER BODY
  5. E
    DATABASE LINKS

Correct Answer:
AB

Question #2
Which three are true about functions and procedures? (Choose three.)
  1. A
    The ACCESSIBLE BY clause can be used only for procedures.
  2. B
    In a function, every execution path must lead to a RETURN statement.
  3. C
    Both can have only constants as actual parameters for IN mode parameters.
  4. D
    Both can be invoked from within SQL statements.
  5. E
    In a procedure the RETURN statement cannot specify an expression.
  6. F
    In a function every RETURN statement must specify an expression.

Correct Answer:
BEF

Question #3
Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.)
  1. A
    PL/SQL code can be compiled and executed based on different versions of the operating system.
  2. B
    PL/SQL code can be compiled and executed based on different versions of Oracle.
  3. C
    It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.
  4. D
    Conditional compilation is disabled by default.
  5. E
    The PL/SQL compiler can conditionally include selected parts of a program.

Correct Answer:
BE

Question #4
Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.)
  1. A
    The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.
  2. B
    The NOCOPY hint asks the compiler to pass the actual parameters by reference.
  3. C
    A deterministic function's results always depend on the state of session variables.
  4. D
    The NOCOPY hint asks the compiler to pass the actual parameters by value.
  5. E
    A function is deterministic if it always returns the same result for a specific combination of input values.
  6. F
    The PARALLEL_ENABLE clause can be specified for a nested function.
  7. 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.

Correct Answer:
BEG

Question #5
Which two are true about INDEX-BY tables? (Choose two.)
  1. A
    The index can be integer or string.
  2. B
    The index can be integer only.
  3. C
    INDEX-BY table types can be created in PL/SQL blocks only.
  4. D
    INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.
  5. E
    INDEX-BY table types can be created with the CREATE TYPE statement.

Correct Answer:
AC

Next Questions

All Pages