Re: OCP - Performance Tuning

4. The weather in Marseilles can be windy and cold (if the Mistral

   blows) or windy but dry, warm and dusty if the Simoun brings us    tons of sand from northern Africa's coast. Today it's been    rather wet with clouds and small showers here and there but when    we look north we can see sunny spells. We're in September. How    will it be tomorrow in Marseilles and its area?

1. There will be thunderstorms.
2. It'll be cold and cloudless.
3. It depends on the sea's temperature.
4. It depends on downtown traffic (and thus on pollution).

> If you were taking the exam, which one would you put ?
>
> (NB - I didn't say "which one is correct?").
>
> 4. The cost-based optimizer can choose between a nested
> loops join and a sort merge join operation. All tables are
> analyzed and the OPTIMIZER_MODE is set to FIRST_ROWS.
> Which execution plan will be the result?
>
> a. The sort-merge join.
> b. The nested loops join.
> c. This depends on some sort parameter values.
> d. This depends on the number of rows in each table.
>
Received on Mon Feb 03 2003 - 09:44:21 CST