Oracle PL/SQL Programming: A Developer's Workbook

Expert

29-28.

Match the following V$ views to their proper description: View: V$ROWCACHE V$LIBRARYCACHE V$SQLAREA V$DB_OBJECT_CACHE Description: Contains the number of times an element has been loaded into the SGA, its number of executions, whether it has been pinned, and whether it has been referenced but not loaded Contains object access cache “hits and misses” Contains statistics on the shared SQL area, one row per string Contains data dictionary cache “hits and misses”

29-29.

The following program creates an index-by table holding a schedule of lease payments. The payment for each year is calculated as the sum of lease amounts for the remaining years. In other words, the total lease for year 10 consists of the lease amounts (fixed and variable) for years 10 through 20. Assuming that the functions pv_of_fixed and pv_of_variable are defined elsewhere, can you improve the program? /* Filename on web page: presvalue.sp */ /* Construct present value lease schedule over 20 years. */ PROCEDURE build_lease_schedule IS /* Temporary variable to hold lease accumulation. */ pv_total_lease NUMBER (9); BEGIN fixed_count := 0; var_count := 0; FOR year_count IN 1 .. 20 LOOP /* Reset the lease amount for this year. */ pv_total_lease := 0; /* || Build the PV based on the remaining years || plus the fixed and variable amounts. */ FOR year_count2 IN year_count .. 20 LOOP /* Add annual total lease amount to cummulative. ...