READ Free Dumps For Oracle- 1z0-050
| Question ID 6083 | You are managing an Oracle Database 11 g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statements regarding the ASM disk group compatibility attributes are true in this scenario? (Choose all that apply.) |
| Option A | ASM compatibility controls which features for the ASM will be enabled. |
| Option B | RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group |
| Option C | The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk. |
| Option D | The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances. |
| Correct Answer | A,B,D |
| Question ID 6084 | Evaluate the following function code: CREATE FUNCTION get_dept_avg(dept_id NUMBER) RETURN NUMBER RESULT_CACHE RELIES_ON (EMPLOYEES) IS avgsal NUMBER(6); BEGIN SELECT AVG(SAU\RY)INTO avgsal FROM EMPLOYEESWHERE DEPARTMENTJD = dept_id; RETURN avgsal; END get_dept_avg; Which statement is true regarding the above function? |
| Option A | The cached result becomes invalid when any structural change is done to the EMPLOYEES table. |
| Option B | If the function execution results in an unhandled exception, the exception result is also stored in the cache. |
| Option C | Each time the function is invoked in a different session, the current result in the result cache gets overwritten. |
| Option D | If the function is invoked with a different parameter value, the existing result in the result cache gets overwritten by the latest value. |
| Correct Answer | A |