Oracle Database: Advanced PL/SQL: 1Z0-148

Examine the following settings for a session:

PLSQL_CODE_TYPE = NATIVE

PLSQL_OPTIMIZE_LEVEL = 3

Which statement would be true in this scenario?

A. The compiler would automatically inline subprograms.

B. The compiler would inline the code for external subroutines.

C. The compiler would inline the code even if the INLINE pragma is set to NO.

D. The compiler would not inline the code unless the INLINE pragma is set to YES.

Which three statements are correct with reference to intra unit inlining?

A. Inlining will always decrease the size of a unit.

B. Setting PLSQL_OPTIMIZE_LEVEL to 2 means automatic inlining is attempted.

C. You cannot inline an external subroutine.

D. Programs that make use of smaller helper subroutines are good candidates for inlining.

E. Pragmas apply only to calls in the next statement following the pragma.

F. You cannot inline local subroutines.

Which two statements are true with respect to fine-grained access control?

A. It is implemented by end users.

B. It can be used to implement column masking.

C. It implements security rules through functions and associates these security rules with tables, views or synonyms.

D. Separate policies are required for queries versus INSERT/UPDATE/DELETE statements.

E. The DBMS_FGA package is used to set up fine-grained access control.