Interested to Buy Any Domain ? << Click Here >> for more details...
What are bind variables and why are they important?
- 0 Answers
- 506 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?
Explain the various modes of normalization?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?
What is the difference between truncate and delete? Why is one faster?
What are the beneficial tools for administering the database?
using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?
What os user should be used for the first part of an oracle installation (on unix)?
What are the possible ways to gain information regarding the control file?
What does the no logging option do? Why would we be careful of using it?
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?
Oracle General 
