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

  • 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 #21
Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)
  1. A
    Implicit cursor returns only one record.
  2. B
    Explicit cursor can return more than one record.
  3. C
    %Isopen, %Rowtype, %Notfound, and %Found are the attributes of Explicit Cursor.
  4. D
    %Isopen, %Rowcount, %Notfound, and %Found are the attributes of Explicit Cursor.
  5. E
    %Isopen, %Type, %Notfound, and %Found are the attributes of Explicit Cursor.
  6. F
    %Isopen is always false in Explicit Cursor.
  7. G
    %Isopen is always false in Implicit Cursor.

Correct Answer:
BCG

Question #22
Which three are true about DDL triggers? (Choose three.)
  1. A
    They cannot include the WHEN clause.
  2. B
    They must be created in an enabled state.
  3. C
    They can be fired when a table is truncated.
  4. D
    They fire only when a DDL statement is executed by the owner of the trigger.
  5. E
    They can be fired either before or after a DDL statement executes.
  6. F
    They can be fired when a privilege is granted to a user.
  7. G
    They must be created in a disabled state.

Correct Answer:
CDE

Question #23
Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?
  1. A
  2. B
  3. C
  4. D

Correct Answer:
C

Question #24
In which type of trigger can :OLD and :NEW identifiers be used?
  1. A
    ROW
  2. B
    AFTER SUSPEND
  3. C
    AFTER STATEMENT
  4. D
    BEFORE STATEMENT

Correct Answer:
A

Question #25
Which three are true about PL/SQL subprograms? (Choose three.)
  1. A
    Results of a subprogram can be cached in the SGA such that sessions connected to the same instance can reuse these results when available.
  2. B
    Users granted execute privilege on a procedure compiled with definer's rights require grants to access objects belonging to the definer that are referenced in the procedure.
  3. C
    Subprograms are cached by default and shared among users, thereby reducing memory requirements.
  4. D
    Reuse of parsed PL/SQL code from the shared SQL area reduces parsing overhead.
  5. E
    A subprogram's session state is retained even if any of the session’s instantiated subprograms are invalidated and revalidated.
  6. F
    Host variables can be referenced inside any PL/SQL subprogram.
  7. G
    A PL/SQL procedure can invoke an external code block written in a different programming language.

Correct Answer:
CDG

Previous Questions Next Questions

All Pages