READ Free Dumps For Oracle- 1z0-060
| Question ID 2201 |
|
| Option A | A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics. |
| Option B | B. The optimizer can re optimize a query only once using cardinality feedback. |
| Option C | C. The optimizer enables monitoring for cardinality feedback after the first execution of a query. |
| Option D | D. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled. |
| Option E | E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer. |
| Correct Answer | A,,C,D |
| Question ID 2202 | Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In UNIX? |
| Option A | A. Thread creation must be routed through a dispatcher process |
| Option B | B. The local listener may spawn a now process and have that new process create a thread |
| Option C | C. Each Oracle process runs an SCMN thread. |
| Option D | D. Each multithreaded Oracle process has an SCMN thread. |
| Option E | E. The local listener may pass the request to an existing process which in turn will create a thread. |
| Correct Answer | A,D,E |