What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
2 3381What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
1 3620What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?
1 2933Difference between primary key and unique key ?
Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions,
77 189790Post New Oracle General Questions
What is a table index in oracle?
Can you assign multiple query result rows to a variable?
What is the usage of save points in oracle database?
How to upsert (update or insert into a table)?
Why does for update in oracle 8 cause an ora-01002 error?
What to do if the binary spfile is wrong for the default instance?
What is the meaning of recursive hints in oracle?
Explain mutating triggers.
Is oracle a relational database?
What is max rowid in oracle?
How many anonymous blocks can be defined?
what is normalisation?what are its uses?
What is translate in oracle?
What is the best way to do multi-row insert in oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.