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

  • 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 #6
What is the correct definition of the persistent state of a packaged variable?
  1. A
    It is a private variable defined in a procedure or function within a package body whose value is consistent within a user session.
  2. B
    It is a public variable in a package specification whose value is consistent within a user session.
  3. C
    It is a private variable in a package body whose value is consistent across all current active sessions.
  4. D
    It is a public variable in a package specification whose value is always consistent across all current active sessions.

Correct Answer:
B

Question #7
Examine the following block of code:

Which line in the above code would result in errors upon execution?
  1. A
    line 5
  2. B
    line 8
  3. C
    line 2
  4. D
    line 7

Correct Answer:
B

Question #8
View the Exhibit and examine the structure of the customer table.

Examine the following trigger code:

What is the outcome when the above trigger is compiled?
  1. A
    It compiles successfully.
  2. B
    It gives an error because the when condition is not valid.
  3. C
    It gives an error because when cannot be used for row-level triggers.
  4. D
    It gives an error because the statements under updating are not valid.
  5. E
    It gives an error because the new qualifier in the when clause requires a colon prefix.

Correct Answer:
A

Question #9
Which statements are true about PL/SQL procedures? (Choose all that apply.)
  1. A
    Users with definer's rights who are granted access to a procedure that updates a table must be granted access to the table itself.
  2. B
    Reuse of parsed PL/SQL code that becomes available in the shared SQL area of the server avoids the parsing overhead of SQL statements at run time.
  3. C
    Depending on the number of calls, multiple copies of the procedure are loaded into memory for execution by multiple users to speed up performance.
  4. D
    A PL/SQL procedure executing on the Oracle database can call an external procedure or function that is written in a different programming language, such as

Correct Answer:
BD

Question #10
The STRING_TAB table has the following structure:

View the Exhibit and examine the code.

What is the outcome on execution?
  1. A
    It displays Output buffer not long enough. This is my test string.-.
  2. B
    It displays only Output buffer not long enough, and exits the anonymous block.
  3. C
    It displays only This is my test string. - Because EXCEPTION should have been defined in the anonymous block to get the error message.
  4. D
    It does not display any of the MEMS_PUTPUT messages and gives an error because a transaction control statement cannot be used in the exception section

Correct Answer:
A

Previous Questions Next Questions

All Pages