How many memory layers are in the oracle shared pool?
No Answer is Posted For this Question
Be the First to Post Answer
What is Hash Cluster ?
how will I find the first 5 highest salaried employees in each dept in oracle.
How would you design a database for an e-commerce website?
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 are the advantages of oracle?
How to create a new table in your schema?
What is literal?
can you write commit in triggers?
Is oracle a programming language?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
how to find the second highest salary in a given table????
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.