READ Free Dumps For Oracle- 1z0-050
| Question ID 5995 | The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are performed by the optimizer in this scenario? (Choose two.) |
| Option A | The optimizer adds the new plan to the plan history. |
| Option B | The optimizer selects the new plan for the execution of the SQL statement. |
| Option C | The optimizer adds the new plan to the SQL plan baseline as an accepted plan. |
| Option D | The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state. |
| Option E | The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost. |
| Correct Answer | A,E |
| Question ID 5996 | Which two statements about Oracle Direct Network File System (NFS) are true? (Choose two.) |
| Option A | It bypasses the OS file system cache |
| Option B | A separate NFS interface is required for use across Linux, UNIX, and Windows platforms. |
| Option C | It uses the operating system kernel NFS layer for user tasks and network communication modules. |
| Option D | File systems need not be mounted by the kernel NFS system when being served through Direct NFS. |
| Option E | Oracle Disk Manager can manage NFS on its own, without using the operating system kernel NFS driver. |
| Correct Answer | A,D |