Interested to Buy Any Domain ? << Click Here >> for more details...
What is the effect of setting the 'RULE' for OPTIMIER_GOAL
parameter of the ALTER SESSION Command ?
- 1 Answers
- 3852 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
This value causes the optimizer to choose the rule-based
approach for all SQL statements in a session regardless of
the presence of statistics
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Explain parameter file in oracle.
Explain the use of record option in exp command.
Compare and contrast between sql and sql server and explain its various functions?
Is oracle an open source?
What is the best way to do multi-row insert in oracle?
How to define a variable of a specific record type?
What is the difference between formal parameters and actual parameters?
What happens to the data files if a tablespace is dropped?
What is the scope of a local variable?
What is where clause in oracle?
Explain the use of constraints option in exp command.
Name the various constraints used in oracle?
Differentiate between function and procedure in oracle.
What happens if the update subquery returns multiple rows?
