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

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

  • Full Access (75 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
Examine this function header:
FUNCTION calc_new_sal (emp_id NUMBER) RETURN NUMBER;
You want to ensure that whenever this PL/SQL function is invoked with the same parameter value across active sessions, the result is not recomputed.
If a DML statement is modifying a table which this function depends upon, the function result must be recomputed at that point in time for all sessions calling this function.
Which two actions should you perform?
  1. A
    Ensure RESULT_CACHE_MAX_SIZE is greater than 0.
  2. B
    Enable the result cache by using DBMS_RESULT_CACHE.BYPASS (FALSE).
  3. C
    Add the deterministic clause to the function definition.
  4. D
    Add the RELIES_ON clause to the function definition.
  5. E
    Add the RESULT_CACHE clause to the function definition.

Correct Answer:
AC

Question #12
Examine this block:

Which two will be correct after line 5?
  1. A
    va. LAST and va. LIMIT will return the same value.
  2. B
    va. LAST and va. COUNT will return the same value.
  3. C
    va. LIMIT and va. COUNT will return the same value.
  4. D
    va. LIMIT and va. NEXT (199) will return the same value.
  5. E
    va. LAST will return 200.
  6. F
    va. NEXT (199) will return NULL.

Correct Answer:
AC

Question #13

Examine this code:

You want to display the contents of CREATE_LIST.
Which two lines need to be corrected in the PL/SQL block?
  1. A
    Line 2
  2. B
    Line 3
  3. C
    Line 5
  4. D
    Line 6
  5. E
    Line 7

Correct Answer:
BD

Question #14
Examine the following SQL statement:
ALTER SESSION SET PLSQL_OPTIMIZE_LEVEL=3;
What is the result of executing this statements?
  1. A
    The PL/SQL optimize level for some existing PL/SQL units will be changed as an immediate result.
  2. B
    The PL/SQL optimize level for subsequently complied PL/SQL units will be set to 3 and inlining will be enabled.
  3. C
    The PL/SQL optimize level for subsequently compiled PL/SQL units will be set to 3 and inlining will be disabled.
  4. D
    This statement will fail because PLSQL_OPTIMIZE_LEVEL can only be set at the system level,

Correct Answer:
C

Question #15
Which two statements describe actions developers can take to make their application less vulnerable to security attacks?
  1. A
    Include the AUTHID DEFINER clause in stored program units.
  2. B
    Do not concatenate unchecked user input into dynamically constructed SQL statements.
  3. C
    Switch from using DBMS_SQL to EXECUTE IMMEDIATE.
  4. D
    Include the AUTHID CURRENT_USER clause in stored program units.
  5. E
    Increase the amount of code that is accessible to users by default.

Correct Answer:
BD

Previous Questions Next Questions

All Pages