READ Free Dumps For Oracle- 1z0-117
| Question ID 2552 | You execute the following query: |
| Option A | A. The optimizer pushes the join predicate into the inline view. |
| Option B | B. The optimizer evaluates the subquery as a first and then filters out rows. |
| Option C | C. The optimizer performs a join operation first and then filters out the rows. |
| Option D | D. The hint will have no effect because one of the join resultsets is an inline view. |
| Correct Answer | A |
| Question ID 2553 | Examine the initialization parameters for a database an OLTP overload. |
| Option A | A. It influences the optimizer to always use the value of the parameter? |
| Option B | B. It influences the optimizer to use indexes instead of full table scans as the estimated cost of the using index is reduced. |
| Option C | C. It influences the optimizer to use full table scans instead of index scans as the estimated cost of full table scan is reduced. |
| Option D | D. It influenced the optimizer to use bitmap indexes as the estimated cost conversion from bimap is rowed us reduced. |
| Correct Answer | B |
