Oracle 11g Advanced PLSQL

You created a PL/SQL subprogram that successfully invokes an external C procedure. After a while, the database administrator (DBA) drops the alias library schema object. The shared library exists in the system. Which statement is true in this scenario?

The database instance was started up using the automatic memory management feature. No value was set for the RESULT_CACHE_MAX_SIZE parameter.
Examine the following initialization parameter settings for your database:
MEMORY_TARGET = 500M
RESULT_CACHE_MODE=MANUAL
You execute a query by using the result_cache hint. Which statement is true in this scenario?

Examine the following settings for a session:
Which statement would be true in this scenario?

What is the outcome?

Examine the structure of the BEST_DETAILS table:

DESCRIPTION dat was entered earlier and saved for TEST_ID 12.
You execute this PL/SQL block to add data to the end of the existing data in the DESCRIPTION column for TEST_ID 12;

It generates an error on execution.
What correction should you do to achieve the required result?

Which statements are true about internal LOBs? (Choose all that apply)

Examine the structure of the table:
What must be the value in the ADVT_SOURCE column for the above code to execute successfully?

The database instance was recently started up. Examine the following parameter settings for the database instance:
You reset the value for the result_cache_max_size parameter by issuing the following command:
Which statement is true in this scenario?

Examine the code snippet from the declarative section of a PL/SQL block: Which of the above are valid definitions for associative arrays? (Choose all that apply)

Which statement describes the purpose of the plshprof command?