Which two statements are true about associative arrays and varrays? (Choose two.) A. Only varrays must use sequential numbers as subscripts B. Only varrays can be used as column types in database tables C. Both assocaitive arrays and varrays must…

Which two statements are true about the SQL Query Result Cache? (Choose two.) A. It can store the query results for temporary tables B. It can be set at the system, session or query level C. It is used only…

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…

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…

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…

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…

Examine the following settings for a session: The compiler would automatically inline subprograms 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…