What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?

1 Answers  

---

Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks

2 Answers  

---

Explain the difference between replace() and translate() functions in oracle?

0 Answers  

---

Is oracle the best database?

0 Answers  

---

what is the difference between dbms and rdbms?

3 Answers   Oracle,

---

How to create a new table by selecting rows from another table?

0 Answers  

---

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

0 Answers  

---

What are the varoius components of physical database structure of oracle database?

0 Answers  

---

i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?

2 Answers   Microsoft,

---

What is an oracle function?

0 Answers  

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

---

what is the difference between functional dependecy and multilevel dependency?

0 Answers   Oracle,

---