What are the values that can be specified for
OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?

Answer Posted / guest

CHOOSE,ALL_ROWS,FIRST_ROWS and RULE

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are a cluster and non-cluster index?

576


What happens in oracle commit?

568


How do you bind variables in oracle?

544


How to get a list of all user accounts in the database?

616


How to write a query with a left outer join in oracle?

605






Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

1656


How to rename an index in oracle?

616


What is a proxy object?

581


What is an oracle user role?

569


How to work with data objects interactively?

555


what's query optimization and without use of IN AND Exist can we get another way data from query

1668


If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1659


Explain an extent?

657


Whats the benefit of dbms_stats over analyze?

1497


What is a read only transaction in oracle?

596