ExamTopics Logo
Mail Us[email protected]
Menu
 

1z0-146 Actual Exam Questions

Last updated on Dec. 3, 2024.
Vendor:Oracle
Exam Code:1z0-146
Exam Name:Oracle Database 11g Advanced PLSQL
Exam Questions:117
97% Passed the exam with this material
 

Topic 1 - Single Topic

Question #1 Topic 1

Which two statements are true about the inlining of PL/SQL subprograms? (Choose two.)

  • A. Only local subroutines can be inlined
  • B. Inlining always reduces the execution time of a PL/SQL program unit
  • C. PLSQL_OPTIMIZE_LEVEL must be set to a value greater than or equal to 2
  • D. The PL/SQL programs that make use of relatively large helper subroutines are good candidates for inlining
Reveal Solution Hide Solution   Discussion   1

Correct Answer: AC 🗳️

Question #2 Topic 1

Which three statements are true about hierarchical profiling? (Choose three.)

  • A. It reduces function-level summaries
  • B. It produces an aggregated report of the SQL and PL/SQL execution times
  • C. It is useful for understanding the structure and control flow of complex programs
  • D. It can be used to identify hotspots and tuning opportunities in PL/SQL applications
Reveal Solution Hide Solution   Discussion  

Correct Answer: ACD 🗳️

Question #3 Topic 1

Which three actions can be performed by using the DBMS_ASSERT package to prevent SQL injection? (Choose three.)

  • A. Detect a wrong user
  • B. Check input string length
  • C. Verify qualified SQL names
  • D. Validate TNS connect strings
  • E. Verify an existing schema name
  • F. Enclose string literals within double quotations marks
Reveal Solution Hide Solution   Discussion  

Correct Answer: CEF 🗳️

Question #4 Topic 1

Identify the method that is used by fine-grained access(FGA).

  • A. Using policy functions to generate predicates dynamically
  • B. Creating triggers on corresponding tables to generate dynamic predicates
  • C. Modifying the existing application code to include a predicate for all SQL statements
  • D. Creating views with necessary predicates and then creating synonyms with the same name as the tables
Reveal Solution Hide Solution   Discussion  

Correct Answer: A 🗳️

file Viewing page 1 out of 30 pages.
Viewing questions 1-4 out of 117 questions
Next Questions
Browse atleast 50% to increase passing rate cup
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago