What is the effect of setting the value of OPTIMIZER_MODE
to 'RULE' ?
Answer / guest
This value causes the optimizer to choose the rule_based
approach for all SQL statements issued to the instance
regardless of the presence of statistics.
| Is This Answer Correct ? | 0 Yes | 1 No |
How to create DSN..Explain?
2 Answers Accenture, BeBo Technologies, Infosys,
What is oracle server autotrace in oracle?
dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.
Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions
What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How to generate query output in html format?
What is the difference between I and G in Oracle?
How to create a table index in oracle?
Explain database link?
which sql command we can use to get a print out from oracle?
what is RAID technology?which is better RAID 0+1 OR RAID 5?