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

Oracle 1z0-146 Exam Practice Questions (P. 1)

  • Full Access (117 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 #1
Which two statements are true about the inlining of PL/SQL subprograms? (Choose two.)
  1. A
    Only local subroutines can be inlined
  2. B
    Inlining always reduces the execution time of a PL/SQL program unit
  3. C
    PLSQL_OPTIMIZE_LEVEL must be set to a value greater than or equal to 2
  4. D
    The PL/SQL programs that make use of relatively large helper subroutines are good candidates for inlining

Correct Answer:
AC

Question #2
Which three statements are true about hierarchical profiling? (Choose three.)
  1. A
    It reduces function-level summaries
  2. B
    It produces an aggregated report of the SQL and PL/SQL execution times
  3. C
    It is useful for understanding the structure and control flow of complex programs
  4. D
    It can be used to identify hotspots and tuning opportunities in PL/SQL applications

Correct Answer:
ACD

Question #3
Which three actions can be performed by using the DBMS_ASSERT package to prevent SQL injection? (Choose three.)
  1. A
    Detect a wrong user
  2. B
    Check input string length
  3. C
    Verify qualified SQL names
  4. D
    Validate TNS connect strings
  5. E
    Verify an existing schema name
  6. F
    Enclose string literals within double quotations marks

Correct Answer:
CEF

Question #4
Identify the method that is used by fine-grained access(FGA).
  1. A
    Using policy functions to generate predicates dynamically
  2. B
    Creating triggers on corresponding tables to generate dynamic predicates
  3. C
    Modifying the existing application code to include a predicate for all SQL statements
  4. D
    Creating views with necessary predicates and then creating synonyms with the same name as the tables

Correct Answer:
A

Question #5
See the Exhibit and examine the PL/SQL code for the following table:

Which statement is true about the compilation and execution of the function?
  1. A
    The function retrieves the metadata in Extensible Markup Language (XML) format for creating the TIMECARDS table in the HR schema
  2. B
    The compilation produces an error because DBMS_METADATA.SET_FILTER(h,'SCHEMA','HR') is not placed in the correct order
  3. C
    The function retrieves the metadata as a data definition language (DDL) statement for creating the TIMECARDS table in the HR schema
  4. D
    The execution of the function produces an error because multiple objects are fetched and DBMS_METADATA.FETCH_CLOB is not called in a LOOP

Correct Answer:
C

Next Questions

All Pages