Explain the function of optimizer in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
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
What is Database Trigger ?
How can I get column names from a table in oracle?
What is rich query?
What do you mean by redo log file mirroring?
How to retrieve values from data fields in record variables?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
How to update a table row with a record?
After update how do u know how many records got updated
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
What is an oracle tablespace?
Can u make a synonym for deptno=10 only from emp table.