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-144

Oracle 1z0-144 Exam Practice Questions (P. 3)

  • Full Access (112 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 #11
Identify two situations where the DBMS_SQL package should be used. (Choose two.)
  1. A
    The SELECT list is not known until run time.
  2. B
    The dynamic SQL statement retrieves rows into records.
  3. C
    You do not know how many columns a select statement will return, or what their data types will.
  4. D
    You must use the % found SQL cursor attribute after issuing a dynamic SQL statement that is an insert or update statement.

Correct Answer:
AC

Question #12
View the Exhibit and examine the code.

Why does the code give an error on execution?
  1. A
    because the WORD_LIST variable is not visible in procedure wording
  2. B
    because the lexicon variable is not visible in procedure ADD_ENTRY
  3. C
    because the lexicon variable is not initialized in procedure wording
  4. D
    because the WORD_LIST parameter in out mode cannot be of a record data type

Correct Answer:
A

Question #13
View the Exhibit and examine the structure of the EMP table.

Which stages are performed when the above block is executed? (Choose all that apply)
  1. A
    Bind
  2. B
    Parse
  3. C
    Fetch
  4. D
    Execute

Correct Answer:
BCD

Question #14
View the Exhibit and examine the structure of the EMP table.

You want to create two procedures using the overloading feature to search for employee details based on either the employee name or employee number.
Which two rules should you apply to ensure that the overloading feature is used successfully? (Choose two.)
  1. A
    The procedures can be either stand-alone or packaged.
  2. B
    The procedures should be created only as packaged subprograms.
  3. C
    The procedures should be created only as stand-alone subprograms.
  4. D
    Each subprogram's formal parameters should differ in both name and data type.
  5. E
    The formal parameters of each subprogram should differ in data type but can use the same names.

Correct Answer:
BE

Question #15
Which two statements are true about the instead of triggers? (Choose two.)
  1. A
    Delete operations cannot be performed using the instead of triggers.
  2. B
    The instead or triggers must be created to add or modify data through any view.
  3. C
    The instead of triggers can be written only for views, and the before and after timing options are not valid.
  4. D
    The check option for views is not enforced when Insertions or updates to the view are performed by using the instead of triggers.

Correct Answer:
CD
References:

Previous Questions Next Questions

All Pages