Wednesday 2 October 2019

Oracle 1Z0-148 Questions Answers

Which two statements are correct for collecting data about identifiers in PL/SQL source code?

A. CREATE < function/Procedure> PLSCOPE_SETTINGS = ‘IDENTIFIERS: ALL’ AS …
B. ALTER SYSTEM SET PLSCOPE_SETTINGS = ‘IDENTIFIERS: NONE’
C. ALTER SESSION SET PLSCOPE_SETTINGS = ‘IDENTIFIERS: NONE’
D. ALTER SESSION SET PLSCOPE_SETTINGS = ‘IDENTIFIERS: ALL’
E. ALTER <function/Procedure> COMPILE PLSCOPE_SETTINGS = ‘IDENTIFIERS: ALL’

Answer: A,D