What are the values that can be specified for OPTIMIZER
MODE Parameter ?



What are the values that can be specified for OPTIMIZER MODE Parameter ?..

Answer / guest

COST and RULE

Is This Answer Correct ?    3 Yes 3 No

Post New Answer

More Oracle General Interview Questions

What is Trace File ?

4 Answers   Thermotech,


write a query that displays every Friday in a year with date?

5 Answers   Flipkart, HCL, TCS,


how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group

2 Answers   Verizon,


What are Schema Objects ?

2 Answers  


What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)

3 Answers  






Query to get max and second max in oracle in one query ?

34 Answers   CTS, Keane India Ltd, TCS, Wipro,


I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

0 Answers   EDC,


What are the commands youd issue to show the explain plan for select

2 Answers  


3. Display all the client numbers in the ORDER table. Remove duplicates.

1 Answers   Wipro,


How to define a procedure inside another procedure?

0 Answers  


Explain self joins in oracle?

0 Answers  


What is a Shared SQL pool ?

2 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)