READ Free Dumps For Oracle- 1z0-144
| Question ID 2684 |
|
| Option A | A. It generates an error because all the blocks of code in a package body must be named. |
| Option B | B. It generates an error because V_TAXRATE is a public variable that is already initialized in the package specification. |
| Option C | C. It acts as a package initialization block that executes once, when the package is first invoked within the user session. |
| Option D | D. It acts as a package initialization block that executes each time a package subprogram is invoked within the user session and refreshes the initialized variablevalue. |
| Correct Answer | C |
| Question ID 2685 | Which two statements are true about the %ROWTYPE attribute? (Choose two.) |
| Option A | A. It is used to declare a record that can hold multiple rows of a table. |
| Option B | B. The attributes of fields in the record with the %ROWTYPE attributecan be modified manually. |
| Option C | C. The attributes of fields in the record take their names and data types from the columns of the |
| Option D | D. It ensures that the data types of the variables that are declared with the %ROWTYPE attribute change dynamically when the underlying table is altered. |
| Correct Answer | c |