Quiz 1z0-146

Quiz 1Z0-146, Oracle Database 11g: Advanced PL/SQL

which two situations is the body of a result-cached function executed?

Identify the component of the PL/SQL hierarchical profiler that uploads the result of profiling into database tables.

Which of the above are valid definitions for associative arrays?

Examine the structure of the TEST_DETAILS table: Name Null?

Which of the above INSERT statements are valid?

Which two statements are true about the inlining of PL/SQL subprograms?

What could be the reason?

Which two statements are true about the usage of the DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure?

Identify two scenarios in which information is stored in the USAGE column

Which statement is true about the execution of the PROC1 procedure in this scenario?