Oracle 1z0-146 Exam Actual Questions

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

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

Reveal 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