Which date function is used to find the difference between two dates?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between cold backup and hot backup?
You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
What is dba in sound level?
You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?
How can be determining the size of the log files?
What do you mean by oracle dba?
What is pga_aggregate_target?
What are bind variables and why are they important?
What are the main benefits of using spfile over pfile?
Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?
Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?