READ Free Dumps For Oracle- 1z0-050
| Question ID 1847 | 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 | A. The optimizer adds the new plan to the plan history. |
| Option B | B. The optimizer selects the new plan for the execution of the SQL statement. |
| Option C | C. The optimizer adds the new plan to the SQL plan baseline as an accepted plan. |
| Option D | D. The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state. |
| Option E | 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 1848 | Which two statements about Oracle Direct Network File System (NFS) are true? (Choose two.) |
| Option A | A. It bypasses the OS file system cache |
| Option B | B. A separate NFS interface is required for use across Linux, UNIX, and Windows platforms. |
| Option C | C. It uses the operating system kernel NFS layer for user tasks and network communication modules. |
| Option D | D. File systems need not be mounted by the kernel NFS system when being served through Direct NFS. |
| Option E | E. Oracle Disk Manager can manage NFS on its own, without using the operating system kernel NFS driver. |
| Correct Answer | A,D |