READ Free Dumps For Oracle- 1z0-144
Question ID 2662 | In which of the following scenarios would you recommend using PL/SQL records? |
Option A | A. when you want to retrieve an entire row from a table and perform calculations |
Option B | B. when you know the number of elements in advance and the elements are usually accessed sequentially |
Option C | C. when you want to create a separate lookup table with multiple entries for each row of the main table, and access it through join queries |
Option D | D. when you want to create a relatively small lookup table, where the collection can be constructed in memory each time a subprogram is invoked |
Correct Answer | C,D |
Question ID 2663 | View the Exhibit and examine the structure of the employees table. |
Option A | A. It gives an error because group functions cannot be used in anonymous blocks |
Option B | B. Itexecutes successfully and correctly gives the result of the sum of salaries in department 60. |
Option C | C. It executes successfully and incorrectly gives the result of the sum of salaries in department 60. |
Option D | D. It gives an error because the variable name and column name are the same in the where clause of the select statement. |
Correct Answer | C |