D is probably the answer, but most of the time oracle will choose nested loop.
Beware the OCP tuning test. It is completely and totally inaccurate. I emailed the author of the Sybex tuning book and he agreed with me. He said he wrote the book to the test and knows its garbage. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, January 06, 2004 1:44 PM > Hello: > > I was looking through some OCP questions posted on the web and came across > the one below. > I believe the answer is (D), because the join type would be dependent on the > number of rows within the table. Is this correct or does the OPTIMIZER_MODE > set to FIRST_ROWS alter this behavior? > > > 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. > > _________________________________________________________________ > Check your PC for viruses with the FREE McAfee online computer scan. > http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jay Wade > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
