Oracle Database 12c: Advanced PL/SQL Free Sample Questions

Description

Covers PL/SQL result caching, SQL injection protection, bulk processing and inlining performance techniques, collections and LOB data types, advanced cursors, Java and C integration, and dynamic SQL.

12 free sample questions74 in the full practice test Other version: 1Z0-149(246)

Try simulator

1z0-148 Sample Questions

  1. Question 1

    Which must be true in order to add RESULT_CACHE to a function header and have it compile successfully?

    Answer and explanation

    Correct answer: A

    Reference: https://docs.oracle.eom/cd/E18283 01/appdev.112/e17126/subprograms.htm#insertedlD11

  2. Question 2

    Multiple answers

    You created a PL/SQL function with the RESULT_CACHE clause, which calculates a percentage of total marks for each student by querying the MARKS table.

    Under which two circumstances will the cache for this function not be used and the function body be executed instead? (Choose two.)

    Answer and explanation

    Correct answers: D, E

    D, E

  3. Question 3

    Multiple answers

    Which two blocks of code execute successfully? (Choose two.)

    Answer and explanation

    Correct answers: A, D

    A, D

  4. Question 4

    Examine this Java method in class Employee, loaded into the Oracle database:

    public static int updateSalary ( String name, float salary) { . . . }

    Which PL/SQL function specification can be used to publish this method?

    Answer and explanation

    Correct answer: D

    D

  5. Question 5

    Multiple answers

    Examine this code:

    Which two are valid correlations to the code to avoid or mitigate SQL Injection? (Choose two.)

    Question 5 image
    Answer and explanation

    Correct answers: B, D

    B, D

  6. Question 6

    Examine this external function declaration:

    Which C function does it publish?

    Question 6 image
    Answer and explanation

    Correct answer: F

    F

Register free for 6 more questions

Or unlock all 74 1z0-148 questions with explanations, timed mode and flashcards.