If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
2292Hi 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 5669Post New Oracle General Questions
When do you get a .pll extension in oracle?
What is not equal to in oracle?
Explain what are the advantages of views?
Explain the difference between replace() and translate() functions in oracle?
What is the relation of a user account and a schema in oracle?
How to loop through data rows in the implicit cursor?
How do I learn what codesets are available in oracle?
How many categories of data types in oracle?
What are the uses of a database trigger?
What are the most common interview questions on ETL Testing for experience?
What are the different types of trigger and explain its various uses and functions?
What privilege is needed for a user to create indexes in oracle?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
6. Display the client name and order date for all orders using the traditional method.
11. Display the client number and name and the client number and name of the person who referred that client.