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. 2)

  • 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 #6
Which three are true about anonymous blocks and subprograms? (Choose three.)
  1. A
    Named subprograms cannot be called from other packages.
  2. B
    PROCEDURE subprograms can accept parameters.
  3. C
    A FUNCTION subprogram must return one or more values.
  4. D
    Anonymous blocks cannot use packaged variables.
  5. E
    Named subprograms are stored in the database server.
  6. F
    Anonymous blocks must always start with the Declare keyword.
  7. G
    FUNCTION subprograms must be called and passed through one or more parameters.

Correct Answer:
BCE

Question #7
Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)
  1. A
    Function based indexes remain usable when replacing the function on which the index depends.
  2. B
    Object privileges to execute a replaced function must be regranted to those users who had the privilege.
  3. C
    This clause can be used only for procedures and functions.
  4. D
    A function definition can be modified without dropping and re-creating it.
  5. E
    Object privileges to execute a replaced function are retained by those users who had the privileges.

Correct Answer:
DE

Question #8
Examine the SH.PRODUCTS table:

A row exists in SH.PRODUCTS with PDT_ID = 1.
Now, examine this code and output executed by SH:

Now, examine this block of code:

Which error message(s) does it display on execution by user SH?
  1. A
    Error in inner block
  2. B
    Error in inner block Error in outer block
  3. C
    Error in inner block Error in calling block
  4. D
    Error in inner block Error in outer block Error in calling block

Correct Answer:
A

Question #9
Which two blocks of code display a numerical zero? (Choose two.)
  1. A
  2. B
  3. C
  4. D

Correct Answer:
AB

Question #10
Which three are valid PL/SQL variable names? (Choose three.)
  1. A
    printer_name#
  2. B
    1to7number
  3. C
    yesterday's_date
  4. D
    leap$year
  5. E
    Number_of_days_between_March_and_April
  6. F
    #printer_name
  7. G
    v_fname

Correct Answer:
ADG

Previous Questions Next Questions

All Pages