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
What are a cluster and non-cluster index?
What happens in oracle commit?
How do you bind variables in oracle?
How to get a list of all user accounts in the database?
How to write a query with a left outer join in oracle?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
How to rename an index in oracle?
What is a proxy object?
What is an oracle user role?
How to work with data objects interactively?
what's query optimization and without use of IN AND Exist can we get another way data from query
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?
Explain an extent?
Whats the benefit of dbms_stats over analyze?
What is a read only transaction in oracle?